carbdservice.java~2~

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

package bigwork.db;
import java.sql.*;

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

            int count = 0;
            ResultSet rs = stmt.executeQuery("select count(*) from CarBD");
            if (rs.next()) {
                count = rs.getInt(1);
            }
            rs.close();
            datas = new String[count][];
            int i = 0;
            rs = stmt.executeQuery("select * from CarBD");
            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();
            con.close();

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