private String address; private String phone; private String zipCode; private String cardNumber; private int cardType; private String banneropt; private int userLogCount; private int userType ; private Date userLastLogTime;
//getter方法 public String getUserid() { return this.userid; } public String getEmail() { return this.email; } public String getPassword() { return this.password; }
public String getAddress() { return this.address; } public String getZipCode() { return this.zipCode; } public String getPhone() { return this.phone; } public String getCardNumber() { return this.cardNumber; } public int getCardType() { return this.cardType; }
public int getUserType() { return this.userType; }
public String getName() { return this.name; } public String getBanneropt() { return this.banneropt; } public int getUserLogCount() { return this.userLogCount; } //setter方法 public void setUserid(String c) { this.userid=c; } public void setName(String c) { this.name=c; }
public void setEmail(String c) { this.email=c; }
public void setAddress(String c) { this.address=c; }
public void setZipCode(String c) { this.zipCode=c; } public void setPhone(String c) { this.phone=c; }
public void setUserType(int c) { this.userType=c; }
public void setPassword(String c) { this.password=c; } public void setCardNumber(String c) { this.cardNumber=c; } public void setBanneropt(String c) { this.banneropt=c; } public void setCardType(int c) { this.cardType=c; }
是怎么回事?
呵
下面;
也把它放到:D:\Tomcat\webapps\examples\jspdev\web-inf\classes\com\jspdev
下面。
帮我改改吧,我都搞了好几天了:
注册的页面:<%@ page language="java" errorPage="error.jsp" import="com.jspdev.*"%> <jsp:useBean id="userInfo" class="com.jspdev.UserInfo" scope="page">
<jsp:setProperty name="userInfo" property="*"/>
</jsp:useBean>
<jsp:useBean id="UserRegist" class="com.jspdev.UserRegist" scope="page"/>
<html>
<head>
<title>用户信息注册页面</title></head>
<%request.setCharacterEncoding("gb2312");%>
<LINK href="hellking.css" type=text/css rel=stylesheet>
<body><%
UserRegist.setUserInfo(userInfo);
UserRegist.regist();
out.println("注册成功");
%>
<br>
<a href="main.jsp">返回</a>
</body>
</html>
UserInfo.java:package com.jspdev;
import java.util.Date;
public class UserInfo
{
//属性
private String userid;
private String password;
private String email;
private String name;
private String address;
private String phone;
private String zipCode;
private String cardNumber;
private int cardType;
private String banneropt;
private int userLogCount;
private int userType ;
private Date userLastLogTime;
//getter方法
public String getUserid()
{
return this.userid;
}
public String getEmail()
{
return this.email;
}
public String getPassword()
{
return this.password;
}
public String getAddress()
{
return this.address;
}
public String getZipCode()
{
return this.zipCode;
}
public String getPhone()
{
return this.phone;
}
public String getCardNumber()
{
return this.cardNumber;
}
public int getCardType()
{
return this.cardType;
}
public int getUserType()
{
return this.userType;
}
public String getName()
{
return this.name;
}
public String getBanneropt()
{
return this.banneropt;
}
public int getUserLogCount()
{
return this.userLogCount;
} //setter方法
public void setUserid(String c)
{
this.userid=c;
}
public void setName(String c)
{
this.name=c;
}
public void setEmail(String c)
{
this.email=c;
}
public void setAddress(String c)
{
this.address=c;
}
public void setZipCode(String c)
{
this.zipCode=c;
}
public void setPhone(String c)
{
this.phone=c;
}
public void setUserType(int c)
{
this.userType=c;
}
public void setPassword(String c)
{
this.password=c;
}
public void setCardNumber(String c)
{
this.cardNumber=c;
}
public void setBanneropt(String c)
{
this.banneropt=c;
}
public void setCardType(int c)
{
this.cardType=c;
}
}UserResgister.java:
package com.jspdev;
import sun.jdbc.odbc.JdbcOdbcDriver;
//import com.microsoft.jdbc.sqlserver.SQLServerDriver;
import java.sql.*;public class UserRegist
{
private UserInfo userInfo;
private Connection con;
//获得数据库连接。
public UserRegist()
{
String CLASSFORNAME="sun.jdbc.odbc.JdbcOdbcDriver";
String SERVANDDB="jdbc:odbc:jspdev";
String USER="sa";
String PWD="1";
try
{
Class.forName(CLASSFORNAME);
con = DriverManager.getConnection(SERVANDDB,USER,PWD);
}
catch(Exception e)
{
e.printStackTrace();
}
}
//设置待注册的用户信息。
public void setUserInfo(UserInfo userInfo)
{
this.userInfo=userInfo;
}
//进行注册
public void regist()throws Exception
{
String reg="insert into user_info values(?,?,?,?,?,?,?,?,?,?,?,?,?)";
try
{
PreparedStatement pstmt=con.prepareStatement(reg);
pstmt.setString(1,userInfo.getUserid());
pstmt.setString(2,userInfo.getPassword());
pstmt.setString(3,userInfo.getEmail());
pstmt.setString(4,userInfo.getName());
pstmt.setString(5,userInfo.getAddress());
pstmt.setString(6,userInfo.getPhone());
pstmt.setString(7,userInfo.getZipCode());
pstmt.setString(8,userInfo.getCardNumber());
pstmt.setInt(9,userInfo.getCardType());
pstmt.setString(10,userInfo.getBanneropt());
pstmt.setInt(11,1);
pstmt.setInt(12,0);
pstmt.setDate(13,new java.sql.Date(new java.util.Date().getTime()));
pstmt.executeUpdate();
}
catch(Exception e)
{
e.printStackTrace();
throw e;
}
}
}
你新建一页面,只包含如下代码,看运行是否有异常,如有异常说明没有找到包
<%@ page language="java" errorPage="error.jsp" import="com.jspdev.*"%>
UserResgister.java中类名为UserRegist两者不一致将import sun.jdbc.odbc.JdbcOdbcDriver;注释掉
不过:将import sun.jdbc.odbc.JdbcOdbcDriver;注释掉
是什么意思呀?
哥哥姐姐们,帮帮忙,再看看吧。
<%@ page language="java" errorPage="error.jsp" import="com.jspdev.*"%>
没有出现异常。
那为什么我的程序不行呢?
tomcat-4.1.24
sql server 2000
Sql Server for JDBC.exe驱动完全版.exe