Advertisement
Guest User

Untitled

a guest
Aug 10th, 2016
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.78 KB | None | 0 0
  1. List outer=new ArrayList<String>();
  2. List inner=new ArrayList<String>();
  3. Connection con;
  4. Statement stmt;
  5. ResultSet rs;
  6. ResultSetMetaData rsmd;
  7. int columnNumber;
  8. try{
  9. Class.forName("com.mysql.jdbc.Driver");
  10. con=DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb","root","root");
  11. stmt=con.createStatement();
  12. rs=stmt.executeQuery("select * from mytable");
  13. rsmd=rs.getMetaData();
  14. columnNumber=rsmd.getColumnCount();
  15. while(rs.next()){
  16. for(int i=1;i<columnNumber;i++){
  17. inner.add(rs.getString(i));
  18. }
  19. outer.add(inner);
  20. }
  21. System.out.println("t" + outer);
  22. rs.close();
  23. con.close();
  24. }catch(Exception e){
  25. System.out.println(e);
  26. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement