package com.wu.action;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import com.wu.Service.History;
import com.wu.util.DbUtil;
import com.wu.util.jsonUtil;

import net.sf.json.JSONArray;

public class HistoryImpl implements History {

	@Override
	public JSONArray selAll() {
		JSONArray jsonArray = null;
		String sql="select * from record";
		Connection conn = null;
		PreparedStatement pst = null;
		ResultSet rs = null;   
		try {
			conn=DbUtil.getConnection();
			pst = conn.prepareStatement(sql);
			rs = pst.executeQuery();
			jsonArray = jsonUtil.formatRsToJsonArray(rs);
			DbUtil.closeAll();
		} catch (Exception e) {
			// TODO 自动生成的 catch 块
			e.printStackTrace();
		}
		return jsonArray;
	}

	@Override
	public JSONArray search(String name) {
		JSONArray jsonArray = null;
		String sql="select * from record where CarName=?";
		Connection conn = null;
		PreparedStatement pst = null;
		ResultSet rs = null;   
		try {
			conn=DbUtil.getConnection();
			pst = conn.prepareStatement(sql);
			pst.setString(1, name);
			rs = pst.executeQuery();
			jsonArray = jsonUtil.formatRsToJsonArray(rs);
			DbUtil.closeAll();
		} catch (Exception e) {
			// TODO 自动生成的 catch 块
			e.printStackTrace();
		}
		return jsonArray;
	}

	@Override
	public boolean delete(String id) {
		Connection conn = null;
		PreparedStatement pst = null;
		int result = 0;        
		String sql="delete from  record  where Number=?";
		try {
			conn=DbUtil.getConnection();
			pst = conn.prepareStatement(sql);
			pst.setString(1, id);
			result = pst.executeUpdate();
			conn.setAutoCommit(true);
			DbUtil.closeAll();
			if(result!=0){
				return true;
			}
		} catch (Exception e) {
			// TODO 自动生成的 catch 块
			e.printStackTrace();
		}
		return false;
	}
   
   
    
}