第七周作业

package com.kjschool.javaweb.servlet;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.io.IOException;

@WebServlet(name = "registerServlet")
public class registerServlet extends HttpServlet {

    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        String username=request.getParameter("username");
        String password=request.getParameter("password");
        String realname= new String(request.getParameter("realname").getBytes("iso8859-1"),"UTF-8");
        String name= new String(request.getParameter("name").getBytes("iso8859-1"),"UTF-8");
        String brith=request.getParameter("brith");

        int count=t_userDao.insertuser(username,password,realname);
        t_userDao.insert(name,brith);
        if (count==1){
            HttpSession session=request.getSession();
            session.setAttribute("realname",realname);
            response.sendRedirect(request.getContextPath() + "/firstpage.jsp");
        }
    }

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

    }
}

public static int insertuser(String username, String password,String realname) {
        Connection conn = null;
        PreparedStatement ps = null;
        int count = 0;
        try {
            //获取连接
            conn = DBUtils.getConnection();
            //获取预编译的数据库操作对象
            String sql = "insert into t_users (login_name,login_pwd,real_name) values (?,?,?)";

            ps = conn.prepareStatement(sql);
            //传值
            ps.setString(1, username);
            ps.setString(2, password);
            ps.setString(3,realname);
            count = ps.executeUpdate();
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        } finally {
            DBUtils.close(conn, ps, null);
        }
        return count;
    }

ourceBundle.getBundle("resources.db");
    //注册驱动
    static{
        try {
            Class.forName(bundle.getString("driver"));
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }
    //获取数据库连接对象
    public static Connection getConnection() throws SQLException {
        String url=bundle.getString("url");
        String user=bundle.getString("user");
        String password=bundle.getString("password");
        Connection conn= DriverManager.getConnection(url,user,password);
        return conn;
    }
    //释放资源
    public  static void close(Connection conn, Statement stmt, ResultSet rs){
        if (rs != null) {
            try {
                rs.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
        if (stmt != null) {
            try {
                stmt.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
        if (conn != null) {
            try {
                conn.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
    }

}

ourceBundle.getBundle("resources.db");
    //注册驱动
    static{
        try {
            Class.forName(bundle.getString("driver"));
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }
    //获取数据库连接对象
    public static Connection getConnection() throws SQLException {
        String url=bundle.getString("url");
        String user=bundle.getString("user");
        String password=bundle.getString("password");
        Connection conn= DriverManager.getConnection(url,user,password);
        return conn;
    }
    //释放资源
    public  static void close(Connection conn, Statement stmt, ResultSet rs){
        if (rs != null) {
            try {
                rs.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
        if (stmt != null) {
            try {
                stmt.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
        if (conn != null) {
            try {
                conn.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
    }

}

<!DOCTYPE html>
<html>
    <head>
        <meta charset="UTF-8">
        <title></title>
        <style type="text/css">
            span{
                font-size: 15px;
                color: #ff0000;
            }
        </style>
    </head>
    <body>
        <script type="text/javascript">
            window.onload=function(){
                var namespan=document.getElementById("namespan");
                var usernameElt=document.getElementById("username");
                usernameElt.onblur=function(){
                    var username=usernameElt.value;
                    username=username.trim();
                    if (username=="") {
                        namespan.innerHTML="用户名不能为空";
                    } else{
                        if (username.length<6||username.length>12) {
                            namespan.innerHTML="用户名在[6,12]之间"
                        }else{
                            var regExp=/^[a-zA-Z0-9]+$/
                            var ok=regExp.test(username)
                            if (!ok) {
                                namespan.innerHTML="用户名只能由字母和数字组成"
                            }
                        }
                    }
                }
                usernameElt.onfocus=function(){
                    namespan.innerHTML=""
                }
                
                
                var passspan=document.getElementById("passspan");
                var passwordelt=document.getElementById("secondpassword");
                passwordelt.onblur=function(){    
                    var password=document.getElementById("password").value;
                    var secondpassword=passwordelt.value;
                    password=password.trim();
                    secondpassword=secondpassword.trim();
                    /*if (secondpassword=="") {
                        passspan.innerHTML="确认密码不能为空";
                    }else{*/
                        if (password==""||secondpassword=="") {
                        passspan.innerHTML="密码不能为空";
                        }else{
                            if (password!=secondpassword) {
                                passspan.innerHTML="两次密码不一致";
                            } 
                        }
                    /*}*/        
                }
                passwordelt.onfocus=function(){
                    passspan.innerHTML="";
                }
                
                document.getElementById("zhuce").onclick=function(){
                    usernameElt.focus();
                    usernameElt.blur();
                    document.getElementById("secondpassword").focus();
                    document.getElementById("secondpassword").blur();
                    if (namespan.innerHTML==""&& passspan.innerHTML=="") {
                        var formobj=document.getElementById("userform")
                        formobj.submit();
                    }
                
            }
        }
        </script>
        <form action="register"  id="userform" method="post">
        用户名：<input type="text" name="username" id="username"  /><span id="namespan">    </span><br />
        密码： <input type="password" name="password" id="password" /></span><br />
        确认密码： <input type="password"  id="secondpassword"  /><span id="passspan"></span><br />
        昵称：<input type="text" id="realname" name="realname"><br>
            姓名：<input type="text" name="name"><br>
            生日：<input type="text" name="brith"><br>
        <input type="button" name="zhuce" id="zhuce" value="注册" />
            <input type="reset" value="重置">
        </form>
    </body>
</html>

ackage com.kjschool.javaweb.servlet;

import com.sun.deploy.net.HttpRequest;

import javax.servlet.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;
import java.io.IOException;
import java.util.logging.LogRecord;

public class OneFilter implements Filter {


    @Override
    public void init(FilterConfig filterConfig) throws ServletException {

    }
    @Override
    public void doFilter(ServletRequest servletRequest, ServletResponse servletResponse, FilterChain filterChain) throws IOException, ServletException {
        HttpServletRequest request= (HttpServletRequest) servletRequest;
        HttpSession session=null;
        //获取uri
        String uri=request.getRequestURI();
        if ("login".indexOf(uri)!=-1||"/examination_war_exploded/".equals(uri)) {
            filterChain.doFilter(servletRequest,servletResponse);
            return;
        }
        session = request.getSession(false);
        if(session!=null){
            filterChain.doFilter(servletRequest,servletResponse);
        }else {
            request.getRequestDispatcher("/loginerror.jsp").forward(servletRequest,servletResponse);
        }

    }

    @Override
    public void destroy() {

    }

}