carservice.java

车辆管理系统

package DB;
import java.sql.*;
import javax.swing.JTable;
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;
            }

   public String[][] getData() throws Exception {
             int count=1;
             Statement stmt = con.createStatement();
             ResultSet rs = stmt.executeQuery("select count(*) from CARSQ");
             if (rs.next()) {
                 count = rs.getInt(1);
             }
             rs.close();
             String[][] datas = new String[count][];
             int i = 0;
             rs = stmt.executeQuery("select * from CARSQ");
             while (rs.next()) {
                 datas[i] = new String[] {""+ rs.getString("CARTYPE"), rs.getString("CAR"),
                            rs.getString("COLOR"),rs.getString("DRIVERAGE")};
                 i++;
             }
             rs.close();
             return datas;
         }



          }