Advertisement
Guest User

Untitled

a guest
Feb 10th, 2019
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.54 KB | None | 0 0
  1. public void getMyMessageServer(String UserId, PrintWriter pr){
  2.  
  3. String from=null;
  4. String message=null;
  5. String time=null;
  6. String date =null;
  7.  
  8. Connection connection;
  9. Statement statement;
  10. ResultSet resultSet;
  11.  
  12. try {
  13.  
  14. Class.forName("com.mysql.jdbc.Driver");
  15. connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/product_database", "root", "");
  16. System.out.println("Product Share Database Opened...");
  17. statement = connection.createStatement();
  18. String sql="SELECT * FROM `message_data` WHERE `MessageTo`='"+UserId+"'"+"ORDER BY `MessageNo` DESC" ;
  19. //String sql="SELECT * FROM product WHERE ip_address= '"+address+"'";
  20. System.out.println("sql="+sql);
  21. resultSet=statement.executeQuery(sql);
  22.  
  23.  
  24. while (resultSet.next()) {
  25.  
  26. from = resultSet.getString("MessageFrom");
  27. message= resultSet.getString("Message");
  28. time= resultSet.getString("Time");
  29. date= resultSet.getString("Date");
  30.  
  31. System.out.println("Uploader name from db(tan)=" + from+"\t"+message+"\t"+time+"\t"+date);
  32. pr.println(from+"#"+message+"#"+time+"#"+date);
  33.  
  34.  
  35.  
  36. }
  37. connection.close();
  38. pr.println("AllReceivedSentFromServer");
  39.  
  40. }catch (Exception e){
  41. e.printStackTrace();
  42. System.out.println("Problem loading database");
  43. }
  44.  
  45. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement