Guest User

Untitled

a guest
Mar 14th, 2016
27
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.92 KB | None | 0 0
  1. public class DBConnect {
  2. private static final String DB_DRIVER = "com.mysql.jdbc.Driver";
  3. private static final String DB_CONNECTION = "jdbc:mysql://localhost/ezeepayservices";
  4. private static final String DB_USER = "root";
  5. private static final String DB_PASSWORD = "admin";
  6.  
  7.  
  8. Connection dbConnection = null;
  9.  
  10. public void connect(){
  11. try {
  12.  
  13. Class.forName(DB_DRIVER);
  14.  
  15. } catch (ClassNotFoundException e) {
  16.  
  17. System.out.println(e.getMessage());
  18.  
  19. }
  20.  
  21. try {
  22.  
  23. dbConnection = DriverManager.getConnection(
  24. DB_CONNECTION, DB_USER,DB_PASSWORD);
  25.  
  26. } catch (SQLException e) {
  27.  
  28. System.out.println(e.getMessage());
  29.  
  30. }
  31. }
  32.  
  33. public List fetch(String name,String addres,String salary,String pension) throws SQLException{
  34. if (dbConnection == null){
  35. throw new RuntimeException("Please call connect() before you call insert()");
  36. }
  37.  
  38. String selectSQL = "SELECT * FROM test WHERE Name like ? and address like ? and salary like ? and pension like ?";
  39.  
  40. PreparedStatement stmt = dbConnection.prepareStatement(selectSQL);
  41. stmt.setString(1, "%"+name+"%");
  42. stmt.setString(2, "%"+addres+"%");
  43. stmt.setString(3, "%"+salary+"%");
  44. stmt.setString(4, "%"+pension+"%");
  45. ResultSet rs = stmt.executeQuery();
  46.  
  47.  
  48. List person_list = new ArrayList();
  49. while (rs.next()) {
  50. Person person = new Person();
  51.  
  52. person.setId(rs.getString("id"));
  53. person.setName(rs.getString("Name"));
  54. person.setAddress(rs.getString("address"));
  55. person.setPhonenumber(rs.getString("phonenumber"));
  56. person.setSalary(rs.getString("salary"));
  57. person.setPension(rs.getString("pension"));
  58.  
  59. System.out.println("#### name in DAO "+rs.getString("Name"));
  60. person_list.add(person);
  61.  
  62. }
  63. return person_list;
  64. }
  65.  
  66. public void disconnect(){
  67. try {
  68. dbConnection.close();
  69. } catch (SQLException e) {
  70. System.out.println(e.getMessage());
  71. }
  72. }
  73.  
  74. }
Add Comment
Please, Sign In to add comment