Advertisement
Guest User

Untitled

a guest
Mar 5th, 2016
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.87 KB | None | 0 0
  1. String id = null;
  2. String root="root",student="root";
  3. String h=""%";
  4. String t="%"";
  5. String name=jTextField1.getText();
  6. String fname=h+name+t;
  7.  
  8. try {
  9. Class.forName("com.mysql.jdbc.Driver").newInstance();
  10.  
  11. Connection
  12.  
  13. con=(Connection)DriverManager.getConnection
  14. ("jdbc:mysql://localhost:3306/dijlafinal1",root,student);
  15. String query2="SELECT * FROM name WHERE name like ? ";
  16. PreparedStatement pstm2=null;
  17. pstm2.setString(1,fname);
  18. pstm2=con.prepareStatement(query2);
  19.  
  20.  
  21. String name1="";
  22. ResultSet rs = pstm2.executeQuery();
  23. while (rs.next()){
  24. name1=rs.getString("name");
  25. id= rs.getString("id");
  26. int epo =rs.getInt("epo");
  27. }
  28. jTextField2.setText(name1);
  29. jTextField3.setText(fname);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement