?? userdao.java
字號:
package com.csthit.store.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.csthit.store.db.DB;
import com.csthit.store.vo.User;
public class UserDAO {
public boolean getValidate(User user) {
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
conn = DB.getConn();
String sql = "select * from userinfo where loginname=? and password=?";
pstmt = DB.getPstmt(conn, sql);
pstmt.setString(1, user.getLoginName());
pstmt.setString(2, user.getPassword());
rs = pstmt.executeQuery();
if(rs.next()) {
return true;
} else {
return false;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return false;
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
return false;
} finally {
try {
DB.close(rs);
DB.close(pstmt);
DB.close(conn);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -