StuBean:
package com.hbc.bean;
public class StuBean {
public StuBean() {
// TODO Auto-generated constructor stub
}
private int stuId;
private String stuName;
private String stuSex;
private String stuPhone;
public int getStuId() {
return stuId;
}
public void setStuId(int stuId) {
this.stuId = stuId;
}
public String getStuName() {
return stuName;
}
public void setStuName(String stuName) {
this.stuName = stuName;
}
public String getStuSex() {
return stuSex;
}
public void setStuSex(String stuSex) {
this.stuSex = stuSex;
}
public String getStuPhone() {
return stuPhone;
}
public void setStuPhone(String stuPhone) {
this.stuPhone = stuPhone;
}
}
StuDAO:
package com.hbc.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import com.hbc.bean.DBUtil;
import com.hbc.bean.StuBean;
public class StuDAO {
public StuDAO() {
// TODO Auto-generated constructor stub
}
public List queryAll() {
List list = new ArrayList();
Connection conn = DBUtil.getConnection();
Statement stat = DBUtil.getStatement(conn);
ResultSet rs = null;
try {
rs = stat.executeQuery("select * from tb_stu");
StuBean stu = null;
while(rs.next()) {
stu = new StuBean();
stu.setStuId(rs.getInt(1));
stu.setStuName(rs.getString(2));
stu.setStuSex(rs.getString(3));
stu.setStuPhone(rs.getString(4));
list.add(stu);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
DBUtil.closeAll(conn, stat, rs);
}
return list;
}
public void deleteById(int stuId) {
List list = new ArrayList();
Connection conn = DBUtil.getConnection();
Statement stat = DBUtil.getStatement(conn);
try {
int rn = stat.executeUpdate("delete from tb_stu where stuId="+stuId);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
DBUtil.close(conn, stat);
}
}
public void addStu(StuBean stu) {
Connection conn = DBUtil.getConnection();
PreparedStatement stat = null;
String sql = "insert into tb_stu(stuId,stuName,stuSex,stuPhone) values(?,?,?,?)";
try {
stat = conn.prepareStatement(sql);
stat.setInt(1, stu.getStuId());
stat.setString(2, stu.getStuName());
stat.setString(3, stu.getStuSex());
stat.setString(4, stu.getStuPhone());
int rtn = stat.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
DBUtil.close(conn, stat);
}
}
public StuBean selectById(int stuId) {
StuBean stu = new StuBean();
Connection conn = DBUtil.getConnection();
Statement stat = DBUtil.getStatement(conn);
ResultSet rs = null;
try {
rs = stat.executeQuery("select * from tb_stu where stuId="+stuId);
while(rs.next()) {
stu.setStuId(rs.getInt(1));
stu.setStuName(rs.getString(2));
stu.setStuSex(rs.getString(3));
stu.setStuPhone(rs.getString(4));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
DBUtil.closeAll(conn, stat,rs);
}
return stu;
}
public void updateStu(StuBean stu) {
Connection conn = DBUtil.getConnection();
PreparedStatement stat = null;
String sql = "update tb_stu set stuName=?,stuSex=?,stuPhone=? where stuId=?";
try {
stat = conn.prepareStatement(sql);
stat.setString(1, stu.getStuName());
stat.setString(2, stu.getStuSex());
stat.setString(3, stu.getStuPhone());
stat.setInt(4, stu.getStuId());
int rtn = stat.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
DBUtil.close(conn, stat);
}
}
}
ADDServlet:
package com.hbc.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 com.hbc.dao.StuDAO;
import com.hbc.bean.StuBean;
/**
* Servlet implementation class ADDServlet
*/
@WebServlet("/ADDServlet")
public class ADDServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public ADDServlet() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
doPost(request, response);
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
StuBean Stu = new StuBean();
Stu.setStuId(Integer.parseInt(request.getParameter("stuId")));
Stu.setStuName(request.getParameter("stuName"));
Stu.setStuSex(request.getParameter("stuSex"));
Stu.setStuPhone(request.getParameter("stuPhone"));
StuDAO dao = new StuDAO();
dao.addStu(Stu);
List list = dao.queryAll();
request.setAttribute("stuList", list);
request.getRequestDispatcher("show_jstl.jsp").forward(request, response);
}
}
DeleteServlet:
package com.hbc.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 com.hbc.dao.StuDAO;
/**
* Servlet implementation class DeleteServlet
*/
@WebServlet("/DeleteServlet")
public class DeleteServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public DeleteServlet() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
doPost(request, response);
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
String id = request.getParameter("stuId");
StuDAO dao = new StuDAO();
dao.deleteById(Integer.parseInt(id));
List list = dao.queryAll();
request.setAttribute("stuList", list);
request.getRequestDispatcher("show_jstl.jsp").forward(request, response);
}
}
QueryAllServlet:
package com.hbc.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 com.hbc.dao.StuDAO;
/**
* Servlet implementation class QueryAllServlet
*/
@WebServlet("/QueryAllServlet")
public class QueryAllServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public QueryAllServlet() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
doPost(request,response);
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
//doGet(request, response);
StuDAO dao = new StuDAO();
List list = dao.queryAll();
request.setAttribute("stuList", list);
request.getRequestDispatcher("show_jstl.jsp").forward(request, response);
// request.getRequestDispatcher("show.jsp").forward(request, response);
}
}
ToUpdateServlet:
package com.hbc.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 com.hbc.bean.StuBean;
import com.hbc.dao.StuDAO;
/**
* Servlet implementation class ToUpdateServlet
*/
@WebServlet("/ToUpdateServlet")
public class ToUpdateServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public ToUpdateServlet() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
doPost(request, response);
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
StuBean Stu = new StuBean();
Stu.setStuId(Integer.parseInt(request.getParameter("stuId")));
Stu.setStuName(request.getParameter("stuName"));
Stu.setStuSex(request.getParameter("stuSex"));
Stu.setStuPhone(request.getParameter("stuPhone"));
StuDAO dao = new StuDAO();
dao.updateStu(Stu);
List list = dao.queryAll();
request.setAttribute("stuList", list);
request.getRequestDispatcher("show_jstl.jsp").forward(request, response);
}
}
add.jsp:
<%@ page contentType="text/html;charset=utf-8"%>
<%@ page import="java.util.ArrayList" %>
<%@ page import="com.hbc.bean.StuBean" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE html>
<html>
<body>
<form action="ADDServlet" method="get">
<table>
<tr>
<td>编号</td>
<td><input type="text" name="stuId" value=""/></td>
<td>姓名</td>
<td><input type="text" name="stuName" value=""/></td>
<td>性别</td>
<td><input type="text" name="stuSex" value=""/></td>
<td>电话</td>
<td><input type="text" name="stuPhone" value=""/></td>
<td><button type="submit">add</button></td>
</tr>
</table>
</form>
</body>
</html>
change:
<%@ page contentType="text/html;charset=utf-8"%>
<%@ page import="java.util.ArrayList" %>
<%@ page import="com.hbc.bean.StuBean" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE html>
<html>
<body>
<form action="ToUpdateServlet" method="get">
<table>
<tr>
<td>编号</td>
<td><%String stuid = request.getParameter("stuId");
request.setAttribute("stuid", stuid);
String id = stuid;
%><input type="text" name="stuId" value="<%=id%>"/></td>
<td>姓名</td>
<td><input type="text" name="stuName" value=""/></td>
<td>性别</td>
<td><input type="text" name="stuSex" value=""/></td>
<td>电话</td>
<td><input type="text" name="stuPhone" value=""/></td>
<td><button type="submit">Update</button></td>
</tr>
</table>
</form>
</body>
</html>
show_jstl.jsp:
<%@ page contentType="text/html;charset=utf-8"%>
<%@ page import="java.util.ArrayList" %>
<%@ page import="com.hbc.bean.StuBean" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<% ArrayList stuList=(ArrayList)request.getAttribute("stuList"); %>
<table border="1" width="450" rules="none" cellspacing="0" cellpadding="0">
<tr height="50"><td colspan="6" align="center">学生信息如下</td></tr>
<tr align="center" height="30" bgcolor="lightgrey">
<td>编号</td>
<td>姓名</td>
<td>性别</td>
<td>电话</td>
<td>删除</td>
<td>修改</td>
<td>增加</td>
</tr>
<c:forEach items="${stuList}" var="stu">
<tr height="50" align="center">
<td>${stu.stuId}</td>
<td>${stu.stuName}</td>
<td>${stu.stuSex}</td>
<td>${stu.stuPhone}</td>
<td><a href="DeleteServlet?stuId=${stu.stuId}">删除</a></td>
<td><a href="change.jsp?stuId=${stu.stuId}">修改</a></td>
<td><a href="add.jsp">增加</a></td>
</tr>
</c:forEach>
</table>