三个页面想实现注册一直不行，求大神帮忙看看是什么问题
register.jsp页面代码：
<%@ page language=”java” import=”java.util.*” pageEncoding=”utf-8″%>
<%@ page import = “com.bjsxt.shopping.*” %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+”://”+request.getServerName()+”:”+request.getServerPort()+path+”/”;
%>
<!DOCTYPE HTML PUBLIC “-//W3C//DTD HTML 4.01 Transitional//EN”>
<%
request.setCharacterEncoding(“utf-8”);
String action = request.getParameter(“action”);
if(action != null && action.trim().equals(“register”)){
String username = request.getParameter(“username”);
String password = request.getParameter(“password”);
String phonenum = request.getParameter(“phonenum”);
String address = request.getParameter(“address”);
User u = new User();
u.setUsername(username);
u.setPassword(password);
u.setPhonenum(phonenum);
u.setAddress(address);
u.save();
out.println(“Congratulation!Resgistered succeed!”);
}
%>
<html>
<head>
<base href=”<%=basePath%>”>
<title>用户注册</title>
<meta http-equiv=”pragma” content=”no-cache”>
<meta http-equiv=”cache-control” content=”no-cache”>
<meta http-equiv=”expires” content=”0″>
<meta http-equiv=”keywords” content=”keyword1,keyword2,keyword3″>
<meta http-equiv=”description” content=”This is my page”>
<!–
<link rel=”stylesheet” type=”text/css” href=”styles.css”>
–>
</head>
<body>
<form name=”form” action=”register.jsp” method=”post” >
<input type=”hidden” name=action value=add>
<table width=”750″ align=”center” border=”2″>
<tr>
<td colspan=”2″ align=”center”>用户注册</td>
</tr>
<tr>
<td>用户名：</td>
<td>
<input type=”text” name=”username” id=”userid” size=”30″ maxlength=”10″ >
<div id=”usermsg”></div>
</td>
</tr>
<tr>
<td>密码：</td>
<td><input type=”password” name=”password” size=”15″ maxlength=”12″></td>
</tr>
<tr>
<td>密码确认:</td>
<td><input type=”password” name=”password2″ size=”15″ maxlength=”12″></td>
</tr>
<tr>
<td>手机号码：</td>
<td><input type=”text” name=”phonenum” size=”15″ maxlength=”11″></td>
</tr>
<tr>
<td>地址：</td>
<td><input type=”text” name=”address” size=”15″ maxlength=”12″></td>
</tr>
<tr>
<td></td>
<td><input type=”submit” value=”提交”><input type=”reset” value=”重置”/></td>
</tr>
</table>
</form>
</body>
</html>
User.java页面：
package com.bjsxt.shopping;
import java.sql.*;
import java.sql.Timestamp;
import com.bjsxt.shopping.util.DB;
public class User {
private String userid;
private String username;
private String password;
private String address;
private String Email;
private String phonenum;
private String sex;
private String userjpg;
Timestamp rdate;
public void setUserid(String userid) {
this.userid = userid;
}
public String getUserid() {
return userid;
}
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 getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public String getEmail() {
return Email;
}
public void setEmail(String email) {
Email = email;
}
public String getPhonenum() {
return phonenum;
}
public void setPhonenum(String phonenum) {
this.phonenum = phonenum;
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
public String getUserjpg() {
return userjpg;
}
public void setUserjpg(String userjpg) {
this.userjpg = userjpg;
}
public Timestamp getRdate() {
return rdate;
}
public void setRdate(Timestamp rdate) {
this.rdate = rdate;
}
public void save(){
Connection conn = null;
PreparedStatement pstmt = null;
try{
conn=DB.getConn();
String sql = “insert into users(password,username,address,phonenum) values(?,?,?,?)”;
pstmt = DB.getPStmt(conn, sql);
pstmt.setString(1, password);
pstmt.setString(2, username);
pstmt.setString(3, address);
pstmt.setString(4, phonenum);
pstmt.executeUpdate();
}catch(SQLException e){
e.printStackTrace();
}
finally{
DB.closeStmt(pstmt);
DB.closeConn(conn); }
}
}
DB.java页面代码：
package com.bjsxt.shopping.util;
import java.sql.*;
public class DB {
static {
try {
Class.forName(“com.microsoft.sqlserver.jdbc.SQLServerDriver”);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
private DB(){}
public static Connection getConn(){
Connection conn = null;
try {
conn = DriverManager.getConnection
(“jdbc:sqlserver://localhost:1433;DatabaseName=cssJYbs”,”sa”,”sql2008″);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
public static void closeConn(Connection conn)
{
try {
if(conn!=null){
conn.close();
conn = null;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static Statement getStmt(Connection conn)
{
Statement stmt = null;
try
{
stmt = conn.createStatement();
}
catch(SQLException e)
{
e.printStackTrace();
}
return stmt;
}
public static PreparedStatement getPStmt(Connection conn,String sql)
{
PreparedStatement pStmt = null;
try{
pStmt = conn.prepareStatement(sql);
}catch(SQLException e)
{
e.printStackTrace();
}
return pStmt;
}
public static void closeStmt(Statement stmt)
{
try {
if(stmt!=null){
stmt.close();
stmt = null;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static ResultSet executeQuery(Statement stmt,String sql)
{
ResultSet rs = null;
try {
rs = stmt.executeQuery(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return rs;
}
public static void closeResultSet(ResultSet rs)
{
try {
if(rs!=null){
rs.close();
rs = null;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
数据库：
if object_id(“”users””)is not null
drop table users
create table users(
userid int primary key identity(1,1),
password varchar(16) not null,
sex varchar(2)not null,
username varchar(40) not null,
Email varchar(20) ,
address varchar(30),
phonenum varchar(11),
rdate datetime,
userjpg varchar(100)
)
insert into users(password,sex,username,Email,address,phonenum,userjpg) values(“”123456″”,””女””,””ss””,””123@qq.com””,””浙江省杭州市””,””12890897867″”,””””)
就这三个页面连接然后运行jsp页面没有任何反应，数据库也没有添加内容
