service.java~24~

车辆管理系统

package car.service;
import java.sql.*;
import car.db.Db;

public class Service {
    Connection con = new Db().getCon();
     public String add(String CarId,String Car,String CarType,String CarPlace,String CarColor,String CarPrice) throws Exception{
         String str = "失败";
         Statement stmt=con.createStatement() ;
         String sql = "insert into car values("+CarId+",'"+Car+"','"+CarType+"','"+CarPlace+"','"+CarColor+"',"+CarPrice+")";
         int i=stmt.executeUpdate(sql);
         if(i>0){
             str="成功";
         }
         stmt.close();
         return str;

     }
     public void add(){
         try {
             Statement stmt = con.createStatement();
             int count = stmt.executeUpdate("insert ");
         } catch (SQLException ex) {
         }
     }


     public String Updata(String CarId,String Car,String CarType,String CarPlace,String CarColor,String CarPrice) throws Exception{
        String str = "失败";
        Statement stmt=con.createStatement() ;
        String sql = "UPDATE car SET Car='"+Car+"',CarType='"+CarType+"',CarPlace='"+CarPlace+"',CarColor='"+CarColor+"',CarPrice="+CarPrice+" where CarId="+CarId;
        int i=stmt.executeUpdate(sql);
        if(i>0){
            str="成功";
        }
        stmt.close();
        return str;

    }
    public void Updata(){
        try {
            Statement stmt = con.createStatement();
            int count = stmt.executeUpdate("update");
        } catch (SQLException ex) {
        }
    }


    public String Find(String CarId) throws Exception{
          String str = "失败";
          Statement stmt=con.createStatement() ;
          String sql = "SELECT * FROM car where CarId="+"'"+CarId+"'";

          int i=stmt.executeUpdate(sql);
          if(i>0){
              str="成功";
          }
          stmt.close();
          return str;
      }
      public void Find(){
          try {
              Statement stmt = con.createStatement();
              int count = stmt.executeUpdate("select");
          } catch (SQLException ex) {
          }
    }

    public String Delete(String CarId) throws Exception{
       String str = "对不起，没有这个车牌号！";
       Statement stmt=con.createStatement() ;
       String sql = "delete from safe where CarId="+"'"+CarId+"'";

       int i=stmt.executeUpdate(sql);
       if(i>0){
           str="信息已删除！";
       }
       stmt.close();
       return str;
   }
   public void Delete(){
       try {
           Statement stmt = con.createStatement();
           int count = stmt.executeUpdate("delete");
       } catch (SQLException ex) {
       }
 }


}