JSP+JavaBean连接数据库注册页面

chenkoviky 2009-05-20 08:24:00

各位大侠好，我遇到了一个问题:用JSP做注册页面时,我想通过JavaBean连接数据库，吧注册信息保存在userInfo表中,但总是出现问题，郁闷啊!
问题是:org.apache.jasper.JasperException: /result.jsp(2,0) The value for the useBean class attribute bean.Information is invalid.
以下是我的详细文件:
bean包里的Information.java:

package bean;

public class Information {
private String username;
private String password;
private String Email;
private String question;
private String answer;

public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getEmail() {
return Email;
}
public void setEmail(String email) {
Email = email;
}
public String getQuestion() {
return question;
}
public void setQuestion(String question) {
this.question = question;
}
public String getAnswer() {
return answer;
}
public void setAnswer(String answer) {
this.answer = answer;
}
public Information(String username, String password, String email,
String question, String answer) {
super();
this.username = username;
this.password = password;
Email = email;
this.question = question;
this.answer = answer;
}
}
dao包里的DBUtil.java:
package dao;

import java.sql.*;
import java.util.*;
import bean.Information;

public class DBUtil {
public Connection getConnection() {
Connection con = null;
String className = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url = "jdbc:sqlserver://localhost:1433;databasename=register";
String user = "sa";
String password = "sa";
try {
Class.forName(className);
con = DriverManager.getConnection(url, user, password);
} catch (Exception e) {
e.printStackTrace();
}
return con;
}
public String query(Information user){
String message=null;
try {
Connection con=new DBUtil().getConnection();
PreparedStatement ps=con.prepareStatement("insert into userInfo values(?,?,?,?,?)");
ps.setString(1, user.getUsername());
ps.setString(2, user.getPassword());
ps.setString(3, user.getEmail());
ps.setString(4, user.getQuestion());
ps.setString(5, user.getAnswer());
int count=ps.executeUpdate();
message=count>0?"注册成功!":"注册失败!";
} catch (Exception e) {
e.printStackTrace();
}
return message;
}
}
注册页面index.jsp
<%@ page language="java" pageEncoding="gb2312"%>
<html>
<head>
<style type="text/css">
a {text-decoration:none;}
a:hover{color:red;text-decoration:underline;}
</style>
</head>
<body>
<center>
<form name="myform" action="result.jsp" method=post">
<table>
<tr><td>用户名:<input type="text" name="username" size="17"></td></tr>
<tr><td>密  码:<input type="password" name="password" size="18"></td></tr>
<tr><td>E-mail:<input type="text" name="Email" size="17"></td></tr>
<tr><td>问  题:
<select name="question">
<option value="0">你的生日是多少?</option>
<option value="1">你的身高是多少?</option>
<option value="2">你的体重是多少?</option>
</select></td></tr>
<tr><td>答  案:<input type="text" name="answer" size="17"></td></tr>
<tr><td><input type="submit" value="确定">
<input type="reset" value="重置">  <a href="search.jsp" target=_blank>忘记密码?</a></td></tr>
</table>
</form>
</center>
</body>
</html>
判断是否注册成功的页面:result.jsp

<%@ page language="java" import="java.sql.*,java.util.*,bean.Information,dao.DBUtil" pageEncoding="gb2312"%>
<jsp:useBean id="user" class="bean.Information"></jsp:useBean>
<jsp:setProperty property="*" name="user"/>
<html>
<body>
<%
String username=user.getUsername();
String password=user.getPassword();
String Email=user.getEmail();
String question=user.getQuestion();
String answer=user.getAnswer();
%>
<%
DBUtil con=new DBUtil();
out.println(con.query(new Information(username,password,Email,question,answer)));
%>
</body>
</html>

真诚地感谢大家!我的分数不多了，只能给这么些了，还请大家包含!

...全文

177 2 打赏收藏转发到动态举报

写回复

用AI写文章

2 条回复

切换为时间正序

请发表友善的回复…

发表回复

qq306850549 2009-05-20

打赏
举报

String username=user.getUsername();
String password=user.getPassword();
String Email=user.getEmail();
String question=user.getQuestion();
String answer=user.getAnswer();
这是取的什么值???

你传过来的是一个实体类??

chenkoviky 2009-05-20