基于web的网上书城系统开发-----登录注册

//时间实现function showLocale(objD){var str,colorhead,colorfoot;var yy = objD.getYear();if(yy<1900) yy = yy+1900;var MM = objD.getMonth()+1;if(MM<10) MM = ‘0‘ + MM;var dd = objD.getDate();if(dd<10) dd = ‘0‘ + dd;var hh = objD.getHours();if(hh<10) hh = ‘0‘ + hh;var mm = objD.getMinutes();if(mm<10) mm = ‘0‘ + mm;var ss = objD.getSeconds();if(ss<10) ss = ‘0‘ + ss;str = ?yy + "-" + MM + "-" + dd + " " + hh + ":" + mm + ":" + ss;return(str);}function tick(){var today;today = new Date();document.getElementById("localtime").value = showLocale(today);window.setTimeout("tick()", 1000);}tick();

try {User user = new User();Userdao userdao = new Userdao();User user = userdao.getByName(request.getParameter("username")); //根据表单输入的用户名查询数据表用户if (user.getUsername().equals(request.getParameter("username"))) {//判断用户名是否存在request.getRequestDispatcher("/signup.jsp").forward(request,response);}else{user.setUsername(request.getParameter("username"));//数据封装user.setPassword(request.getParameter("password"));user.setTel(request.getParameter("tel"));user.setIntroduce(request.getParameter("introduce"));user.setRole("customer");user.setTime(request.getParameter("time"));Userdao udao = new Userdao();udao.save(user);//调用UserDao里面save方法request.getRequestDispatcher("/login.jsp").forward(request, response);}}catch(Exception e){request.getRequestDispatcher("/signup.jsp").forward(request,response);}

//根据输入的用户名查找用户public User getByName(String username)throws Exception {// TODO Auto-generated method stubUser user = null;Connection con = null;PreparedStatement ps = null;ResultSet rs = null;try {Class.forName("com.mysql.jdbc.Driver");con = DriverManager.getConnection("jdbc:mysql://localhost:3306/bookstore","root", "123456");ps=con.prepareStatement("select * from t_user as u where u.username=?");ps.setString(1, username);rs = ps.executeQuery();if (rs.next()) {user = new User();user.setUsername(rs.getString("username"));user.setPassword(rs.getString("password"));user.setTel(rs.getString("tel"));user.setIntroduce(rs.getString("introduce"));user.setRole(rs.getString("role"));user.setTime(rs.getString("time"));}} catch (Exception e) {e.printStackTrace();throw new Exception("数据库访问出现异常:" + e);} finally { // 关闭数据库连接等

public void save(User user) throws Exception {// TODO Auto-generated method stubConnection con = null;PreparedStatement ps = null;try {Class.forName("com.mysql.jdbc.Driver");con = DriverManager.getConnection("jdbc:mysql://localhost:3306/bookstore","root", "123456");ps=con.prepareStatement("insert into t_user value(null,?,?,?,?,?,?)");ps.setString(1,user.getUsername());ps.setString(2, user.getPassword());ps.setString(3, user.getTel());ps.setString(4,user.getIntroduce());ps.setString(5, user.getRole());ps.setString(6, user.getTime());ps.executeUpdate();} catch (Exception e) {// TODO: handle exceptione.printStackTrace();throw new Exception("数据库出现异常"+e);}finally{

String msg = null; ??//反馈信息try {//根据输入的用户名查找登录用户Userdao userdao = new Userdao();User user = userdao.getByName(request.getParameter("username")); //调用getByName方法，注册中已经写了 ，直接调用if(user == null){request.getRequestDispatcher("/login.jsp").forward(request,response);msg = "用户名不存在"; }else if (!user.getPassword().equals(request.getParameter("password"))) {request.getRequestDispatcher("/login.jsp").forward(request,response);msg = "密码错误"; } else { ?//登录成功，将登录用户user存入session范围request.getSession(true).setAttribute("user", user);request.getSession(true).setAttribute("isLogin", "ok");//后面配置过滤器阻止非登陆直接提交if(user.getRole().equals("管理员")){ ??//管理员，则转到管理首页request.getRequestDispatcher("/admin/admin_index.jsp").forward(request, response);}else if(user.getRole().equals("customer")){ //一般客户，则转到客户首页HttpSession session = request.getSession();session.setAttribute("customer", user); ??//将当前登录的客户对象绑定（存储）在session范围request.getRequestDispatcher("/customer/custindex.jsp").forward(request, response);//将客户（登录角色为客户）管理相关的页面置于customer目录下以便于管理}}}catch(Exception e){request.getRequestDispatcher("/login.jsp").forward(request,response);msg = e.toString();}request.setAttribute("msg", msg);