Advertisement
Guest User

Untitled

a guest
Apr 5th, 2019
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.05 KB | None | 0 0
  1. import java.io.*;
  2. import java.sql.*;
  3.  
  4. public class PrintDate
  5. {
  6. public String [] getDate()
  7. {
  8. try {
  9. DriverManager.registerDriver(new com.mysql.jdbc.Driver());
  10. Connection con = DriverManager.getConnection("jdbc:mysql://localhost/storage?user=root&password=root");
  11. Statement stm = con.createStatement();
  12. ResultSet rs = stm.executeQuery("select count(*) from goods");
  13. rs.next();
  14. int size=4*rs.getInt(1);
  15. String data [] = new String[size];
  16. rs = stm.executeQuery("select * from goods");
  17. int i=0;
  18. while (rs.next())
  19. {
  20. data[i]=rs.getString(1);
  21. data[i+1]=rs.getString(2);
  22. data[i+2]=rs.getString(3);
  23. data[i+3]=rs.getString(4);
  24. i=i+4;
  25. }
  26. rs.close();
  27. stm.close();
  28. con.close();
  29. return data;
  30. }
  31. catch(Exception e) {String dt [] = new String[1]; dt [0]="Error"; return dt;}
  32. }
  33. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement