carcircsdbservice.java~3~

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

package bigwork.db;

import java.sql.*;

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

    public boolean CarcircsAdd(String UseTime,String Km,String Fuel,String Carnum,String Cartype){
        Statement stmt = null;
        String add = "insert into CARCIRCSDB(UESTIME,MILEAGE,FATEXPEND,CLOSETIME,CARNUMBER)values('" + UseTime +
                           "','" + Km + "','" + Fuel +
                           "','" + Carnum + "')";

    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;

}
}