Guest User

Untitled

a guest
May 31st, 2018
193
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.55 KB | None | 0 0
  1. public static MailList findByEmailAndPhone(String email, String phone) throws ClassNotFoundException, SQLException {
  2.  
  3. // 0.
  4. Class.forName("com.mysql.jdbc.Driver");
  5.  
  6. // 定義連結資料庫型態以及位置
  7. // (jdbc:資料庫種類)://資料庫ip:port/資料庫名稱
  8. String connURL = "jdbc:mysql://192.168.64.2:3306/test?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC";
  9.  
  10. // 1. 取得資料庫連結(connection)
  11. Connection connection = DriverManager.getConnection(connURL, "root", "");
  12.  
  13. // 查詢 email 和 Phone 同時出現
  14. String sql = "SELECT * FROM `MAIL_LIST` WHERE EMAIL = ? AND PHONE = ?";
  15. PreparedStatement preStmt = connection.prepareStatement(sql);
  16. preStmt.setString(1, email);
  17. preStmt.setString(2, phone);
  18.  
  19. ResultSet result = preStmt.executeQuery();
  20.  
  21. // 有找到的情形
  22. while(result.next()) {
  23. // 先把 DB 欄位放到 String
  24. String emailFromDB = result.getString("EMAIL");
  25. String genderFromDB = result.getString("GENDER");
  26. String phoneFromDB = result.getString("PHONE");
  27. String sourceFromDB = result.getString("SOURCE");
  28. String nameFromDB = result.getString("NAME");
  29. String cityFromDB = result.getString("CITY");
  30.  
  31. // 把這些 String 放到 MailList Object
  32. MailList mailList = new MailList();
  33. mailList.setCity(cityFromDB);
  34. mailList.setEmail(emailFromDB);
  35. mailList.setSexual(genderFromDB);
  36. mailList.setTel(phoneFromDB);
  37. mailList.setSource(sourceFromDB);
  38. mailList.setName(nameFromDB);
  39. return mailList;
  40. }
  41.  
  42. return null;
  43. }
Add Comment
Please, Sign In to add comment