Java Web学生信息保存
-
King
Course.java
package entity;
public class Course {
private int id;
private String num;
private String mima;
private String sex;
private String name;
private String studentnum;
private String youxiang;
private String xueyuan;
private String xi;
private String banji;
private String year;
private String plase;
private String beizhu;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getNum() {
return num;
}
public void setNum(String num) {
this.num = num;
}
public String getMima() {
return mima;
}
public void setMima(String mima) {
this.mima = mima;
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
public String getStudentnum() {
return studentnum;
}
public void setStudentnum(String studentnum) {
this.studentnum = studentnum;
}
public String getYouxiang() {
return youxiang;
}
public void setYouxiang(String youxiang) {
this.youxiang = youxiang;
}
public String getXueyuan() {
return xueyuan;
}
public void setXueyuan(String xueyuan) {
this.xueyuan = xueyuan;
}
public String getXi() {
return xi;
}
public void setXi(String xi) {
this.xi = xi;
}
public String getBanji() {
return banji;
}
public void setBanji(String banji) {
this.banji = banji;
}
public String getYear() {
return year;
}
public void setYear(String year) {
this.year = year;
}
public String getPlase() {
return plase;
}
public void setPlase(String plase) {
this.plase = plase;
}
public String getBeizhu() {
return beizhu;
}
public void setBeizhu(String beizhu) {
this.beizhu = beizhu;
}
public String getName() {
return name;
}
public Course() {}
public Course( String num, String mima, String sex, String name, String studentnum, String youxiang, String xueyuan, String xi, String banji, String year, String plase, String beizhu) {
this.num = num;
this.mima = mima;
this.sex = sex;
this.name = name;
this.studentnum = studentnum;
this.youxiang = youxiang;
this.xueyuan = xueyuan;
this.xi = xi;
this.banji = banji;
this.year = year;
this.plase = plase;
this.beizhu = beizhu;
}
}
CourseServlet.java
知识兔package servlet;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;import entity.Course;import dao.CourseDao;public class CourseServlet extends HttpServlet { private static final long serialVersionUID = 1L; public CourseServlet() { super(); } CourseDao dao = new CourseDao(); 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 num = req.getParameter("num"); String mima = req.getParameter("mima"); String name = req.getParameter("name"); String sex = req.getParameter("sex"); String studentnum = req.getParameter("studentnum"); String xueyuan = req.getParameter("xueyuan"); String xi = req.getParameter("xi"); String banji = req.getParameter("banji"); String year = req.getParameter("year"); String plase = req.getParameter("plase"); String beizhu = req.getParameter("beizhu"); String youxiang = req.getParameter("youxiang"); Course course = new Course(num,mima,sex,name,studentnum,youxiang,xueyuan,xi,banji,year,plase,beizhu); //添加后消息显示 if(dao.add(course)){ req.setAttribute("message", "注册成功"); req.getRequestDispatcher("index.jsp").forward(req,resp);} else { req.setAttribute("message", "注册失败"); req.getRequestDispatcher("zhuce.jsp").forward(req,resp);} } }
CourseDao.java
package dao;import java.sql.Connection;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.ArrayList;import java.util.List;import entity.Course;import util.DBUtil;public class CourseDao { public boolean add(Course course) { String sql = "insert into information( num , mima , sex, name , studentnum, youxiang,xueyuan,xi,banji,year,plase,beizhu) values('" + course.getNum() + "','" + course.getMima() + "','" + course.getSex() + "','" + course.getName()+"','" + course.getStudentnum()+"','" + course.getYouxiang()+"','" + course.getXueyuan()+"','" + course.getXi()+"','" + course.getBanji()+"','" + course.getYear()+"','" + course.getPlase()+"','" + course.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; }}