给我看看我那出错了啊

bingomanager 2008-07-15 04:56:58

页面文件如下：
<%@ page language="java" contentType="text/html; charset=GB18030"
pageEncoding="GB18030"%>
<%@ page import="bingo.yalanda.factory.*" %>
<%@ page import="java.util.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GB18030">
<title>Insert title here</title>
</head>
<body>
<center>
<h3>用户注册</h3>
<br>
<br>
<%
request.setCharacterEncoding("GB18030");
%>
<jsp:useBean id="u" scope="page" class="bingo.yalanda.vo.User"/>
<jsp:setProperty name="u" property="userName" param="username"/>
<jsp:setProperty name="u" property="password" param="password"/>
<jsp:setProperty name="u" property="rname" param="rname"/>
<jsp:setProperty name="u" property="sex" param="sex"/>
<jsp:setProperty name="u" property="phone" param="phone"/>
<jsp:setProperty name="u" property="addr" param="addr"/>
<jsp:setProperty name="u" property="post" param="post"/>
<jsp:setProperty name="u" property="email" param="email"/>
<jsp:setProperty name="u" property="rdate" value="<%= new Date() %>"/>

<%
try{
DaoFactory.getUserDaoInstance().insert(u);

%>
用户注册成功!<br>
<%

} catch(Exception e) {
%>

用户注册失败!<br>
<%
}
%>

</center>
</body>
</html>
实现类如下：
package bingo.yalanda.impl;

import java.sql.PreparedStatement;
import java.sql.Timestamp;

import java.util.List;

import bingo.yalanda.dao.UserDao;
import bingo.yalanda.dbc.DBConnection;
import bingo.yalanda.vo.User;

public class UserDaoImpl implements UserDao {

public void delete(User u) throws Exception {

}

public void insert(User u) throws Exception {

String sql = "insert into users (id,username,password,rname,sex,phone,addr,post,email,rdate) values(null,?,?,?,?,?,?,?,?,?)";
PreparedStatement pstmt = null;
DBConnection dbc = null;
try {
dbc = new DBConnection();
pstmt = dbc.getConn().prepareStatement(sql);
pstmt.setString(1,u.getUserName());
pstmt.setString(2,u.getPassword());
pstmt.setString(3,u.getRname() );
pstmt.setString(4,u.getSex() );
System.out.println(u.getSex());
pstmt.setString(5,u.getPhone() );
pstmt.setString(6,u.getAddr() );
pstmt.setString(7,u.getPost() );
pstmt.setString(8,u.getEmail() );
pstmt.setTimestamp(9, new Timestamp(u.getRdate().getTime()));
pstmt.close();

} catch(Exception e) {

} finally {
dbc.closeConn();
}

}

public List<User> queryAll() throws Exception {
// TODO Auto-generated method stub
return null;
}

public User queryById(int id) throws Exception {
// TODO Auto-generated method stub
return null;
}

public List<User> queryByLike(String cond) throws Exception {
// TODO Auto-generated method stub
return null;
}

public void update(User u) throws Exception {

}

}
虽然显示成功，但是数据库里没数据，根据打印的结果是sex和日期可能有问题。但是不报错

...全文