简易汽车零部件管理系统设计与实现(JAVA)

package server; //业务实体的查询 import java.sql.ResultSet; import java.sql.SQLException; public class search { public Object[][] searchCar() { connect connect1=new connect(); connect connect2=new connect(); String carTableName="car"; connect1.setTableName(carTableName); connect2.setTableName(carTableName); String carSQL="select * from "+carTableName; String countSQL = "select count(*) from "+carTableName; Object[][] result = null; connect1.setSQL(carSQL); connect2.setSQL(countSQL); try{ ResultSet rs1=connect1.inputConnectResult(); ResultSet rs2=connect2.inputConnectResult(); rs2.next(); result = new Object[rs2.getInt(1)][10]; int index = 0; while(rs1.next()){//将查询结果存入二位数组中 result[index][0] = rs1.getString(1); result[index][1] = rs1.getString(2); result[index][2] = rs1.getString(3); result[index][3] = rs1.getString(4); result[index][4] = rs1.getString(5); result[index][5] = rs1.getString(6); result[index][6] = rs1.getString(7); result[index][7] = rs1.getString(8); result[index][8] = rs1.getString(9); result[index][9] = rs1.getString(10); index ++; } } catch (SQLException e){ e.printStackTrace(); } return result; } public Object[][] searchbyCarID(String carId) {//根据整车的编号进行查询 connect connect1=new connect(); connect connect2=new connect(); String carTableName="car"; connect1.setTableName(carTableName); connect2.setTableName(carTableName); String carID =carId; String carSQL="select * from "+carTableName+" where id LIKE'%"+carID+"%'"; String countSQL = "select count(*) from "+carTableName+" where id LIKE'%"+carID+"%'"; Object[][] result = null; connect1.setSQL(carSQL); connect2.setSQL(countSQL); try{ ResultSet rs1=connect1.inputConnectResult(); ResultSet rs2=connect2.inputConnectResult(); rs2.next(); result = new Object[rs2.getInt(1)][10]; int index = 0; while(rs1.next()){//将查询结果存入二位数组中 result[index][0] = rs1.getString(1); result[index][1] = rs1.getString(2); result[index][2] = rs1.getString(3); result[index][3] = rs1.getString(4); result[index][4] = rs1.getString(5); result[index][5] = rs1.getString(6); result[index][6] = rs1.getString(7); result[index][7] = rs1.getString(8); result[index][8] = rs1.getString(9); result[index][9] = rs1.getString(10); index ++; } } catch (SQLException e){ e.printStackTrace(); } return result; } public Object[][] searchbyCarName(String carName) {//根据整车的名称进行查询 connect connect1=new connect(); connect connect2=new connect(); String carTableName="car"; connect1.setTableName(carTableName); connect2.setTableName(carTableName); String carname =carName; String carSQL="select * from "+carTableName+" where name LIKE'%"+carname+"%'"; String countSQL = "select count(*) from "+carTableName+" where name LIKE'%"+carname+"%'"; Object[][] result = null; connect1.setSQL(carSQL); connect2.setSQL(countSQL); try{ ResultSet rs1=connect1.inputConnectResult(); ResultSet rs2=connect2.inputConnectResult(); rs2.next(); result = new Object[rs2.getInt(1)][10]; int index = 0; while(rs1.next()){//将查询结果存入二位数组中 result[index][0] = rs1.getString(1); result[index][1] = rs1.getString(2); result[index][2] = rs1.getString(3); result[index][3] = rs1.getString(4); result[index][4] = rs1.getString(5); result[index][5] = rs1.getString(6); result[index][6] = rs1.getString(7); result[index][7] = rs1.getString(8); result[index][8] = rs1.getString(9); result[index][9] = rs1.getString(10); index ++; } } catch (SQLException e){ e.printStackTrace(); } return result; } public Object[][] searchbyCarType(String carType) {//根据整车的类型进行查询 connect connect1=new connect(); connect connect2=new connect(); String carTableName="car"; connect1.setTableName(carTableName); connect2.setTableName(carTableName); String cartype =carType; String carSQL="select * from "+carTableName+" where type='"+cartype+"'"; String countSQL = "select count(*) from "+carTableName+" where type='"+cartype+"'"; Object[][] result = null; connect1.setSQL(carSQL); connect2.setSQL(countSQL); try{ ResultSet rs1=connect1.inputConnectResult(); ResultSet rs2=connect2.inputConnectResult(); rs2.next(); result = new Object[rs2.getInt(1)][10]; int index = 0; while(rs1.next()){//将查询结果存入二位数组中 result[index][0] = rs1.getString(1); result[index][1] = rs1.getString(2); result[index][2] = rs1.getString(3); result[index][3] = rs1.getString(4); result[index][4] = rs1.getString(5); result[index][5] = rs1.getString(6); result[index][6] = rs1.getString(7); result[index][7] = rs1.getString(8); result[index][8] = rs1.getString(9); result[index][9] = rs1.getString(10); index ++; } } catch (SQLException e){ e.printStackTrace(); } return result; } public Object[][] searchBJ() { connect connect1=new connect(); connect connect2=new connect(); String bjTableName="bujian"; connect1.setTableName(bjTableName); connect2.setTableName(bjTableName); String bjSQL="select * from "+bjTableName; String countSQL = "select count(*) from "+bjTableName; Object[][] result = null; connect1.setSQL(bjSQL); connect2.setSQL(countSQL); try{ ResultSet rs1=connect1.inputConnectResult(); ResultSet rs2=connect2.inputConnectResult(); rs2.next(); result = new Object[rs2.getInt(1)][7]; int index = 0; while(rs1.next()){//将查询结果存入二位数组中 result[index][0] = rs1.getString(1); result[index][1] = rs1.getString(2); result[index][2] = rs1.getString(3); result[index][3] = rs1.getString(4); result[index][4] = rs1.getString(5); result[index][5] = rs1.getString(6); result[index][6] = rs1.getString(7); index ++; } } catch (SQLException e){ e.printStackTrace(); } return result; } public Object[][] searchbyBJID(String bjId) {//根据部件的编号进行查询 connect connect1=new connect(); connect connect2=new connect(); String bjTableName="bujian"; connect1.setTableName(bjTableName); connect2.setTableName(bjTableName); String bjID =bjId; String bjSQL="select * from "+bjTableName+" where id LIKE'%"+bjID+"%'"; String countSQL = "select count(*) from "+bjTableName+" where id LIKE'%"+bjID+"%'"; Object[][] result = null; connect1.setSQL(bjSQL); connect2.setSQL(countSQL); try{ ResultSet rs1=connect1.inputConnectResult(); ResultSet rs2=connect2.inputConnectResult(); rs2.next(); result = new Object[rs2.getInt(1)][7]; int index = 0; while(rs1.next()){//将查询结果存入二位数组中 result[index][0] = rs1.getString(1); result[index][1] = rs1.getString(2); result[index][2] = rs1.getString(3); result[index][3] = rs1.getString(4); result[index][4] = rs1.getString(5); result[index][5] = rs1.getString(6); result[index][6] = rs1.getString(7); index ++; } } catch (SQLException e){ e.printStackTrace(); } return result; } public Object[][] searchbyBJName(String bjName) {//根据部件的名称进行查询 connect connect1=new connect(); connect connect2=new connect(); String bjTableName="bujian"; connect1.setTableName(bjTableName); connect2.setTableName(bjTableName); String bjname =bjName; Stri