题目要求：

1登录账号：要求由6到12位字母、数字、下划线组成，只有字母可以开头；（1分）

2登录密码：要求显示“• ”或“*”表示输入位数，密码要求八位以上字母、数字组成。（1分）

3性别：要求用单选框或下拉框实现，选项只有“男”或“女”；（1分）

4学号：要求八位数字组成，前四位为“2018”开头，输入自己学号；（1分）

5姓名：输入自己的姓名；

5电子邮箱：要求判断正确格式xxxx@xxxx.xxxx；（1分）

6点击“添加”按钮，将学生个人信息存储到数据库中。（3分）

7可以演示连接上数据库。（2分）

1.数据库连接

package zzm;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

/**

 * 数据库连接工具

 * @author Hu

 *

 */

public class DBUtil {

    public static String db_url = "jdbc:mysql://localhost:3306/zzm?useSSL=false";

    public static String db_user = "root";

    public static String db_pass = "********";

    public static Connection getConn () {

        Connection conn = null;

        try {

            Class.forName("com.mysql.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();

            }

        }

    }

}

2..创建所需变量

package zzm;

public class Zzm {

    private int id;

    private String zhanghao;

    private String password;

    private String sex;

    private String number;

    private String name;

    private String mail;

    private String xueyuan;

    private String zhuanye;

    private String banji;

    private String year;

    private String shengyuandi;

    private String beizhu;

    public int getId()

    {

        return id;

    }

    public void setId()

    {

        this.id=id;

    }

    public String getZhanghao()

    {

        return zhanghao;

    }

    public void setZhanghao()

    {

        this.zhanghao=zhanghao;

    }

    public String getPassword()

    {

        return password;

    }

    public void setPassword()

    {

        this.password=password;

    }

    public String getSex()

    {

        return sex;

    }

    public void setSex()

    {

        this.sex=sex;

    }

    public String getName()

    {

        return name;

    }

    public void setName()

    {

        this.name=name;

    }

    public String getMail()

    {

        return mail;

    }

    public void setMail()

    {

        this.mail=mail;

    }

    public String getNumber()

    {

        return number;

    }

    public void setNumber()

    {

        this.number=number;

    }

    public String getXueyuan()

    {

        return xueyuan;

    }

    public void setXueyuan()

    {

        this.xueyuan=xueyuan;

    }

    public String getZhuanye()

    {

        return zhuanye;

    }

    public void setZhuanye()

    {

        this.zhuanye=zhuanye;

    }

    public String getBanji()

    {

        return banji;

    }

    public void setBanji()

    {

        this.banji=banji;

    }

    public String getYear()

    {

        return year;

    }

    public void setYear()

    {

        this.year=year;

    }

    public String getShengyuandi()

    {

        return shengyuandi;

    }

    public void setShengyuandi()

    {

        this.shengyuandi=shengyuandi;

    }

    public String getBeizhu()

    {

        return beizhu;

    }

    public void setBeizhu()

    {

        this.beizhu=beizhu;

    }

    public Zzm() {}

    public Zzm(int id,String zhanghao,String password,String sex,String name,String number,String mail,String xueyuan,String zhuanye,String banji,String year,String shengyuandi,String beizhu)

    {

        this.id=id;

        this.zhanghao = zhanghao;

        this.password = password;

        this.name = name;

        this.sex = sex;

        this.number =number;

        this.name = name;

        this.mail = mail;

        this.xueyuan = xueyuan;

        this.zhuanye = zhuanye;

        this.banji = banji;

        this.year = year;

        this.shengyuandi = shengyuandi;

        this.beizhu = beizhu;

    }

    public Zzm(String zhanghao, String password,String sex, String name,String number,String mail,String xueyuan,String zhuanye,String banji,String year,String shengyuandi,String beizhu)

    {

        this.zhanghao = zhanghao;

        this.password = password;

        this.name = name;

        this.sex = sex;

        this.number = number;

        this.mail = mail;

        this.xueyuan = xueyuan;

        this.zhuanye = zhuanye;

        this.banji = banji;

        this.year = year;

        this.shengyuandi = shengyuandi;

        this.beizhu = beizhu;

    }

}

3.创建中间层，收集网页表单的数据

package zzm;

import java.io.IOException;

import java.util.List;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

@WebServlet("/ZzmServlet")

public class ZzmServlet extends HttpServlet {

    private static final long serialVersionUID = 1L;

    ZzmService service = new ZzmService();

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

        req.setCharacterEncoding("utf-8");

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

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

