?? customerdaoimpl.java
字號:
package org.netbook.dao.impl;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import org.netbook.dao.CustomerDao;
import org.netbook.model.Book;
import org.netbook.model.Customer;
import org.netbook.utils.DBUtils;
public class CustomerDaoImpl implements CustomerDao {
public Customer login(String name, String passwd) {
Connection conn = DBUtils.getConnection();
PreparedStatement pStmt = null;
ResultSet rs = null;
Customer result = null;
final String SQL = "SELECT * FROM CUSTOMER WHERE NAME = ? AND PASSWD = ?";
try {
pStmt = conn.prepareStatement(SQL);
pStmt.setString(1, name);
pStmt.setString(2, passwd);
rs = pStmt.executeQuery();
while (rs.next()) {
result = new Customer();
result.setId(rs.getLong("ID"));
result.setName(rs.getString("NAME"));
result.setPasswd(rs.getString("PASSWD"));
}
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (rs != null) {
rs.close();
}
if (pStmt != null) {
pStmt.close();
}
if (conn != null) {
conn.close();
}
} catch (Exception e) {
e.printStackTrace();
}
}
return result;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -