driver.java~5~

来自「车辆管理系统~其中包括了主要的增删改查的各项基本功能」· JAVA~5~ 代码 · 共 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 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");

                 datas[i] = new String[] {name,""+sex,""+birth};

                 i++;
                 System.out.println(name + "," + sex + "," + birth);
             }
             rs.close();

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

}