Advertisement
Guest User

Untitled

a guest
Aug 2nd, 2016
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.12 KB | None | 0 0
  1. try
  2. {
  3. st=cn.createStatement();
  4. String strUser="";
  5. rs=st.executeQuery("SELECT * FROM chsl_db WHERE name='"+nametxt.getText()+"'");
  6. while(rs.next())
  7. {
  8. strUser=rs.getString(1);
  9. }
  10. if(strUser.equals(nametxt.getText()))
  11. {
  12. st= cn.createStatement();
  13. rs = st.executeQuery("SELECT * FROM chsl_db WHERE name ='" + nametxt.getText() + "'");
  14. while (rs.next())
  15. {
  16. titletxt.setText(rs.getString(1));
  17. nametxt.setText(rs.getString(2));
  18. flatnum.setText(rs.getString(3));
  19. areatxt.setText(rs.getString(4));
  20. emailtxt.setText(rs.getString(5));
  21. deletebutton.setEnabled(true);
  22. }
  23.  
  24. st.close();
  25. }
  26. else
  27. {
  28. JOptionPane.showMessageDialog(null,"No Data Found!","Security Warning",JOptionPane.WARNING_MESSAGE);
  29. }
  30.  
  31. }
  32.  
  33. catch(SQLException s)
  34. {
  35. System.out.println("No record found!nnn");
  36. System.out.println("SQL Error" + s.toString() + " " + s.getErrorCode() + " " + s.getSQLState());
  37. }
  38. catch(Exception x)
  39. {
  40. System.out.println("Error" + x.toString()+" " + x.getMessage());
  41. }
  42.  
  43. }
  44.  
  45. try
  46. {
  47. Class.forName("java.sql.Driver");
  48. cn = DriverManager.getConnection("jdbc:mysql://localhost:3306/avinash?useSSL=false","root","password");
  49. }
  50. catch(ClassNotFoundException e)
  51. {
  52. System.err.println("Failed to load driver");
  53. e.printStackTrace();
  54. }
  55. catch(SQLException e)
  56. {
  57. System.err.println("Unable to connect");
  58. e.printStackTrace();
  59. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement