java web第一次课堂测试1

---恢复内容开始---

要求如图：

本程序包括四个文件，一个显示界面的jsp文件，一个dao层文件，一个servlet层文件一个连接数据库的文件

下面依次附上代码：

前端界面：

<%@ page language="java" contentType="text/html; charset=UTF-8"

    pageEncoding="UTF-8"%>

<!DOCTYPE html>

<html>

<head>

<meta charset="UTF-8">

<title>注册界面</title>

<script type="text/javascript">

/*表单校验*/

function check() {

    f=0;

    var re =  /^[\w\u4e00-\u9fa5]{6,8}$/;  //判断字符串是否为数字和字母组合

    var myPattern = new RegExp("^[a-zA-Z]"); // 以英文字母开头

    var username = document.getElementById("username").value;

    //alert(username.length);

    if(!(username.length>5&&username.length<13)){

        alert("用户名长度错误！");return false;

    }

    else if(!(re.test(username))){

        alert("用户名组成内容错误！");return false;

    }else if(!(myPattern.exec(username))){

        alert("用户名开头必须是字母！");return false;

    }

    var password = document.getElementById("password").value;

    var pas= /\w/;

    if(password.length<8){f++;alert("密码长度必须大于8位!");return false;}

    if(!(pas.test(password))){

        alert("密码应由数字和字母组成!");return false;

    }

    var xuehao = document.getElementById("xuehao").value;

    if(xuehao.length!=8){

        alert("学号必须为8位!");return false;

    }

    if(xuehao[0]=='2'&&xuehao[1]=='0'&&xuehao[2]=='1'&&xuehao[3]=='8'){f++;}

    else{

        alert("学号必须以2018开头!");return false;

    }

    var mail = document.getElementById("mail").value;

    if(/^([a-zA-Z0-9_-])+@([a-zA-Z0-9_-])+(.[a-zA-Z0-9_-])+/.test(mail)){f++;}

    else{

        alert("邮箱格式错误！");return false;

    }

    if(f>1){

        alert("恭喜您已入住铁大软工大家(da)庭(keng)!");

        return true;

    }

    else{

        return false;

    }

}

</script>

</head>

<STYLE TYPE="text/css">

<!--

BODY {background-image:URL(1.png);

background-position:center;

background-repeat:no-repeat;

background-atachment:fixed;

}

table{margin:auto}

-->

</STYLE>

<body >

<form action="UserServlet?method=add" method="post" onsubmit="return check()"><br/><br/><br/><br/><br/><br/><br/>

<table frame= "box">

            <tr>

            <td>登入账号：</td>

                <td><input type="text"  id="username" name="username" value="" ></td>

                <td>账号应为6到12位的英文或数字,下划线组成,且由英文开头.<td>

            </tr>

            <tr>

            <td>登入密码：</td>

               <td> <input type="password"  id="password" name="password"  value="" ></td>

               <td>密码应由大于8位的数字和英文组成.<td>

            </tr>

            <tr>

            <td>性&nbsp;&nbsp;&nbsp;&nbsp;别：</td>

               <td>

               <select id="sex" name="sex" >

                    <option>--请选择--</option>

                        <option  value="男">男</option>

                        <option  value="女">女</option>

                    </select>

               </td>

            </tr>

            <tr>

            <td>姓&nbsp;&nbsp;&nbsp;&nbsp;名：</td>

               <td> <input type="text"  name="name"   value="" ></td>

            </tr>

            <tr>

            <td>学&nbsp;&nbsp;&nbsp;&nbsp;号：</td>

               <td> <input type="text"  name="xuehao" id="xuehao"  value="" ></td>

               <td>学号应为2018开头的八位数字.<td>

            <tr>

            <td>电子邮件：</td>

               <td> <input type="text" id="mail" name="mail"  value="" ></td>

               <td>电子邮件应符合其格式.<td>

            </tr>

            <tr>

            <td>所在学院：</td>

               <td> <input type="text" id="xueyuan" name="xueyuan"  value="" ></td>

            </tr>

            <tr>

            <td>所在系：</td>

               <td> <input type="text" id="xi" name="xi"  value="" ></td>

            </tr>

            <tr>

            <td>所在班级：</td>

               <td> <input type="text" id="ban" name="ban"  value="" ></td>

            </tr>

            <tr>

            <td>入学年份（届）：</td>

               <td>

               <select id="year" name="year">

                    <option>--请选择--</option>

                        <option value="2018">2018</option>

                        <option value="2017">2019</option>

                        <option value="2016">2018</option>

                        <option value="2015">2019</option>

                        <option value="2014">2018</option>

                    </select>

               </td>

            </tr>

            <tr>

            <td>生源地：</td>

               <td>

               <select name="address">

               <option value ="河北省">河北省</option>

               <option value ="北京市">北京市</option>

               <option value ="天津市">天津市</option>

               <option value ="武安市">武安市</option>

               </select>

               </td>

            </tr>

            <tr>

            <td>备注：</td>

               <td> <input type="text" id="beizhu" name="beizhu"  value="" ></td>

            </tr>

            <tr>

            <td><td>

                <td> <button type="submit" >添&nbsp;&nbsp;&nbsp;&nbsp;加</button></td>

            </tr>

        </table>

</form>

</body>

</html>

servlet层文件：

package Servlet;

import java.io.IOException;

import java.io.IOException;

import java.sql.Connection;

import java.sql.PreparedStatement;

import dao.Dao;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

public class UserServlet extends HttpServlet {

     private static final long serialVersionUID = 1L;

        /**

         * @see HttpServlet#HttpServlet()

         */

        public UserServlet() {

            super();

            // TODO Auto-generated constructor stub

        }

        Dao dao = new Dao();

        protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

               req.setCharacterEncoding("utf-8");

               String method = req.getParameter("method");

               System.out.println(method);

               if ("add".equals(method)) {

                   System.out.println("ok");

                   String user = req.getParameter("username");

                   String password = req.getParameter("password");

                   String sex = req.getParameter("sex");

                   String name = req.getParameter("name");

                   String xuehao = req.getParameter("xuehao");

                   String mail = req.getParameter("mail");

                   String school = req.getParameter("xueyuan");

                   String xi = req.getParameter("xi");

                   String banji = req.getParameter("ban");

                   String nianfen = req.getParameter("year");

                   String place = req.getParameter("address");

                   String beizhu = req.getParameter("beizhu");

                   boolean pd=Dao.add(user, password, sex, name, xuehao, mail, school, xi, banji, nianfen, place, beizhu);

                   if(pd) {

                       req.setAttribute("message", "注册成功");

                       req.getRequestDispatcher("register.jsp").forward(req,resp);

                   }else {

                       req.setAttribute("message", "注册失败，请重新注册");

                       req.getRequestDispatcher("register.jsp").forward(req,resp);

                   }

               }

        }

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

    // TODO Auto-generated method stub

    response.getWriter().append("Served at: ").append(request.getContextPath());

}

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

    // TODO Auto-generated method stub

    doGet(request, response);

}

}

dao层文件：

package dao;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import database.DB;

public class Dao {

       public static boolean add(String username,String password,String sex,String name,String xuehao,String mail,String school,String xi,String banji,String nianfen,String place,String beizhu) {

            Connection conn = null;

            PreparedStatement pstmt = null;

            boolean pd = false;

            System.out.println("add run!");

            try {

                //获取连接

                conn = DB.getConn();

                //编写语句

                String sql = "insert into student values(?,?,?,?,?,?,?,?,?,?,?,?)";

                //预编译

                pstmt = conn.prepareStatement(sql);

                //设置数据

                pstmt.setString(1, username);

                pstmt.setString(2, password);

                pstmt.setString(3, sex);

                pstmt.setString(4, name);

                pstmt.setString(5, xuehao);

                pstmt.setString(6, mail);

                pstmt.setString(7, school);

                pstmt.setString(8, xi);

                pstmt.setString(9, banji);

                pstmt.setString(10, nianfen);

                pstmt.setString(11, place);

                pstmt.setString(12, beizhu);

                //执行

                int res = pstmt.executeUpdate();

                //判断

                if(res>0) {

                    pd=true;

                }else {

                    pd=false;

                }

            } catch (Exception e) {

                e.printStackTrace();

            }finally {

                DB.close(pstmt,conn);

            }

            return pd;

        }

}

连接数据库的文件：

 package database;

 import java.sql.Connection;

 import java.sql.DriverManager;

 import java.sql.PreparedStatement;

 import java.sql.ResultSet;

 import java.sql.SQLException;

 import java.sql.Statement;

 public class DB {public static String db_url = "jdbc:mysql://localhost:3306/student?useSSL=false&serverTimezone=UTC&characterEncoding=UTF-8";

 public static String db_user = "root";

 public static String db_pass = "abc456";

 public static Connection getConn () {

     Connection conn = null;

     try {

         Class.forName("com.mysql.cj.jdbc.Driver");//加载驱动

         conn = DriverManager.getConnection(db_url, db_user, db_pass);

     } catch (Exception e) {

         e.printStackTrace();

     }

     return conn;

 }

 /**

  * 关闭连接

  * @param state

  * @param conn

  */

 public static void close (Statement state, Connection conn) {

     if (state != null) {

         try {

             state.close();

         } catch (SQLException e) {

             e.printStackTrace();

         }

     }

     if (conn != null) {

         try {

             conn.close();

         } catch (SQLException e) {

             e.printStackTrace();

         }

     }

 }

 public static void close (ResultSet rs, Statement state, Connection conn) {

     if (rs != null) {

         try {

             rs.close();

         } catch (SQLException e) {

             e.printStackTrace();

         }

     }

     if (state != null) {

         try {

             state.close();

         } catch (SQLException e) {

             e.printStackTrace();

         }

     }

     if (conn != null) {

         try {

             conn.close();

         } catch (SQLException e) {

             e.printStackTrace();

         }

     }

 }

 public static void main(String[] args) throws SQLException {

     Connection conn = getConn();

     PreparedStatement pstmt = null;

     ResultSet rs = null;

     String sql ="select * from USER";

     pstmt = conn.prepareStatement(sql);

     rs = pstmt.executeQuery();

     if(rs.next()){

         System.out.println("空");

     }else{

         System.out.println("不空");

     }

 }

 }