小弟做的javaBena+jsp注册,运行的时候没有提示错误,生成成功,但就是提交数据不的行啊,麻烦各位给看看,
提交页面的jsp文件:
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>
<jsp:useBean class="com.ch7.Users" id="users" scope="page"/>
<%
String UserName = request.getParameter("UserName");
users.setUserName(UserName);
if (users.is_exist()) {
%>
<h2 align="center">该用户名已经存在!</h2>
<center>
<input type="button" name="goback" value="返回" onclick="javascript:window.history.go(-1)">
</center>
<% } else {
String UserPassword = request.getParameter("Password");
users.setUserPassword(UserPassword);
if (users.addUser()) {
%>
<h2>注册成功!</h2>
<center>
<a href="user_login.jsp" target="_self">现在登录</a>
</center>
<% } else {
out.println("<h1>注册失败,请稍候在试</h1>");
}
}
%>下面是javaBenapackage com.ch7;import java.sql.*;/**
*
* @author Administrator
*/
public class Access_ch7 { String userName = "sa";
String userPassword = "";
String url = "jdbc:odbc:ch7";
String className = "sun.jdbc.odbc.JbdcOdbcDriver";
Connection conn;
Statement stmt;
ResultSet rs; public Access_ch7() {
stmt = null;
rs = null; try {
Class.forName(className);
conn = DriverManager.getConnection(url, userName, userPassword);
} catch (SQLException e) {
System.out.println(e.toString());
} catch (ClassNotFoundException e) {
System.out.println(e.toString());
}
} /*
对数据库执行sql执行语句,主要是插入和更新操作,返回一个布尔值变量
*/
public boolean exeSql(String sql) {
try {
stmt = conn.createStatement();
stmt.executeUpdate(sql);
return true;
} catch (Exception e) {
System.out.println(e.toString());
return false;
}
} /*
对数据库执行sql查询语句,返回一个ResultSet类型的对象
*/
public ResultSet exeSqlQuery(String sql) {
try {
stmt = conn.createStatement();
stmt.executeQuery(sql);
} catch (Exception e) {
System.out.println(e.toString());
rs = null;
}
return rs;
}
}
package com.ch7;import java.sql.*;
import java.util.*;
import java.text.*;/**
*
* @author Administrator
*/
public class Users extends Access_ch7 { private int UserID;
private String UserName;
private String UserPassword;
private String sql; public Users() {
UserID = 0;
UserName = "";
UserPassword = "";
sql = "";
} /*
用户添加记录,返回一个布尔值变量
*/
public boolean addUser() {
sql = "insert into users (UserName,UserPassword) values('" + UserName + "','" + UserPassword + "')";
boolean isAdd = super.exeSql(sql);
return isAdd;
} /*
判断用户名是否存在
*/
public boolean is_exist() {
sql = "select * from users where UserName='" + UserName + "'";
ResultSet rs = null; //局部变量rs隐藏了全局变量rs
boolean isExist = false; try {
rs = super.exeSqlQuery(sql);
while (rs.next()) {
isExist = true;
}
} catch (Exception e) {
System.out.println(e.toString());
}
return isExist;
} /*
判断用户名和密码是否正确
*/
public boolean user_valid() {
sql = "select * from users where UserName='" + UserName + "' and UserPassword='" + UserPassword + "'";
ResultSet rs = null; //局部变量rs隐藏了全局变量rs
boolean isValid = false; try {
rs = super.exeSqlQuery(sql);
while (rs.next()) {
this.UserID = rs.getInt("UserID");
isValid = true;
}
} catch (Exception e) {
System.out.println(e.toString());
}
return isValid;
} /*
获取某个用户的信息 by UserID
*/
public boolean init() {
sql = "select * form users where UserID='" + UserID + "'"; try {
rs = super.exeSqlQuery(sql);
if (rs.next()) {
this.UserID = rs.getInt("UserID");
this.UserName = rs.getString("UserName");
this.UserPassword = rs.getString("UserPassword"); return true;
} else {
return false;
}
} catch (Exception e) {
System.out.println(e.toString());
return false;
}
} /*
设置成员变量的值
*/
public void setUserID(int UserID) {
this.UserID = UserID;
} /*
获取成员变量的值
*/
public int getUserID() {
return this.UserID;
} public void setUserName(String UserName) {
this.UserName = UserName;
} public String getUserName() {
return this.UserPassword;
} public void setUserPassword(String UserPassword) {
this.UserPassword = UserPassword;
} public String getUserPassword() {
return this.UserPassword;
}
}
两个javaBena哈,跪求各位大侠!
提交页面的jsp文件:
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>
<jsp:useBean class="com.ch7.Users" id="users" scope="page"/>
<%
String UserName = request.getParameter("UserName");
users.setUserName(UserName);
if (users.is_exist()) {
%>
<h2 align="center">该用户名已经存在!</h2>
<center>
<input type="button" name="goback" value="返回" onclick="javascript:window.history.go(-1)">
</center>
<% } else {
String UserPassword = request.getParameter("Password");
users.setUserPassword(UserPassword);
if (users.addUser()) {
%>
<h2>注册成功!</h2>
<center>
<a href="user_login.jsp" target="_self">现在登录</a>
</center>
<% } else {
out.println("<h1>注册失败,请稍候在试</h1>");
}
}
%>下面是javaBenapackage com.ch7;import java.sql.*;/**
*
* @author Administrator
*/
public class Access_ch7 { String userName = "sa";
String userPassword = "";
String url = "jdbc:odbc:ch7";
String className = "sun.jdbc.odbc.JbdcOdbcDriver";
Connection conn;
Statement stmt;
ResultSet rs; public Access_ch7() {
stmt = null;
rs = null; try {
Class.forName(className);
conn = DriverManager.getConnection(url, userName, userPassword);
} catch (SQLException e) {
System.out.println(e.toString());
} catch (ClassNotFoundException e) {
System.out.println(e.toString());
}
} /*
对数据库执行sql执行语句,主要是插入和更新操作,返回一个布尔值变量
*/
public boolean exeSql(String sql) {
try {
stmt = conn.createStatement();
stmt.executeUpdate(sql);
return true;
} catch (Exception e) {
System.out.println(e.toString());
return false;
}
} /*
对数据库执行sql查询语句,返回一个ResultSet类型的对象
*/
public ResultSet exeSqlQuery(String sql) {
try {
stmt = conn.createStatement();
stmt.executeQuery(sql);
} catch (Exception e) {
System.out.println(e.toString());
rs = null;
}
return rs;
}
}
package com.ch7;import java.sql.*;
import java.util.*;
import java.text.*;/**
*
* @author Administrator
*/
public class Users extends Access_ch7 { private int UserID;
private String UserName;
private String UserPassword;
private String sql; public Users() {
UserID = 0;
UserName = "";
UserPassword = "";
sql = "";
} /*
用户添加记录,返回一个布尔值变量
*/
public boolean addUser() {
sql = "insert into users (UserName,UserPassword) values('" + UserName + "','" + UserPassword + "')";
boolean isAdd = super.exeSql(sql);
return isAdd;
} /*
判断用户名是否存在
*/
public boolean is_exist() {
sql = "select * from users where UserName='" + UserName + "'";
ResultSet rs = null; //局部变量rs隐藏了全局变量rs
boolean isExist = false; try {
rs = super.exeSqlQuery(sql);
while (rs.next()) {
isExist = true;
}
} catch (Exception e) {
System.out.println(e.toString());
}
return isExist;
} /*
判断用户名和密码是否正确
*/
public boolean user_valid() {
sql = "select * from users where UserName='" + UserName + "' and UserPassword='" + UserPassword + "'";
ResultSet rs = null; //局部变量rs隐藏了全局变量rs
boolean isValid = false; try {
rs = super.exeSqlQuery(sql);
while (rs.next()) {
this.UserID = rs.getInt("UserID");
isValid = true;
}
} catch (Exception e) {
System.out.println(e.toString());
}
return isValid;
} /*
获取某个用户的信息 by UserID
*/
public boolean init() {
sql = "select * form users where UserID='" + UserID + "'"; try {
rs = super.exeSqlQuery(sql);
if (rs.next()) {
this.UserID = rs.getInt("UserID");
this.UserName = rs.getString("UserName");
this.UserPassword = rs.getString("UserPassword"); return true;
} else {
return false;
}
} catch (Exception e) {
System.out.println(e.toString());
return false;
}
} /*
设置成员变量的值
*/
public void setUserID(int UserID) {
this.UserID = UserID;
} /*
获取成员变量的值
*/
public int getUserID() {
return this.UserID;
} public void setUserName(String UserName) {
this.UserName = UserName;
} public String getUserName() {
return this.UserPassword;
} public void setUserPassword(String UserPassword) {
this.UserPassword = UserPassword;
} public String getUserPassword() {
return this.UserPassword;
}
}
两个javaBena哈,跪求各位大侠!
解决方案 »
- windows7和xp页面效果不同
- jsp查询显示页面checkbox问题,急
- Tomcat6.0指定的服务并未以已安装的服务存在
- 请教网页密码加密思路
- 大家的项目中会用到<jsp:forward>吗?什么时候会用到?
- [急]JSP+Applet出错...
- 非常开心:自己独立写的一个OA(b/s)终于完成了!想散分可是我都没有分!怎么办?
- 南京程序员月薪报价(大家帮忙)SOS!
- 请问IBM HTTP SERVER怎么才能解释jsp文件呀?
- 根据经纬度,由近到远查出最近的的5条数据,应该怎么做啊
- 请问有没有可以直接得到当月的法定节假日和休息日的天数的啊???
- 这是什么异常啊??????郁闷死了,过来帮忙看看!连接数据库的。。。。。
楼主【qunqun886】截止到2008-08-01 11:09:49的历史汇总数据(不包括此帖):
发帖的总数量:11 发帖的总分数:190 每贴平均分数:17
回帖的总数量:7 得分贴总数量:0 回帖的得分率:0%
结贴的总数量:9 结贴的总分数:160
无满意结贴数:0 无满意结贴分:0
未结的帖子数:2 未结的总分数:30
结贴的百分比:81.82 % 结分的百分比:84.21 %
无满意结贴率:0.00 % 无满意结分率:0.00 %
楼主加油
取消马甲机器人,请点这里:http://www.java2000.net/mycsdn/robotStop.jsp?usern=qunqun886
用户添加记录,返回一个布尔值变量
*/
public boolean addUser() {
sql = "insert into users (UserName,UserPassword) values('" + UserName + "','" + UserPassword + "')";
boolean isAdd = super.exeSql(sql);
return isAdd;
}
后台有报错的吧,代码太乱了,看不太清楚,好像是这里的错,你的addUser()没有参数.