            add(req, resp);

        }

    }

    /**

     * 添加

     * @param req

     * @param resp

     * @throws IOException

     * @throws ServletException

     */

    private void add(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException {

        req.setCharacterEncoding("utf-8");

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

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

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

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

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

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

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

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

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

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

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

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

        Zzm zzm= new Zzm(zhanghao,password,sex,name,number,mail,xueyuan,zhuanye,banji,year,shengyuandi,beizhu);

        //添加后消息显示

        if(service.add(zzm)) {

            req.setAttribute("message", "添加成功");

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

        } else {

            req.setAttribute("message", "用户名重复，请重新输入");

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

        }

    }

}

4.创建Dao接口，实现基本的数据库操作

package zzm;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.ArrayList;

import java.util.List;

/**

 *

 * Dao层操作数据

 * @author Zhao

 *

 */

public class ZzmDao {

    /**

     * 添加

     * @param zzm

     * @return

     */

    public boolean add(Zzm zzm) {

        String sql = "insert into zzm(zhanghao,password,sex,name,number,mail,xueyuan,zhuanye,banji,year,shengyuandi,beizhu) values('" + zzm.getZhanghao() + "','" + zzm.getPassword() + "','" + zzm.getSex() + "','"+zzm.getName()+"','" + zzm.getNumber() + "','" + zzm.getMail()+"','"+zzm.getXueyuan()+"','"+zzm.getZhuanye()+"','"+zzm.getBanji() +"','"+zzm.getYear()+"','"+zzm.getShengyuandi()+"','"+zzm.getBeizhu() +"')";

        Connection conn = DBUtil.getConn();

        Statement state = null;

        boolean f = false;

        int a = 0;

        try {

            state = conn.createStatement();

            state.executeUpdate(sql);

        } catch (Exception e) {

            e.printStackTrace();

        } finally {

            DBUtil.close(state, conn);

        }

        if (a > 0) {

            f = true;

        }

        return f;

    }

    public boolean zhanghao(String zhanghao) {

        // TODO Auto-generated method stub

        return false;

    }

}

5.创建服务层，

package zzm;

import java.util.List;

/**

 * ZzmService

 * 服务层

 * @author Zhao

 *

 */

public class ZzmService {

    ZzmDao cDao = new ZzmDao();

    /**

     * 添加

     * @param Zzm

     * @return

     */

    public boolean add(Zzm zzm) {

        boolean f = false;

        if(!cDao.zhanghao(zzm.getZhanghao())) {

            cDao.add(zzm);

            f = true;

        }

        return f;

    }

}

6.绘制界面操作（jsp）

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

    pageEncoding="utf-8"%>

<!DOCTYPE html>

<html>

<head>

<meta charset="utf-8">

<title></title>

<link rel="stylesheet" type="text/css" href="css/nav.css">

<link rel="stylesheet" type="text/css" href="font/iconfont.css">

<script type="text/javascript" src="js/jquery.min.js"></script>

<script type="text/javascript" src="js/nav.js"></script>

</head>

<body>

<%

         Object message = request.getAttribute("message");

         if(message!=null && !"".equals(message)){

    %>

         <script type="text/javascript">

              alert("<%=request.getAttribute("message")%>");

         </script>

    <%} %>

    <div align="center">

<form action="ZzmServlet?method=add" method="post" onsubmit="return check()">

<table  width="500px" height="650px"border="1" style="text-align:center">

         <tr height="50px" align="center" bgcolor="#FFFFCC">

           <td width="100"><font color="black"style="font-family:宋体;">登录账号:</font></td>

            <td width="400"><input  id="zhanghao" name="zhanghao" placeholder="请输入账号"/></td>

        </tr>

        <tr height="50px" align="center" bgcolor="#FFFFCC">

           <td width="100"><font color="black"style="font-family:宋体;">登录密码:</font></td>

            <td width="400"><input  type="password" name="password" placeholder="请输入密码"/></td>

        </tr>

         <tr height="50" align="center" bgcolor="#FFFFCC">

           <td width="100"><font color="black"style="font-family:宋体;">性别:</font></td>

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

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

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

                </select></td>

            </tr>

                    <tr height="50px" align="center" bgcolor="#FFFFCC">

           <td width="100"><font color="black"style="font-family:宋体;">姓名:</font></td>

            <td width="400"><input  id="name" name="name" placeholder="请输入姓名"/></td>

        </tr>

            <tr height="50" align="center" bgcolor="#FFFFCC">

           <td width="100"><font color="black"style="font-family:宋体;">学号:</font></td>

            <td width="400"><input  id="number" name="number" placeholder="请输入学号"/></td>

            </tr>

            <tr height="50" align="center" bgcolor="#FFFFCC">

           <td width="100"><font color="black"style="font-family:宋体;">电子邮箱:</font></td>

            <td width="400"><input  id="mail" name="mail" placeholder="请输入邮箱" /></td>

            </tr>

            <tr height="50" align="center" bgcolor="#FFFFCC">

           <td width="100"><font color="black"style="font-family:宋体;">所在学院:</font></td>

            <td width="400"><input  id="xueyuan" name="xueyuan" placeholder="请输入学院名" /></td>

            </tr>

            <tr height="50" align="center" bgcolor="#FFFFCC">

           <td width="100"><font color="black"style="font-family:宋体;">所在专业:</font></td>

            <td width="400"><input  id="zhuanye" name="zhuanye" placeholder="请输入专业" /></td>

            </tr>

            <tr height="50" align="center" bgcolor="#FFFFCC">

           <td width="100"><font color="black"style="font-family:宋体;">所在班级:</font></td>

            <td width="400"><input  id="banji" name="banji" placeholder="请输入班级" /></td>

            </tr>

            <tr height="50" align="center" bgcolor="#FFFFCC">

           <td width="100"><font color="black"style="font-family:宋体;">入学年份:</font></td>

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

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

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

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

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

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

                </select></td>

            </tr>

            <tr height="50" align="center" bgcolor="#FFFFCC">

           <td width="100"><font color="black"style="font-family:宋体;">生源地:</font></td>

            <td width="400"><input  id="shengyuandi" name="shengyuandi" placeholder="请输入生源地" /></td>

            </tr>

            <tr height="100" align="center" bgcolor="#FFFFCC">

           <td width="100"><font color="black"style="font-family:宋体;">备注:</font></td>

            <td width="400"><input  id="beizhu" name="beizhu" placeholder="无" /></td>

            </tr>

            <tr height="50" align="center" bgcolor="#FFFFCC">

            <td width="400"><button type="submit" >添加</button></td>

            <td width="400"><input type="reset"  value="重新输入" /></td>

            </tr>

</form>

</div>

<script type="text/javascript">

function check() {

    var zhanghao = document.getElementById("zhanghao");

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

    var number = document.getElementById("number");

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

    if (!zhanghao.value.match(/^[a-zA-Z]\w{5,11}$/)) {

        alert("输入错误，请以英文字母开头 长度6-12");

        num.focus();

        return false;

}

    else if (!password.value.match(/^[A-Za-z0-9]\w{7,20}$/)) {

     alert(" 密码由八位及其以上以上英文和数字组成");

     mima.focus();

     return false;

}

    else if(number.value<"20180000"|| number.value>"20189999")

        {

         alert(" 学号由2018开头的八位组成");

         number.focus();

         return false;

        }

    else if (!mail.value.match(/^[a-z0-9]+([._\\-]*[a-z0-9])*@([a-z0-9]+[-a-z0-9]*[a-z0-9]+.){1,63}[a-z0-9]+$/)) {

     alert(" 邮箱格式错误");

     mail.focus();

     return false;

}

}

</script>

</body>

</html>

界面：

实验总结：

java web的一些基础功能已经可以实现。

数据库的连接操作目前已经可以很好的实现；

第一次java web 小测验做的还行

如果按独立搞的不查询 可以得到7分左右；

以后要多多练习 java web小程序的编写！

最新文章

  1. 在linux下Ant的环境配置
  2. 关于imagic拼接透明背景图片的问题
  3. 只用一行代码让你的ASP.NET MVC 跑起来
  4. RPC和Socket,RMI和RPC之间的关系
  5. cocos2dx 3.x(常见的46种动作)
  6. eclispe使用外部tomcat总结
  7. 读Java Concurrency in Practice. 第六章.
  8. Can jxta be used to develop online card game (p2p style)?
  9. jQuery中要注意的一些函数
  10. oracle数据库创建用户，并且给用户授权
  11. ubuntu 恢复gnome-panel
  12. 各种数据库使用JDBC连接的方式
  13. 从URI中获取实际的文件path
  14. 使用VisualStudio进行单元测试之二
  15. CSU1661: Query Mutiple
  16. Python新手学习基础之函数-关键字参数
  17. python 中文异常问题记录
  18. Ubuntu 16.04开启SSH服务
  19. 搭建简易的WebServer(基于pyhton实现简易Web框架 使用socket套接字)
  20. ztree带有选项框的树形菜单使用

热门文章

  1. 自定义类支持foreach
  2. c++运行程序 改变字和背景的颜色与窗口大小和位置 (c++)(windows)
  3. mysql 利用延迟关联优化查询（select * from your_table order by id desc limit 2000000,20）
  4. Burp Suite Proxy Module - 代理模块
  5. js中实现继承的方法
  6. ISE第三方编辑器的使用
  7. Python过滤掉numpy.array中非nan数据实例
  8. 目前解决移动端1px边框最好的方法
  9. idea 导入eclipse play1.2.7项目
  10. javascrip jason