java添加信息_Javaweb链接数据库进行信息添加

首先构建界面框架，用html写界面，连接数据库。。。。实现对信息的添加

jsp文件

pageEncoding="UTF-8"%>

Insert title here

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

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

%>

alert("");

}

%>

style="width: 30%;margin:auto;background:rgb(195,195,195)" bordercolor="red" >

注册用户用户名:密码:姓名:性别:

男   

女

生源地:手机号:邮箱:学号:学校:班级:系:入学年份:

2010

2011

2012

2013

2014

2015

2016

2017

2018

2019

2020

2021

备注:

function check(form){

if(form.username.value.length<6 || form.username.value.length>12 || new RegExp("[^a-zA-Z0-9_\u4e00-\u9fa5]").test(form.username.value)){

alert("登陆账号必须由6-12位英文字符或数字或下划线组成！");

form.username.focus();

return false;

}

if(new RegExp("[^a-zA-Z]").test(form.username.value.substring(0,1))){

alert("登陆账号必须以英文字母开头！");

form.username.focus();

return false;

}

if(form.password.value.length < 8 || new RegExp("[^0-9a-zA-Z]").test(form.password.value)){

alert("密码由八位以上数字或字母组成！");

form.password.focus();

return false;

}

var re = /^\d{4}/;

if(form.stnumber.value.length != 8 || form.stnumber.value.match(re)[0]!='2018'){

alert("学号由八位组成，前四位是2018");

form.password.focus();

return false;

}

//以数字字母开头，中间可以是多个数字字母或下划线；然后是“@”；然后是数字字母；然后是“.”；最后是2-4个字母结尾

var regex = /^([a-zA-Z]|[0-9])(\w|\-)+@[a-zA-Z0-9]+\.([a-zA-Z]{2,4})$/;

if(!regex.test(form.email.value)){

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

form.email.focus();

return false;

}

return true;

}

package Entity;

public class User {

private String username;

private String password;

private String name;

private String sex;

private String address;

private String tel;

private String email;

private String stnumber;

private String school;

private String classes;

private String xi;

private String time;

private String beizhu;

public String getUsername() {

return username;

}

public void setUsername(String username) {

this.username = username;

}

public String getPassword() {

return password;

}

public void setPassssword(String password) {

this.password = password;

}

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

public String getSex() {

return sex;

}

public void setSex(String sex) {

this.sex = sex;

}

public String getAddress() {

return address;

}

public void setAddress(String address) {

this.address = address;

}

public String getTel() {

return tel;

}

public void setTel(String tel) {

this.tel = tel;

}

public String getEmail() {

return email;

}

public void setEmail(String email) {

this.email = email;

}

public String getStnumber() {

return stnumber;

}

public void setStnumber(String stnumber) {

this.stnumber=stnumber;

}public String getSchool() {

return school;

}

public void setSchool(String school) {

this.school=school;

}

public String getClasses() {

return classes;

}

public void setClasses(String classes) {

this.classes=classes;

}

public String getXi() {

return xi;

}

public void setXi(String xi) {

this.xi=xi;

}

public String getTime() {

return time;

}

public void setTime(String time) {

this.time=time;

}public String getBeizhu() {

return beizhu;

}

public void setBeizhu(String beizhu) {

this.beizhu=beizhu;

}

public User() {}

public User(String username,String password,String name,String sex,String address,String tel,String email,String stnumber,String school,String classes,String xi,String time,String beizhu) {

this.username=username;

this.password=password;

this.name=name;

this.sex=sex;

this.address=address;

this.tel=tel;

this.email=email;

this.stnumber=stnumber;

this.school=school;

this.classes=classes;

this.xi=xi;

this.time=time;

this.beizhu=beizhu;

}

}

package Servlet;

import java.io.IOException;

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 Dao.Dao;

import Entity.User;

@WebServlet("/Servlet")

public class Servlet extends HttpServlet {

private static final long serialVersionUID = 1L;

public Servlet() {

super();

}

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

}

}

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

req.setCharacterEncoding("utf-8");

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

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

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

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

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

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

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

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

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

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

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

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

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

User user = new User(username,password,name,sex,address,tel,email,stnumber,school,classes,xi,time,beizhu);

Dao dao =new Dao();

boolean f=dao.add(user);

if(f) {

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

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

} else {

req.setAttribute("message", "注册失败！");

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

}

}

}

package DBUtil;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

/**

* ���ݿ����ӹ���

* @author W

*

*/

public class DBUtil {

public static String db_url = "jdbc:mysql://localhost:3307/user";

public static String db_user = "root";

public static String db_pass = "011016";

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;

}

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

pstmt = conn.prepareStatement(sql);

rs = pstmt.executeQuery();

if(rs.next()){

System.out.println("空");

}else{

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

}

}

}

package Dao;

import java.sql.Connection;

import java.sql.Statement;

import DBUtil.DBUtil;

import Entity.User;

public class Dao {

public boolean add(User user) {

// TODO Auto-generated method stub

String sql = "insert into users(username,password,name,sex,address,tel,email,stnumber,school,classes,xi,time,beizhu) values('"+ user.getUsername() + "','"+ user.getPassword() +"','"+ user.getName() +"','" + user.getSex() +"','"+ user.getAddress() +"','"+ user.getTel() +"','"+user.getEmail()+"','"+user.getStnumber()+"','"+user.getSchool()+"','"+user.getClasses()+"','"+user.getXi()+"','"+user.getTime()+"','"+user.getBeizhu()+"')";

Connection conn = DBUtil.getConn();

Statement state = null;

boolean f = false;

int a = 0;

try {

state = conn.createStatement();

a=state.executeUpdate(sql);

} catch (Exception e) {

e.printStackTrace();

} finally {

DBUtil.close(state, conn);

}

if (a > 0) {

f = true;

}

return f;

}

}