driver.java~1~

来自「车辆管理系统~其中包括了主要的增删改查的各项基本功能」· JAVA~1~ 代码 · 共 44 行

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 DriverBD");
             if (rs.next()) {
                 count = rs.getInt(1);
             }
             rs.close();
             datas = new String[count][];
             int i = 0;
             rs = stmt.executeQuery("select * from DriverBD");
             while (rs.next()) {
                 String number = rs.getString("CARNUMBER");
                 String type = rs.getString("CARTYPE");
                 String size = rs.getString("CARSIZE");

                 datas[i] = new String[] {number,type,size};

                 i++;
                 System.out.println(number + "," + type + "," + size);
             }
             rs.close();

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

}