在register页面输入用户信息,传递到adduser页面,调用JavaBean方法判断用户名是否已存在,如不存在转入member.jsp页面库。大家看看哪里错了,帮我修改一下,发我邮箱里也行[email protected]
下面是代码
register.sp
<%@ page language="java" contentType="text/html; charset=gbk"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gbk">
<title>用户注册</title>
</head>
<body>
用户注册
<form action="adduser.jsp" method=post>
<p>用户名: <input type=text name=Username> <font color=red>*</font>
<p>密码: <input type=password name=password> <font color=red>*</font>
<p>密码确认:<input type=password name=repassword> <font color=red>*</font>
<p>电子邮件:<input type=text name=email> <font color=red>*</font>
<p>问题: <select name=question >
<option selected="selected">你最爱的宠物是?</option>
<option>你的生日是!</option>
<option>你的爱人是?</option>
</select>
<p>答案: <input type=text name=reply>
<p><input type=submit value=提交> <input type=reset name="重置">
</form>
</body>
</html>adduser.jsp
<%@ page language="java" contentType="text/html; charset=gbk"%>
<jsp:useBean id="user" scope="request" class="U_14_java.zhuce1">
<jsp:setProperty name="user" property="*"/>
</jsp:useBean><html>
<head>
<%// meta http-equiv="refresh" content="3; url=member.jsp" content="text/html; charset=gbk" %>
<meta http-equiv="Content-Type" content="text/html; charset=gbk">
<title>注册</title>
</head>
<body><% try{
user.chongfu();
}catch(Exception e){
out.print(e.getMessage());
}
if(!user.chongfu()){
response.sendRedirect("member.jsp");
}
%>
</body>
</html>JavaBean
package U_14_java;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class zhuce1 {
int n;
int m=0;
String Username;
String password;
String repassword;
String email;
String question;
String reply;
String a;
public String getEmail() {
return email;
} public void setEmail(String email) {
this.email = email;
} public String getPassword() {
return password;
} public void setPassword(String password) {
this.password = password;
} public String getQuestion() {
return question;
} public void setQuestion(String question) {
this.question = question;
} public String getRepassword() {
return repassword;
} public void setRepassword(String repassword) {
this.repassword = repassword;
} public String getReply() {
return reply;
} public void setReply(String reply) {
this.reply = reply;
} public String getUsername() {
return Username;
} public void setUsername(String Username) {
this.Username = Username;
}
public boolean chongfu(){
String sql = "";
Connection conn = null;
Statement stmt = null;
ResultSet rs ;
String url = "jdbc:mysql://localhost/user";
String userName = "root";
String Password = "root";
boolean bl = true;
try {
Class.forName("com.mysql.jdbc.Driver");
} catch(ClassNotFoundException e) {
System.out.println("加载驱动器类时出现异常");
}
try {
conn = DriverManager.getConnection(url, userName, Password);
//创建Statement语句
stmt = conn.createStatement();
sql="select * from userinfo where username='"+Username+"'";
//使用executeQuery执行SQL查询语句
rs = stmt.executeQuery(sql);
while (rs.next()) {
a=rs.getString(2);
m++;
}
//显示返回的结果集
if(rs!=null){
bl=true;
}else {
bl=false;
sql="INSERT INTO userinfo VALUES("+"'"+m+"'"+"'"+Username+"'"+","+"'"+password+"'"+"," +"'"+email+"'"+","+ "'"+question+"'"+","+"'"+reply+"'"+")";
}
rs.close();
stmt.close();
} catch(SQLException e) {
System.out.println("出现SQLException异常");
} finally {
//关闭语句和数据库连接
try {
if (conn != null) conn.close();
} catch(SQLException e) {
System.out.println("关闭数据库连接时出现异常");
}
}
return bl;
}}member.jsp
<%@ page language="java" contentType="text/html; charset=gbk"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gbk">
<title>Insert title here</title>
</head>
<body>
<a href=modifyuser.jsp><font color=blue size=24>修改用户资料</font></a>
<a href=modifypsd.jsp><font color=blue size=24>修改密码</font></a>
</body>
</html>
下面是代码
register.sp
<%@ page language="java" contentType="text/html; charset=gbk"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gbk">
<title>用户注册</title>
</head>
<body>
用户注册
<form action="adduser.jsp" method=post>
<p>用户名: <input type=text name=Username> <font color=red>*</font>
<p>密码: <input type=password name=password> <font color=red>*</font>
<p>密码确认:<input type=password name=repassword> <font color=red>*</font>
<p>电子邮件:<input type=text name=email> <font color=red>*</font>
<p>问题: <select name=question >
<option selected="selected">你最爱的宠物是?</option>
<option>你的生日是!</option>
<option>你的爱人是?</option>
</select>
<p>答案: <input type=text name=reply>
<p><input type=submit value=提交> <input type=reset name="重置">
</form>
</body>
</html>adduser.jsp
<%@ page language="java" contentType="text/html; charset=gbk"%>
<jsp:useBean id="user" scope="request" class="U_14_java.zhuce1">
<jsp:setProperty name="user" property="*"/>
</jsp:useBean><html>
<head>
<%// meta http-equiv="refresh" content="3; url=member.jsp" content="text/html; charset=gbk" %>
<meta http-equiv="Content-Type" content="text/html; charset=gbk">
<title>注册</title>
</head>
<body><% try{
user.chongfu();
}catch(Exception e){
out.print(e.getMessage());
}
if(!user.chongfu()){
response.sendRedirect("member.jsp");
}
%>
</body>
</html>JavaBean
package U_14_java;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class zhuce1 {
int n;
int m=0;
String Username;
String password;
String repassword;
String email;
String question;
String reply;
String a;
public String getEmail() {
return email;
} public void setEmail(String email) {
this.email = email;
} public String getPassword() {
return password;
} public void setPassword(String password) {
this.password = password;
} public String getQuestion() {
return question;
} public void setQuestion(String question) {
this.question = question;
} public String getRepassword() {
return repassword;
} public void setRepassword(String repassword) {
this.repassword = repassword;
} public String getReply() {
return reply;
} public void setReply(String reply) {
this.reply = reply;
} public String getUsername() {
return Username;
} public void setUsername(String Username) {
this.Username = Username;
}
public boolean chongfu(){
String sql = "";
Connection conn = null;
Statement stmt = null;
ResultSet rs ;
String url = "jdbc:mysql://localhost/user";
String userName = "root";
String Password = "root";
boolean bl = true;
try {
Class.forName("com.mysql.jdbc.Driver");
} catch(ClassNotFoundException e) {
System.out.println("加载驱动器类时出现异常");
}
try {
conn = DriverManager.getConnection(url, userName, Password);
//创建Statement语句
stmt = conn.createStatement();
sql="select * from userinfo where username='"+Username+"'";
//使用executeQuery执行SQL查询语句
rs = stmt.executeQuery(sql);
while (rs.next()) {
a=rs.getString(2);
m++;
}
//显示返回的结果集
if(rs!=null){
bl=true;
}else {
bl=false;
sql="INSERT INTO userinfo VALUES("+"'"+m+"'"+"'"+Username+"'"+","+"'"+password+"'"+"," +"'"+email+"'"+","+ "'"+question+"'"+","+"'"+reply+"'"+")";
}
rs.close();
stmt.close();
} catch(SQLException e) {
System.out.println("出现SQLException异常");
} finally {
//关闭语句和数据库连接
try {
if (conn != null) conn.close();
} catch(SQLException e) {
System.out.println("关闭数据库连接时出现异常");
}
}
return bl;
}}member.jsp
<%@ page language="java" contentType="text/html; charset=gbk"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gbk">
<title>Insert title here</title>
</head>
<body>
<a href=modifyuser.jsp><font color=blue size=24>修改用户资料</font></a>
<a href=modifypsd.jsp><font color=blue size=24>修改密码</font></a>
</body>
</html>
换成String UserName=request.getParameter("Username");
这种方式不是更好用。
action走的应该是你的javabean 不应该只是写一个jsp页面