数据库连接出现问题

我的设计完成后，数据库正常连接了·
   但是在后台数据库中添加的数据无法在前台的使用
    前台添加的数据也无法加入到数据库
  如：在前台注册系统注册成功后，但是登录系统，却出现错误
    注册成功后，在数据库的table中也查找不到数据
     在后台数据库直接添加的的数据，在前台登录系统也报错
        求高手解决问题·

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

package com.bsw.servlet.common;import java.io.IOException;
import java.io.PrintWriter;
import com.bsw.user.*;
import java.util.*;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import com.bsw.book.*;
public class LoginControl extends HttpServlet {
public LoginControl() {
super();
}
public void destroy() {
super.destroy();

}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException { this.doPost(request, response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException { request.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
response.setContentType("text/html;charset=UTF-8");

UserDAO ud = new UserDAO();

boolean isIn = false;
boolean isManager = false;
HttpSession session = request.getSession();

User user = (User)session.getAttribute("user");
String userName = request.getParameter("userName");
String password = request.getParameter("pwd");

if(user == null){

if(userName == null || password == null){
request.getRequestDispatcher("/com/bsw/common/error.jsp").forward(request, response);
} else {

user  = ud.queryUser(userName);

System.out.println(user);
if(user == null){
isIn = false;
}  else {
if(user.getPass().equals(password) && user.getRole() == 0){
isIn = true;
}

if(request.getParameter("role") != null && user.getPass().equals(password)){
isIn = true;
isManager = true;
}
}
}

} else {
isIn = true;
}

if (isIn) {

if(isManager){
session.setAttribute("user", ud.queryUser(userName));
response.sendRedirect("/bookshop/com/bsw/manager/managerWelcome.jsp");
} else {

UserDAO userDAO = new UserDAO();
User userDetail = userDAO.queryUser(user.getName());

session.setAttribute("user", userDetail);
BookDAO bookDAO = new BookDAO();
ArrayList books = bookDAO.queryNewBooks();
request.setAttribute("books", books);
request.getRequestDispatcher("/com/bsw/user/loginSuccess.jsp")
.forward(request, response);
}
}
else {
request.getRequestDispatcher("/com/bsw/common/error.jsp").forward(
request, response);
}
}
public void init() throws ServletException {
// Put your code here
}} 这是登录页面的servlet代码
package com.bsw.servlet.common;import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Date;
import java.text.DateFormat;
import java.text.ParseException;import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;import com.bsw.user.User;
import com.bsw.user.UserDAO;
public class RegisterControl extends HttpServlet {
public RegisterControl() {
super();
}
public void destroy() {
super.destroy();

}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException { response.setContentType("text/html");
PrintWriter out = response.getWriter();
out
.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println("  <HEAD><TITLE>A Servlet</TITLE></HEAD>");
out.println("  <BODY>");
out.print("    This is ");
out.print(this.getClass());
out.println(", using the GET method");
out.println("  </BODY>");
out.println("</HTML>");
out.flush();
out.close();
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
response.setContentType("text/html;charset=utf-8");

User user = new User();
UserDAO userDAO = new UserDAO();
String name = request.getParameter("Wname");

if(userDAO.queryUser(name)==null){
user.setName(name);
user.setPass(request.getParameter("password"));
user.setRealName(request.getParameter("realname"));
user.setGender(request.getParameter("gender"));
user.setAge(Integer.parseInt(request.getParameter("age")));
user.setEmail(request.getParameter("email"));
user.setPhone(request.getParameter("commMethod"));
user.setAddress(request.getParameter("address"));
DateFormat d = DateFormat.getDateInstance();
try{
Date date = new Date(d.parse(request.getParameter("registTime")).getTime());
user.setRegisterTime(date);
userDAO.insertUser(user);
}catch(ParseException e){
e.printStackTrace();
}
response.sendRedirect("/bookshop/com/bsw/user/registerSuccess.jsp");
}else{
User tempUser = new User();
tempUser.setRealName(request.getParameter("realname"));
tempUser.setGender(request.getParameter("gender"));
tempUser.setAge(Integer.parseInt(request.getParameter("age")));
tempUser.setEmail(request.getParameter("email"));
tempUser.setPhone(request.getParameter("commMethod"));
tempUser.setAddress(request.getParameter("address"));
request.setAttribute("userTemp",tempUser);
request.getRequestDispatcher("/com/bsw/user/registerUnsuccess.jsp").forward(request, response);
}

}
public void init() throws ServletException {

}}注册页面后台代码
无论用什么登录，都是直接跳到error页面
if(user == null){if(userName == null || password == null){
request.getRequestDispatcher("/com/bsw/common/error.jsp").forward(request, response);
} else {
user = ud.queryUser(userName);  System.out.println(user);
if(user == null){
isIn = false;
} else {
if(user.getPass().equals(password) && user.getRole() == 0){
isIn = true;
}