Servlet总结
本程序采用Servlet开发技术，MVC分层，所有程序在设计时都要接口为操作的标准，主要逻辑操作只有增删改查。
具体实现操作请看源代码。
本程序采用的是MYSQL数据库，需加入相应的jar包
目录结构
首先贴上底层数据层：
连接数据库
package com.student.dbc ; import java.sql.* ; public class DatabaseConnection { private static final String DBDRIVER = "org.gjt.mm.mysql.Driver" ; private static final String DBURL = "jdbc:mysql://localhost:3306/java_web?useUnicode=true&characterEncoding=UTF-8" ; private static final String DBUSER = "root" ; private static final String DBPASSWORD = "root" ; private Connection conn = null ; public DatabaseConnection() throws Exception{ try{ Class.forName(DBDRIVER) ; this.conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD) ; }catch(Exception e){ throw e ; } } public Connection getConnection(){ return this.conn ; } public void close() throws Exception{ if(this.conn != null){ try{ this.conn.close() ; }catch(Exception e){ throw e ; } } } }
实体类
package com.student.vo; public class Student { private String id; private String name; private int age; private int sex; private String major; private String college; private String introduction; public String getId() { return id; } public void setId(String id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public int getAge() { return age; } public void setAge(int age) { this.age = age; } public int getSex() { return sex; } public void setSex(int sex) { this.sex = sex; } public String getMajor() { return major; } public void setMajor(String major) { this.major = major; } public String getCollege() { return college; } public void setCollege(String college) { this.college = college; } public String getIntroduction() { return introduction; } public void setIntroduction(String introduction) { this.introduction = introduction; } }
业务逻辑类
package com.student.action; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.ArrayList; import com.mysql.jdbc.Connection; import com.student.dbc.DatabaseConnection; import com.student.vo.Student; public class StudentAction { private static Connection conn = null ; /** * 增加学生 * @param id * @param name * @param age * @param sex * @param major * @param college * @param introduction * @return */ public static boolean addStudent(String id,String name,int age,int sex,String major,String college,String introduction) { try { java.sql.Connection conn=new DatabaseConnection().getConnection(); PreparedStatement st=conn.prepareStatement("insert into student values(?,?,?,?,?,?,?)"); st.setString(1, id); st.setString(2, name); st.setInt(3, age); st.setInt(4, sex); st.setString(5, major); st.setString(6, college); st.setString(7, introduction); st.execute(); conn.close(); return true; } catch (Exception e) { // TODO: handle exception return false; } } /** * 更新学生 * @param id * @param name * @param age * @param sex * @param major * @param college * @param introduction * @return */ public static boolean updateStudent(String id,String name,int age,int sex,String major,String college,String introduction) { try { java.sql.Connection conn=new DatabaseConnection().getConnection(); PreparedStatement st=conn.prepareStatement("update student set name=?,age=?,sex=?,major=?,college=?,introduction=? where id=?"); st.setString(1, name); st.setInt(2, age); st.setInt(3, sex); st.setString(4, major); st.setString(5, college); st.setString(6, introduction); st.setString(7, id); st.execute(); conn.close(); return true; } catch (Exception e) { // TODO: handle exception return false; } } /** * 删除 * @param id * @return */ public static boolean deleteStudent(String id) { try { java.sql.Connection conn=new DatabaseConnection().getConnection(); PreparedStatement st=conn.prepareStatement("delete from student where id=?"); st.setString(1, id); st.execute(); conn.close(); return true; }catch (Exception e) { // TODO: handle exception return false; } } /** * 获取全部学生 * @return */ public static ArrayList getAllstudent() { ArrayList students=new ArrayList(); try { java.sql.Connection conn=new DatabaseConnection().getConnection(); PreparedStatement st=conn.prepareStatement("select * from student"); st.execute(); ResultSet rs=st.getResultSet(); while(rs.next()){ Student student=new Student(); student.setId(rs.getString("id")); student.setName(rs.getString("name")); student.setAge(rs.getInt("age")); student.setSex(rs.getInt("sex")); student.setMajor(rs.getString("major")); student.setCollege(rs.getString("college")); student.setIntroduction(rs.getString("introduction")); students.add(student); } conn.close(); } catch (Exception e) { // TODO: handle exception } return students; } /** * 按学号查询学生 * @param id * @return */ public static Student getStudent(String id) { Student student=null; try { java.sql.Connection conn=new DatabaseConnection().getConnection(); PreparedStatement st=conn.prepareStatement("select * from student where id=?"); st.setString(1, id); st.execute(); ResultSet rs=st.getResultSet(); while(rs.next()){ student=new Student(); student.setId(rs.getString("id")); student.setName(rs.getString("name")); student.setAge(rs.getInt("age")); student.setSex(rs.getInt("sex")); student.setMajor(rs.getString("major")); student.setCollege(rs.getString("college")); student.setIntroduction(rs.getString("introduction")); } conn.close(); } catch (Exception e) { // TODO: handle exception } return student; } }
JSP与数据交换层
package com.student.servlet; import java.io.IOException; import javax.servlet.RequestDispatcher; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.student.action.StudentAction; public class StudentServlet extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request, response); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); if(request.getRequestURI().endsWith("/viewStudent")){ RequestDispatcher dispatcher = request.getRequestDispatcher("viewstudent.jsp"); dispatcher .forward(request, response); }else if(request.getRequestURI().endsWith("/addStudent")){ doAddStudent(request,response); } else if (request.getRequestURI().endsWith("/updateStudent")) { doUpdateStudent(request,response); }else if (request.getRequestURI().endsWith("/deleteStudent")) { doDeleteStudent(request,response); } } private void doAddStudent(HttpServletRequest request, HttpServletResponse response) throws IOException{ String id=request.getParameter("id"); String name=request.getParameter("name"); String age=request.getParameter("age"); String sex=request.getParameter("sex"); String major=request.getParameter("major"); String college=request.getParameter("college"); String introduction=request.getParameter("introduction"); StudentAction.addStudent(id, name,new Integer(age), new Integer(sex), major, college, introduction); response.sendRedirect("index.jsp"); } private void doUpdateStudent(HttpServletRequest request, HttpServletResponse response) throws IOException { String id=request.getParameter("id"); String name=request.getParameter("name"); String age=request.getParameter("age"); String sex=request.getParameter("sex"); String major=request.getParameter("major"); String college=request.getParameter("college"); String introduction=request.getParameter("introduction"); StudentAction.updateStudent(id, name, new Integer(age), new Integer(sex), major, college, introduction); response.sendRedirect("index.jsp"); } private void doDeleteStudent(HttpServletRequest request, HttpServletResponse response) throws IOException { String id=request.getParameter("id"); StudentAction.deleteStudent(id); response.sendRedirect("index.jsp"); } }
数据库表，可直接复制
STUDENT.SQLJSP页面
<%@page import="com.student.vo.Student"%> <%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <%@ page import="com.student.action.StudentAction"%> <% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <base href="<%=basePath%>"> <title>学生管理系统</title> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="This is my page"> <!-- <link rel="stylesheet" type="text/css" href="styles.css"> --> <link id="bs-css" href="css/bootstrap-cerulean.min.css" rel="stylesheet"> <link href="css/charisma-app.css" rel="stylesheet"> </head> <body> <div class="box col-md-12" > <div class="box-inner"> <div class="box-header well" data-original-title=""> <h2><i class="glyphicon glyphicon-user"></i> 学生管理系统</h2> <div class="box-icon"> <a href="addstudent.jsp" class="btn btn-minimize btn-round btn-default"><i class="glyphicon glyphicon-chevron-up"></i>添加学生</a> </div> </div> <div class="box-content"> <table class="table table-striped table-bordered responsive" width="80%"> <thead> <tr> <th class="center"> 学号</th> <th class="center"> 姓名</th> <th> 年龄</th> <th> 性别</th> <th> 专业</th> <th> 学院</th> <th> 简介</th> <th> 操作</th> </tr> </thead> <tbody> <tr> <% ArrayList students=StudentAction.getAllstudent(); for(int i=0;i<students.size();i++){ Student student=(Student)students.get(i);%> <td class="center"> <%=student.getId() %></td> <td class="center"> <%=student.getName() %></td> <td class="center"> <%=student.getAge()%></td> <% if(student.getSex()==1){%> <td class="center"> 男</td><%}else{ %> <td class="center"> 女</td> <%} %> <td class="center"> <%=student.getMajor()%></td> <td class="center"> <%=student.getCollege()%></td> <td class="center"> <%=student.getIntroduction()%>...</td> <td > <a class="btn btn-success"href="viewStudent?id=<%=student.getId()%>"> <i class="glyphicon glyphicon-zoom-in icon-white"></i> 查看 </a> <a class="btn btn-info" href="updatestudent.jsp?id=<%=student.getId()%>"> <i class="glyphicon glyphicon-edit icon-white"></i> 修改 </a> <a class="btn btn-danger" href="deleteStudent?id=<%=student.getId()%>"> <i class="glyphicon glyphicon-trash icon-white"></i> 删除 </a> </td> </tr> </tbody> <% } %> </table> </div> </div> </div> </body> </html>
<%@page import="com.student.vo.Student"%> <%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <%@ page import="com.student.action.StudentAction"%> <% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <base href="<%=basePath%>"> <title>添加学生信息</title> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="This is my page"> <!-- <link rel="stylesheet" type="text/css" href="styles.css"> --> <link id="bs-css" href="css/bootstrap-cerulean.min.css" rel="stylesheet"> <link href="css/charisma-app.css" rel="stylesheet"> </head> <body> <div class="box col-md-3"> <div class="box-inner"> <div class="box-header well" data-original-title=""> <h2><i class="glyphicon glyphicon-edit"></i>学生信息</h2> </div> <div class="box-content"> <form action="addStudent" method="post" role="form"> <div class="form-group"> <input type="text" class="form-control" name="id" placeholder="学号"> <input type="text" class="form-control" name="name" placeholder="姓名"> <input type="text" class="form-control" name="age" placeholder="年龄"> <select class="form-control" name="sex"><option value="1" >--------性别--------</option><option value="1">男</option><option value="0">女</option></select> <input type="text" class="form-control" name="major" placeholder="专业"> <input type="text" class="form-control" name="college" placeholder="学院"> <label for="exampleInputEmail1">简介</label> <textarea type="text" class="form-control" rows="5" name="introduction" style=" resize: none;" ></textarea> </div> <button type="submit" class="btn btn-default">提交</button> </form> </div> </div> </div> </body> </html>
<%@page import="com.student.vo.Student"%> <%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <%@ page import="com.student.action.StudentAction"%> <% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <base href="<%=basePath%>"> <title>添加学生信息</title> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="This is my page"> <!-- <link rel="stylesheet" type="text/css" href="styles.css"> --> <link id="bs-css" href="css/bootstrap-cerulean.min.css" rel="stylesheet"> <link href="css/charisma-app.css" rel="stylesheet"> </head> <% String id=request.getParameter("id"); Student student=StudentAction.getStudent(id); %> <body> <div class="box col-md-3"> <div class="box-inner"> <div class="box-header well" data-original-title="学生信息"> <h2><i class="glyphicon glyphicon-edit"></i>修改学生信息</h2> </div> <div class="box-content"> <form action="updateStudent" method="post" role="form"> <div class="form-group"> <label>学号</label> <input type="text" class="form-control" name="id" value="<%=student.getId() %>"> <label>姓名</label> <input type="text" class="form-control" name="name" value="<%=student.getName() %>"> <label>年龄</label> <input type="text" class="form-control" name="age" value="<%=student.getAge() %>"> <label>性别</label><% if(student.getSex()==1){%> 男<%}else{ %> 女 <%} %> <select class="form-control" name="sex"><option value="1">--------性别--------</option><option value="1">男</option><option value="0">女</option></select> <label>专业</label> <input type="text" class="form-control" name="major" value="<%=student.getMajor()%>"> <label>学院</label> <input type="text" class="form-control" name="college" value="<%=student.getCollege()%>"> <label for="exampleInputEmail1">简介</label> <textarea class="form-control" rows="5" name="introduction" placeholder=" <%=student.getIntroduction()%>" style=" resize: none;" ><%=student.getIntroduction()%></textarea> </div> <button type="submit" class="btn btn-default">更新信息</button> </form> </div> </div> </div> <form action="updateStudent" method="post"> <table > <tr><td>学号</td><td><input type="text" name="id" value="<%=id %>" readonly="true" ></td></tr> <tr><td>姓名</td><td><input type="text" name="name" value="<%=student.getName() %>"></td></tr> <tr><td>年龄</td><td><input type="text" name="age" value="<%=student.getAge()%>"></td></tr> <tr><td>性别</td><td><select name="sex"><option value="1">男</option><option value="0">女</option></select></td></tr> <tr><td>专业</td><td><input type="text" name="major" value="<%=student.getMajor()%>"></td></tr> <tr><td>学院</td><td><input type="text" name="college" value="<%=student.getCollege()%>"></td></tr> <tr><td>简介</td><td><textarea rows="10" cols="30" name="introduction" ><%=student.getIntroduction() %></textarea></td></tr> <tr><td colspan="2"><input type="submit" value="提交"></td></tr> </table> </form> </body> </html>
<%@page import="com.student.vo.Student"%> <%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <%@ page import="com.student.action.StudentAction"%> <% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <base href="<%=basePath%>"> <title>查看学生信息</title> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="This is my page"> <!-- <link rel="stylesheet" type="text/css" href="styles.css"> --> <link id="bs-css" href="css/bootstrap-cerulean.min.css" rel="stylesheet"> <link href="css/charisma-app.css" rel="stylesheet"> </head> <% String id=request.getParameter("id"); Student student=StudentAction.getStudent(id); %> <body> <div class="box col-md-3"> <div class="box-inner"> <div class="box-header well" data-original-title="学生信息"> <h2><i class="glyphicon glyphicon-edit"></i>学生信息</h2> <a href="index.jsp" ><h5 align="right">返回</h5></a> </div> <div class="box-content"> <form action="#" method="post" role="form"> <div class="form-group"> <label>学号</label> <input type="text" class="form-control" name="id" placeholder="<%=student.getId() %>" readonly="readonly"> <label>姓名</label> <input type="text" class="form-control" name="name" placeholder="<%=student.getName() %>" readonly="readonly"> <label>年龄</label> <input type="text" class="form-control" name="age" placeholder="<%=student.getAge() %>" readonly="readonly"> <label>性别</label><% if(student.getSex()==1){%> <input type="text" class="form-control" placeholder="男" readonly="readonly"><%}else{ %> <input type="text" class="form-control" placeholder="女" readonly="readonly"></td> <%} %> <label>专业</label> <input type="text" class="form-control" name="major" placeholder="<%=student.getMajor()%>" readonly="readonly"> <label>学院</label> <input type="text" class="form-control" name="college" placeholder="<%=student.getCollege()%>" readonly="readonly"> <label for="exampleInputEmail1">简介</label> <textarea type="text" class="form-control" rows="5" name="introduction" placeholder=" <%=student.getIntroduction()%>" style=" resize: none;" readonly="readonly"></textarea> </div> </form> </div> </div> </div> </body> </html>
web.xml配置
<?xml version="1.0" encoding="UTF-8"?> <web-app version="3.0" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"> <servlet> <servlet-name>StudentServlet</servlet-name> <servlet-class>com.student.servlet.StudentServlet</servlet-class> </servlet> <servlet> <servlet-name>addStudent</servlet-name> <servlet-class>com.student.servlet.StudentServlet</servlet-class> </servlet> <servlet> <servlet-name>viewStudent</servlet-name> <servlet-class>com.student.servlet.StudentServlet</servlet-class> </servlet> <servlet> <servlet-name>deleteStudent</servlet-name> <servlet-class>com.student.servlet.StudentServlet</servlet-class> </servlet> <servlet> <servlet-name>updateStudent</servlet-name> <servlet-class>com.student.servlet.StudentServlet</servlet-class> </servlet> <servlet-mapping> <servlet-name>StudentServlet</servlet-name> <url-pattern>/StudentServlet</url-pattern> </servlet-mapping> <servlet-mapping> <servlet-name>updateStudent</servlet-name> <url-pattern>/updateStudent</url-pattern> </servlet-mapping> <servlet-mapping> <servlet-name>deleteStudent</servlet-name> <url-pattern>/deleteStudent</url-pattern> </servlet-mapping> <servlet-mapping> <servlet-name>addStudent</servlet-name> <url-pattern>/addStudent</url-pattern> </servlet-mapping> <servlet-mapping> <servlet-name>viewStudent</servlet-name> <url-pattern>/viewStudent</url-pattern> </servlet-mapping> </web-app>
css样式，可以自己添加，本人就不贴css了。
园友可以思考下分页效果怎么实现？
程序效果图
