driver.java~7~

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

package bigwork.db;

import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.Connection;
import java.sql.SQLException;

public class Driver {
    Connection con = new DB().getConn();
     public String[][] ShowDriver(){
         String[][] datas = null;
         Statement stmt = null;
         try {
             stmt = con.createStatement();

             int count = 0;
             ResultSet rs = stmt.executeQuery("select count(*) from PerDB");
             if (rs.next()) {
                 count = rs.getInt(1);
             }
             rs.close();
             datas = new String[count][];
             int i = 0;
             rs = stmt.executeQuery("select * from PerDB");
             while (rs.next()) {
                 String name = rs.getString("NAME");
                 int sex = rs.getInt("SEX");
                 int birth = rs.getInt("BIRTH");
                 int drivenumber = rs.getInt("DRIVENUMBER") ;
                 int license = rs.getInt("LICENSE") ;
                 String period = rs.getString("PERIOD") ;
                 int age = rs.getInt("AGE") ;
                 String permit = rs.getString("PERMIT") ;
                 int sertime = rs.getInt("SERTIME") ;


                 datas[i] = new String[] {name,""+sex,""+birth,""+drivenumber,""+license,period,""+age,permit,""+sertime};

                 i++;
                 System.out.println(name + "," + sex + "," + birth + "," + drivenumber + "," +
                                    license + "," + period + "," + age + "," + permit + "," + sertime + ",");
             }
             rs.close();

         } catch (SQLException ex) {
             ex.printStackTrace();
         }
         return datas;
 }

}