简单用Servlet和tomcat实现数据库的增删改查
实现效果图：
详细步骤：
1.创建数据库（或者直接导入）：
数据库名：bbs
表名：students
2.创建web项目
注意：该jar包可不用添加，直接复制到该目录下即可
3.创建类
Student类
package zzz.com;
public class Student {
int sid;
String sname;
String spwd;
public int getSid() {
return sid;
}
public void setSid(int sid) {
this.sid = sid;
}
public String getSname() {
return sname;
}
public void setSname(String sname) {
this.sname = sname;
}
public String getSpwd() {
return spwd;
}
public void setSpwd(String spwd) {
this.spwd = spwd;
}
}
DBManager类
package zzz.com;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.PreparedStatement;
import java.sql.*;
public class DBManager {
private static final String DRIVERNAME = "com.mysql.jdbc.Driver";
private static final String URL = "jdbc:mysql://127.0.0.1:3306/bbs?useUnicode=true&characterEncoding=utf8";
private static final String USERNAME = "root";
private static final String USERPWD = "123456";
public Connection getconn() throws ClassNotFoundException, SQLException {
Class.forName(DRIVERNAME);
Connection conn=DriverManager.getConnection(URL,USERNAME,USERPWD);
System.out.print("DB Success!!");
return conn;
}
public void closeAll(ResultSet rs,PreparedStatement pstmt,Connection conn) throws SQLException {
if(rs!=null) {
rs.close();
}
if(pstmt!=null) {
pstmt.close();
}
if(conn!=null) {
conn.close();
}
}
}
BaseDao类
package zzz.com;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
/**
*
* @author Administrator
*增删改查通用方法
*/
public class BaseDao {
public boolean insert_update_del(String sql,Object val[]) throws ClassNotFoundException, SQLException {
boolean flag=false;
Connection con=new DBManager().getconn();
PreparedStatement pstmt=con.prepareStatement(sql);
if(val!=null) {
for(int i=0;i<val.length;i++) {
pstmt.setObject(i+1, val[i]);
}
}
if(pstmt.executeUpdate()>0) {
flag=true;
}
return flag;
}
public ResultSet query(String sql,Object val[]) throws ClassNotFoundException, SQLException {
boolean flag=false;
Connection con=new DBManager().getconn();
PreparedStatement pstmt=con.prepareStatement(sql);
if(val!=null) {
for(int i=0;i<val.length;i++) {
pstmt.setObject(i+1, val[i]);
}
}
ResultSet rs=pstmt.executeQuery();
return rs;
}
}
StudentsDao类
package zzz.com;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
public class StudentsDao extends BaseDao{
public boolean regeditStudent(Student stu) throws ClassNotFoundException, SQLException {
String sql="insert into students values (null,?,?)";
Object[] val= {stu.getSname(),stu.getSpwd()};
return insert_update_del(sql,val);
}
public List<Student> quaryAll() throws ClassNotFoundException, SQLException{
List<Student> list=new ArrayList<Student>();
String sql="select * from students";
Object[] val= {};
ResultSet rs=query(sql,val);
while(rs.next()) {
Student stu=new Student();
stu.setSid(rs.getInt("sid"));
stu.setSname(rs.getString("sname"));
stu.setSpwd(rs.getString("spwd"));
list.add(stu);
}
return list;
}
public Student queryById(int sid) throws ClassNotFoundException, SQLException {
Student stu=new Student();
String sql="select * from students where sid=?";
Object[] val= {sid};
ResultSet rs=query(sql,val);
while(rs.next()) {
stu.setSid(rs.getInt("sid"));
stu.setSname(rs.getString("sname"));
stu.setSpwd(rs.getString("spwd"));
}
return stu;
}
public boolean updateStudent(Student stu) throws ClassNotFoundException, SQLException {
String sql="update students set sname=?,spwd=? where sid=?";
Object[] val= {stu.getSname(),stu.getSpwd(),stu.getSid()};
if(insert_update_del(sql,val)) {
return true;
}
else {
return false;
}
}
public boolean deleteStudent(int uid) throws ClassNotFoundException, SQLException {
String sql="delete from students where sid=?;";
Object[] val= {uid};
return insert_update_del(sql,val);
}
}
EditServlet类
package zzz.com;
import java.io.IOException;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
* Servlet implementation class EditServlet
*/
@WebServlet("/EditServlet")
public class EditServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public EditServlet() {
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);
// response.getWriter().append("Served at: ").append(request.getContextPath());
}
/**
* @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);
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
try {
int sid=Integer.parseInt(request.getParameter("uid"));
String sname=request.getParameter("uname");
System.out.println(sname);
String spwd=request.getParameter("upwd");
System.out.println(spwd);
Student stu=new Student();
stu.setSid(sid);
stu.setSname(sname);
stu.setSpwd(spwd);
if(new StudentsDao().updateStudent(stu)) {
response.sendRedirect("queryallservlet");
}else {
response.sendRedirect("error.jsp");
}
} catch (ClassNotFoundException | SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
RegeditServlet类
package zzz.com;
import java.io.IOException;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
* Servlet implementation class RegeditServlet
*/
@WebServlet("/RegeditServlet")
public class RegeditServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public RegeditServlet() {
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);
System.out.println("Welcome……");
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
String sname=request.getParameter("uname");
String spwd=request.getParameter("upwd");
Student stu=new Student();
stu.setSname(sname);
stu.setSpwd(spwd);
try {
if(new StudentsDao().regeditStudent(stu)) {
// response.sendRedirect("success.jsp");
response.sendRedirect("queryAllServlet");
}else {
response.sendRedirect("error.jsp");
}
} catch (ClassNotFoundException | SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
QueryAllServlet类
package zzz.com;
import java.io.IOException;
import java.sql.SQLException;
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;
/**
* 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
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
try {
List<Student> list=new StudentsDao().quaryAll();
request.setAttribute("list", list);
request.getRequestDispatcher("show.jsp").forward(request, response);
} catch (ClassNotFoundException | SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
UpdateServlet类
package zzz.com;
import java.io.IOException;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
* Servlet implementation class UpdateServlet
*/
@WebServlet("/updateServlet")
public class UpdateServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public UpdateServlet() {
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
// response.getWriter().append("Served at: ").append(request.getContextPath());
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
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
int sid=Integer.parseInt(request.getParameter("sid"));
System.out.println(sid);
Student stu=new Student();
try {
stu=new StudentsDao().queryById(sid);
request.setAttribute("stu", stu);
request.getRequestDispatcher("update.jsp").forward(request, response);
// System.out.println(stu.sid);
} catch (ClassNotFoundException | SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
DeleteServlet类
package zzz.com;
import java.io.IOException;
import java.sql.SQLException;
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 zzz.com.*;
/**
* 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
// response.getWriter().append("Served at: ").append(request.getContextPath());
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
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
int sid = Integer.parseInt(request.getParameter("sid"));
Student stu=new Student();
stu.setSid(sid);
try {
if(new StudentsDao().deleteStudent(sid)) {
response.sendRedirect("queryAllServlet");
}else {
response.sendRedirect("error.jsp");
}
} catch (ClassNotFoundException | SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
4.在WebContent目录下编写jsp页面
regedit.jsp
<%@ page language="java" contentType="text/html; charset=utf-8"
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<body>
<h1>用户注册业面</h1>
<form action="regeditservlet" method="post">
<p>账号:<input type="text" name="uname"/></p>
<p>密码:<input type="password" name="upwd"/></p>
<input type="submit" value="注册"/>
</form>
</body>
</html>
show.jsp
<%@ page language="java" contentType="text/html; charset=utf-8"
%>
<%@ page import="java.util.*" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<body>
<h1>用户信息详情</h1>
<table>
<tr>
<td>序号</td>
<td>姓名</td>
<td>密码</td>
<td>操作</td>
<tr>
<c:forEach var="stu" items="${list}" step="1">
<tr>
<td>${stu.sid}</td>
<td>${stu.sname}</td>
<td>${stu.spwd}</td>
<td><a href="updateservlet?sid=${stu.sid}">修改</a>|<a href="DeleteServlet?sid=${stu.sid}">删除</a></td>
<tr>
</c:forEach>
</table>
</body>
</html>
update.jsp
<%@ page language="java" contentType="text/html; charset=utf-8"
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<body>
<h1>用户update</h1>
<form action="editservlet" method="post">
<p>编号:<input type="text" name="uid" readonly="readonly" value="${stu.sid}"/></p>
<p>账号:<input type="text" name="uname" value="${stu.sname}"/></p>
<p>密码:<input type="password" name="upwd" value="${stu.spwd}"/></p>
<input type="submit" value="修改"/>
</form>
</body>
</html>
error.jsp
<%@ page language="java" contentType="text/html; charset=utf-8"
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<body>
<h1>注册失败！</h1>
</body>
</html>
success.jsp
<%@ page language="java" contentType="text/html; charset=utf-8"
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<body>
<h1>注册成功！</h1>
</body>
</html>
5.配置WEB-INF目录下的web.xml(servlet部分)
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0">
<display-name>TestPro</display-name>
<welcome-file-list>
<welcome-file>index.html</welcome-file>
<welcome-file>index.htm</welcome-file>
<welcome-file>index.jsp</welcome-file>
<welcome-file>default.html</welcome-file>
<welcome-file>default.htm</welcome-file>
<welcome-file>default.jsp</welcome-file>
</welcome-file-list>
<servlet>
<servlet-name>regeditservlet</servlet-name>
<servlet-class>zzz.com.RegeditServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>regeditservlet</servlet-name>
<url-pattern>/regeditservlet</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>queryallservlet</servlet-name>
<servlet-class>zzz.com.QueryAllServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>queryallservlet</servlet-name>
<url-pattern>/queryallservlet</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>updateservlet</servlet-name>
<servlet-class>zzz.com.UpdateServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>updateservlet</servlet-name>
<url-pattern>/updateservlet</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>editservlet</servlet-name>
<servlet-class>zzz.com.EditServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>editservlet</servlet-name>
<url-pattern>/editservlet</url-pattern>
</servlet-mapping>
</web-app>
2054
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
