java网站测试_javaweb 测试

题目要求：

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

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

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

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

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

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

7可以演示连接上数据库。(2分)

代码：

1连接数据库

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 = "123456";

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 lzx;

public class Lzx {

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 Lzx() {}

public Lzx(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 Lzx(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 lzx;

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 lzxDao {

/**

* 添加

* @param zzm

* @return

*/

public boolean add(Lzx 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;

}

}

4

package lzx;

import java.util.List;

/**

* ZzmService

* 服务层

* @author Zhao

*

*/

public class LzxService {

lzxDao cDao = new lzxDao();

/**

* 添加

* @param Zzm

* @return

*/

public boolean add(Lzx zzm) {

boolean f = false;

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

cDao.add(zzm);

f = true;

}

return f;

}

}

5

package lzx;

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("/LzxServlet")

public class LzxServlet extends HttpServlet {

private static final long serialVersionUID = 1L;

LzxService service = new LzxService();

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");

Lzx zzm= new Lzx(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);

}

}

}

6写页面

pageEncoding="utf-8"%>

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

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

%>

alert("");

登录账号:
登录密码:
性别:	男 女
姓名:
学号:
电子邮箱:
所在学院:
所在专业:
所在班级:
入学年份:	2015 2016 2017 2018 2019
生源地:
备注:
添加

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("用户名由六到十二英文字符和数字组成，以英文字母开头");

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"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;

}

}