carservice.java~2~

车辆管理系统

package DB;
import java.sql.*;
public class CarService {
     Connection con = new Db().getCon();
    public String addCarsq(String cartype,String car,String color,String driverage) throws Exception{
            String str1= "失败";
            Statement stmt=con.createStatement();
            String sql= "insert into Carsq values ('" + cartype +"','" + car +"', '" + color +"','" + driverage +"')";
            int j= stmt.executeUpdate(sql);
            if(j>0){
                str1="成功";
            }
              stmt.close();
              return  str1;
    }}