carapplydbservice.java~41~

车辆管理系统~其中包括了主要的增删改查的各项基本功能

package bigwork.db;
import java.sql.*;

public class CarapplyDBService {
    Connection con = new DB().getConn();

    public boolean CarapplyAdd(String Appname,String AppTel,String AppTimeOut,String AppTimeIn,String Carnum,String Cartype){
        Statement stmt = null;
        String State = "审批中";
        String suggestation = "无";
        String add = "insert into CARAPPLYDB(PERPOSER,TOUCH,INCEPTTIME,CLOSETIME,CARNNMBER,CARTYPE,ATTSTATE,SUGGETATION)values('" + Appname + "','" + AppTel +
                           "','" + AppTimeOut + "','" + AppTimeIn +
                           "','" + Carnum + "','" + Cartype + "','" + State + "','" + suggestation + "')";

    ResultSet rs=null;
    try {
        if(rs==null)
            stmt = con.createStatement();
            stmt.executeQuery(add);
            return true;


    } catch (SQLException ex) {
        System.out.println(ex.getMessage());
    }
    return false;

}

public boolean CarapplyUpdate(String name){
       Statement stmt = null;
       String State = "审批通过";
       String Update = "UPDATE CARAPPLYDB SET ATTSTATE='" + State + "' WHERE PERPOSER='" + name +"'";
       System.out.println(Update);
       ResultSet rs = null;
       try {
           if (rs == null)
               stmt = con.createStatement();
           stmt.executeUpdate(Update);
           return true;

       } catch (SQLException ex) {
           System.out.println(ex.getMessage());
       }
       return false;

}

   public boolean suggestationupdate(String name,String suggestation){
       Statement stmt = null;
       //String State = "审批通过";
       String Update = "UPDATE CARAPPLYDB SET SUGGETATION='" + suggestation + "' WHERE PERPOSER='" + name +"'";
       System.out.println(Update);
       ResultSet rs = null;
       try {
           if (rs == null)
               stmt = con.createStatement();
           stmt.executeUpdate(Update);
           return true;

       } catch (SQLException ex) {
           System.out.println(ex.getMessage());
       }
       return false;

}


public String[][] CarapplySearch(){
        String[][] datas = null;
        Statement stmt = null;
        try {
            stmt = con.createStatement();

            int count = 0;
            ResultSet rs = stmt.executeQuery("select count(*) from CARAPPLYDB");
            if (rs.next()) {
                count = rs.getInt(1);
            }
            rs.close();
            datas = new String[count][];
            int i = 0;
            rs = stmt.executeQuery("select * from CARAPPLYDB");
            while (rs.next()) {
                String name = rs.getString("PERPOSER");
                String tel = rs.getString("TOUCH");
                String timeout = rs.getString("INCEPTTIME");
                String tminin = rs.getString("CLOSETIME");
                String number = rs.getString("CARNNMBER");
                String type = rs.getString("CARTYPE");
                String state = rs.getString("ATTSTATE");
                datas[i] = new String[] {name,tel,number,type,timeout,tminin,state};

                i++;
                //System.out.println(number + "," + type + "," + SIZE);
            }
            rs.close();
            stmt.close();
            con.close();

        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        return datas;
}

    public String showsuggestation(String name){
        String suggestation = "";
        Statement stmt = null;
        try {
            stmt = con.createStatement();
            ResultSet rs = stmt.executeQuery("select SUGGETATION from CARAPPLYDB WHERE PERPOSER="+"'"+name+"'");

            suggestation = rs.getString("SUGGETATION");

            rs.close();
            stmt.close();
            con.close();

        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        return suggestation;
}


}