=============DBUser.java的代码:=================
package DB;import java.sql.*;
import java.util.Date;
import java.text.SimpleDateFormat;
import java.text.*;
import java.util.List;
import java.util.ArrayList;import javax.servlet.http.*;import General.userData;
public class DBUser {
private final static String USER_REG = "INSERT INTO user(userName,userSex,userPWD,userEmail,userQuestion,userAnswer,userRegTime) VALUES(?,?,?,?,?,?,?);";
private final static String USER_SEARCH = "SELECT * FROM user WHERE userName=?";
private final static String USER_CHECK = "SELECT * FROM user WHERE userName=? and userPWD=?";
private final static String USER_LOGIN_UPDATE = "UPDATE user SET userLoadTime=userLoadTime+1,userLastTime=? WHERE userName=? AND userPWD=?"; public DBUser() {} /*
*用户注册到数据库
*/
public void userReg(userData userData) throws SQLException {
//数据库连接
Connection conn = DBConnectionManager.getInstance().getConnection();
PreparedStatement pstm = null; try {
String userName = userData.getUserName().trim();
int userSex = userData.getUserSex();
String userPWD = userData.getUserPWD().trim();
String userEmail = userData.getUserEmail().trim();
String userQuestion = userData.getUserQuestion();
String userAnswer = userData.getUserAnswer();
Date now = new Date();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String userRegTime = sdf.format(now); /*/数据库操作开始---------------------------------------------*/
pstm = conn.prepareStatement(USER_REG);
pstm.setString(1,userName);
pstm.setInt(2,userSex);
pstm.setString(3,userPWD);
pstm.setString(4,userEmail);
pstm.setString(5,userQuestion);
pstm.setString(6,userAnswer);
pstm.setString(7,userRegTime);
pstm.executeUpdate();
//数据库操作结束----------------------------------------------
}
catch (Exception e) {
System.out.print(e.toString());
}
/*
finally {//释放资源
conn.close();
pstm.clearParameters();
}*/ } /*
*查询用户是否存在
*/
public boolean isNotExistUser(String userName) throws SQLException {
Connection conn = DBConnectionManager.getInstance().getConnection();
PreparedStatement pstm = null;
ResultSet rs = null;
try {
pstm = conn.prepareStatement(USER_SEARCH);
pstm.setString(1,userName);
rs = pstm.executeQuery();
while (rs.next()){
if (rs.getString("userName").equals(userName))
return true;
}
}
catch(Exception e) {
System.out.print(e.toString());
}
/*
finally {//释放资源
conn.close();
pstm.clearParameters();
rs.close();
}*/ return false;
} /*
*核对用户
*/
public String checkUser(String userName,String userPWD) throws SQLException {
Connection conn = DBConnectionManager.getInstance().getConnection();
PreparedStatement pstm = null;
ResultSet rs = null;
String returnStr = "ooooo";
try {
pstm = conn.prepareStatement(USER_CHECK);
pstm.setString(1,userName);
pstm.setString(2,userPWD);
rs = pstm.executeQuery();
while (rs.next()){
returnStr += rs.getString("userName");
}
}
catch(Exception e) {
System.out.print(e.toString());
}
/*
finally {//释放资源
conn.close();
pstm.clearParameters();
rs.close();
}
*/
return returnStr;
} /*
*登陆时更新用户数据
*/
public void updateLogin(userData userData) throws SQLException {
Connection conn = DBConnectionManager.getInstance().getConnection();
PreparedStatement pstm = null;
try {
String userName = userData.getUserName();
String userPWD = userData.getUserPWD();
Date now = new Date();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String userRegTime = sdf.format(now); /*/数据库操作开始---------------------------------------------*/
pstm = conn.prepareStatement(USER_LOGIN_UPDATE);
pstm.setString(1,userRegTime);
pstm.setString(2,userName);
pstm.setString(3,userPWD);
pstm.executeUpdate();
//数据库操作结束----------------------------------------------
}
catch (Exception e) {
System.out.print(e.toString());
}
/*
finally {//释放资源
conn.close();
pstm.clearParameters();
}
*/
} /*
*设置用户session
*/
public void setUserSession(String param) {
HttpSession sessionUser = null;
userData userData = new userData();
sessionUser.setAttribute(param,userData);
}/*
*得到用户session
*/
public userData getUserSession(HttpSession session,String param) {
userData userData = (userData)session.getAttribute(param);
return userData;
}
}============userLogin.jsp的代码:===========================
<%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html" %>
<%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean" %>
<%@ taglib uri="/WEB-INF/struts-logic.tld" prefix="logic" %>
<html:html locale="true">
<HEAD>
<%@ page
language="java"
contentType="text/html; charset=GB2312"
pageEncoding="GB2312"
%>
<META http-equiv="Content-Type" content="text/html; charset=GB2312">
<META name="GENERATOR" content="JBuilder X">
<META http-equiv="Content-Style-Type" content="text/css">
<LINK href="theme/HIW.css" rel="stylesheet"type="text/css">
<title>
userLogin
</title>
</head>
<body bgcolor="#ffffff">
<html:form action="userLoginAction" onsubmit="return validateUserLoginForm(this);">
<bean:message key="regForm.userData.userName"/>:<html:text property="userData.userName"/><br />
<bean:message key="regForm.userData.userPWD"/>:<html:password property="userData.userPWD"/><br /> <html:submit>Login</html:submit>
<html:reset/>
</html:form>
</BODY>
<html:javascript formName="userLoginForm"/>
</html:html>
package DB;import java.sql.*;
import java.util.Date;
import java.text.SimpleDateFormat;
import java.text.*;
import java.util.List;
import java.util.ArrayList;import javax.servlet.http.*;import General.userData;
public class DBUser {
private final static String USER_REG = "INSERT INTO user(userName,userSex,userPWD,userEmail,userQuestion,userAnswer,userRegTime) VALUES(?,?,?,?,?,?,?);";
private final static String USER_SEARCH = "SELECT * FROM user WHERE userName=?";
private final static String USER_CHECK = "SELECT * FROM user WHERE userName=? and userPWD=?";
private final static String USER_LOGIN_UPDATE = "UPDATE user SET userLoadTime=userLoadTime+1,userLastTime=? WHERE userName=? AND userPWD=?"; public DBUser() {} /*
*用户注册到数据库
*/
public void userReg(userData userData) throws SQLException {
//数据库连接
Connection conn = DBConnectionManager.getInstance().getConnection();
PreparedStatement pstm = null; try {
String userName = userData.getUserName().trim();
int userSex = userData.getUserSex();
String userPWD = userData.getUserPWD().trim();
String userEmail = userData.getUserEmail().trim();
String userQuestion = userData.getUserQuestion();
String userAnswer = userData.getUserAnswer();
Date now = new Date();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String userRegTime = sdf.format(now); /*/数据库操作开始---------------------------------------------*/
pstm = conn.prepareStatement(USER_REG);
pstm.setString(1,userName);
pstm.setInt(2,userSex);
pstm.setString(3,userPWD);
pstm.setString(4,userEmail);
pstm.setString(5,userQuestion);
pstm.setString(6,userAnswer);
pstm.setString(7,userRegTime);
pstm.executeUpdate();
//数据库操作结束----------------------------------------------
}
catch (Exception e) {
System.out.print(e.toString());
}
/*
finally {//释放资源
conn.close();
pstm.clearParameters();
}*/ } /*
*查询用户是否存在
*/
public boolean isNotExistUser(String userName) throws SQLException {
Connection conn = DBConnectionManager.getInstance().getConnection();
PreparedStatement pstm = null;
ResultSet rs = null;
try {
pstm = conn.prepareStatement(USER_SEARCH);
pstm.setString(1,userName);
rs = pstm.executeQuery();
while (rs.next()){
if (rs.getString("userName").equals(userName))
return true;
}
}
catch(Exception e) {
System.out.print(e.toString());
}
/*
finally {//释放资源
conn.close();
pstm.clearParameters();
rs.close();
}*/ return false;
} /*
*核对用户
*/
public String checkUser(String userName,String userPWD) throws SQLException {
Connection conn = DBConnectionManager.getInstance().getConnection();
PreparedStatement pstm = null;
ResultSet rs = null;
String returnStr = "ooooo";
try {
pstm = conn.prepareStatement(USER_CHECK);
pstm.setString(1,userName);
pstm.setString(2,userPWD);
rs = pstm.executeQuery();
while (rs.next()){
returnStr += rs.getString("userName");
}
}
catch(Exception e) {
System.out.print(e.toString());
}
/*
finally {//释放资源
conn.close();
pstm.clearParameters();
rs.close();
}
*/
return returnStr;
} /*
*登陆时更新用户数据
*/
public void updateLogin(userData userData) throws SQLException {
Connection conn = DBConnectionManager.getInstance().getConnection();
PreparedStatement pstm = null;
try {
String userName = userData.getUserName();
String userPWD = userData.getUserPWD();
Date now = new Date();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String userRegTime = sdf.format(now); /*/数据库操作开始---------------------------------------------*/
pstm = conn.prepareStatement(USER_LOGIN_UPDATE);
pstm.setString(1,userRegTime);
pstm.setString(2,userName);
pstm.setString(3,userPWD);
pstm.executeUpdate();
//数据库操作结束----------------------------------------------
}
catch (Exception e) {
System.out.print(e.toString());
}
/*
finally {//释放资源
conn.close();
pstm.clearParameters();
}
*/
} /*
*设置用户session
*/
public void setUserSession(String param) {
HttpSession sessionUser = null;
userData userData = new userData();
sessionUser.setAttribute(param,userData);
}/*
*得到用户session
*/
public userData getUserSession(HttpSession session,String param) {
userData userData = (userData)session.getAttribute(param);
return userData;
}
}============userLogin.jsp的代码:===========================
<%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html" %>
<%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean" %>
<%@ taglib uri="/WEB-INF/struts-logic.tld" prefix="logic" %>
<html:html locale="true">
<HEAD>
<%@ page
language="java"
contentType="text/html; charset=GB2312"
pageEncoding="GB2312"
%>
<META http-equiv="Content-Type" content="text/html; charset=GB2312">
<META name="GENERATOR" content="JBuilder X">
<META http-equiv="Content-Style-Type" content="text/css">
<LINK href="theme/HIW.css" rel="stylesheet"type="text/css">
<title>
userLogin
</title>
</head>
<body bgcolor="#ffffff">
<html:form action="userLoginAction" onsubmit="return validateUserLoginForm(this);">
<bean:message key="regForm.userData.userName"/>:<html:text property="userData.userName"/><br />
<bean:message key="regForm.userData.userPWD"/>:<html:password property="userData.userPWD"/><br /> <html:submit>Login</html:submit>
<html:reset/>
</html:form>
</BODY>
<html:javascript formName="userLoginForm"/>
</html:html>
解决方案 »
- spring事务隔离性问题
- 有关Struts2的问题
- 知识共享:从Linux到Solaris:概述和命令差异,学吧~,兄弟们!
- 欢迎参加有奖调查和讨论:项目中如何看待和对待企业用户提出的各色需求
- tomcat 配置问题
- SSH-MYSQL的上传与下载
- 为什么logback在tomcat中运行时日志文件输出到eclipse目录下
- Tomcat1.4.24配mysql连接池出现“ Cannot load JDBC driver class 'null'”的问题
- .NET,J2EE大比较,访问量每天可能达到10万以上,并且有XML数据交互,.NET和J2EE哪个更好一些?>
- 数据库中的索引问题
- 哪里有《hibernate in action》的中文翻译啊
- 修饰浮的private和protected一起用的问题
第二次登录时第一次注销
执行注销代码
第三次登录时代码环境是在注销效果执行后
是注销后 环境发生变化