public class LogonDataPoolAction extends Action {
public ActionForward perform(ActionMapping actionMapping, ActionForm actionForm,
HttpServletRequest request, HttpServletResponse response){
try{request.setCharacterEncoding("GBK");}catch(Exception ex){ex.printStackTrace();}
//定义数据库缓冲池的变量
DataSource dataSource;
Connection conn;
PreparedStatement preparedStmt;
ResultSet rs;
try {
//取得struts-config文件的数据缓冲池的联连
dataSource = getDataSource(request, "logon");
conn = dataSource.getConnection();
//创建PreparedStatement接
preparedStmt = conn.prepareStatement("select * from logonUser where userName=? " +
"and userPassword=?");
//取得用户输入的用户名和密码
String name = request.getParameter("name").trim();
String password = request.getParameter("password").trim();
//如果用户名和密码正确,转向显示成功登陆信息页面,否则转向失败登陆信息页面
preparedStmt.setString(1,name);
preparedStmt.setString(2,password);
rs = preparedStmt.executeQuery();
String address = "";
if(rs.next()){
address = "success";
}else{
address = "failure";
}
//关闭数据库联接
conn.close();
return (actionMapping.findForward(address));
}catch(Exception e){
e.printStackTrace();
return (actionMapping.findForward("failure"));
}
}
}
具体应用 http://www.cnpoint.com
public ActionForward perform(ActionMapping actionMapping, ActionForm actionForm,
HttpServletRequest request, HttpServletResponse response){
try{request.setCharacterEncoding("GBK");}catch(Exception ex){ex.printStackTrace();}
//定义数据库缓冲池的变量
DataSource dataSource;
Connection conn;
PreparedStatement preparedStmt;
ResultSet rs;
try {
//取得struts-config文件的数据缓冲池的联连
dataSource = getDataSource(request, "logon");
conn = dataSource.getConnection();
//创建PreparedStatement接
preparedStmt = conn.prepareStatement("select * from logonUser where userName=? " +
"and userPassword=?");
//取得用户输入的用户名和密码
String name = request.getParameter("name").trim();
String password = request.getParameter("password").trim();
//如果用户名和密码正确,转向显示成功登陆信息页面,否则转向失败登陆信息页面
preparedStmt.setString(1,name);
preparedStmt.setString(2,password);
rs = preparedStmt.executeQuery();
String address = "";
if(rs.next()){
address = "success";
}else{
address = "failure";
}
//关闭数据库联接
conn.close();
return (actionMapping.findForward(address));
}catch(Exception e){
e.printStackTrace();
return (actionMapping.findForward("failure"));
}
}
}
具体应用 http://www.cnpoint.com