carapplydbservice.java~3~

来自「车辆管理系统~其中包括了主要的增删改查的各项基本功能」· JAVA~3~ 代码 · 共 37 行

package bigwork.db;

import java.sql.*;

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

    public String Carapply(String Appname,String AppTel,String AppTimeOut,String AppTimeIn,String Carnum,String Cartype){
        Statement stmt = null;
        String message = "";
       try {

        String add = "insert into CARAPPLYDB(PERPOSER,TOUCH,INCEPTTIME,CLOSETIME,CARNNMBER,CARTYPE)values('" + Appname + "','" + AppTel +
                           "','" + AppTimeOut + "','" + AppTimeIn +
                           "','" + Carnum + "','" + Cartype + "')";

        stmt = con.createStatement();
        stmt.executeUpdate(add);
        boolean rows = stmt.execute(add);
                if (rows==false) {
                    message = "添加失败";

                } else {
                    message = "添加成功";
        }

        stmt.close();
        con.close();
    } catch (Exception ex) {
        ex.printStackTrace();
    }

        return message;
}

}