Advertisement
Guest User

Modify

a guest
Feb 3rd, 2019
144
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. int Admission_Number= Integer.parseInt(jTextField1.getText());
  2. try{
  3. Class.forName("java.sql.DriverManager");
  4. Connection con=(Connection)
  5. DriverManager.getConnection("jdbc:mysql://localhost:3306/STUDENT","root","tiger");
  6. Statement stmt=(Statement) con.createStatement();
  7. String query="SELECT Student_Name, Stream FROM STUDENT WHERE Admission_Number=’”+Admission_Number+”’;";
  8. ResultSet rs= stmt.executeQuery(query);
  9.  
  10. if(rs.next())
  11. {
  12. String STUDENT_NAME= rs.getString("STUDENT_NAME");
  13. String STREAM= rs.getString("STREAM");
  14. jTextField2.setText(STUDENT_NAME);
  15. jTextField3.setText(STREAM);
  16. }
  17. }
  18. catch(Exception e){
  19. JOptionPane.showMessageDialog(this, e.getMessage());
  20. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement