Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static MailList findByEmailAndPhone(String email, String phone) throws ClassNotFoundException, SQLException {
- // 0.
- Class.forName("com.mysql.jdbc.Driver");
- // 定義連結資料庫型態以及位置
- // (jdbc:資料庫種類)://資料庫ip:port/資料庫名稱
- String connURL = "jdbc:mysql://192.168.64.2:3306/test?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC";
- // 1. 取得資料庫連結(connection)
- Connection connection = DriverManager.getConnection(connURL, "root", "");
- // 查詢 email 和 Phone 同時出現
- String sql = "SELECT * FROM `MAIL_LIST` WHERE EMAIL = ? AND PHONE = ?";
- PreparedStatement preStmt = connection.prepareStatement(sql);
- preStmt.setString(1, email);
- preStmt.setString(2, phone);
- ResultSet result = preStmt.executeQuery();
- // 有找到的情形
- while(result.next()) {
- // 先把 DB 欄位放到 String
- String emailFromDB = result.getString("EMAIL");
- String genderFromDB = result.getString("GENDER");
- String phoneFromDB = result.getString("PHONE");
- String sourceFromDB = result.getString("SOURCE");
- String nameFromDB = result.getString("NAME");
- String cityFromDB = result.getString("CITY");
- // 把這些 String 放到 MailList Object
- MailList mailList = new MailList();
- mailList.setCity(cityFromDB);
- mailList.setEmail(emailFromDB);
- mailList.setSexual(genderFromDB);
- mailList.setTel(phoneFromDB);
- mailList.setSource(sourceFromDB);
- mailList.setName(nameFromDB);
- return mailList;
- }
- return null;
- }
Add Comment
Please, Sign In to add comment