package project; import java.sql.*; public class useOpea { public int query(String sql,Object[] objects) th
rows SQLException { int n=0; Connection conn=DriverManager.getConnection("jdbc:
mysql://192.168.24.224:3306/dorm","root","123456"); PreparedStatement pstm=conn.prepareStatement(sql,1004,1007); if(objects!=null && objects.length>0){ for(int i=0;i<objects.length;i++ ) { pstm.setObject(i+1,objects[i]); } } ResultSet
rs=pstm.executeQuery();
rs.last(); n=
rs.get
Row();
rs.close(); pstm.close(); conn.close(); return n; } public Object[][] queryToArray(String sql,Object[]pa
rs) th
rows SQLException{ Connection conn=DriverManager.getConnection("jdbc:
mysql://192.168.24.224:3306/dorm","root","123456"); PreparedStatement pstm=conn.prepareStatement(sql,1004,1007); if(pa
rs!=null && pa
rs.length>0){ for(int i=0;i<pa
rs.length;i++ ) { pstm.setObject(i+1,pa
rs[i]); } } ResultSet
rs=pstm.executeQuery();
rs.last(); int n=
rs.get
Row(); ResultSetMetaData resultSetMetaData=
rs.getMetaData(); int m=resultSetMetaData.getColumnCount(); Object[][]data=new Object[n][m];
rs.beforeFi
rst(); int i=0; while(
rs.next()) { for(int j=0;j<m;j++) { data[i][j]=
rs.getObject(j+1); i++; } } return data; } public static void main(String[]args) th
rows SQLException { useOpea userOpertion = new useOpea(); Object[][] data= userOpertion.queryToArray("select * from student", args); for(int i=0;i<data.length;i++) { for(int j=0;j<data[i].length;j++) { System.out.println(data[i][j]+" "); } } } }有什么错误
扫一扫
5089
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
