简单图书管理系统
一、概览
二、数据库
三、界面代码
add.html
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<!-- 添加的方式大概分为文本框（text)，按钮(radio、value)，下拉框（select、value），多选框（）//如果少下了忘大佬们提醒哈 -->
<!-- 一、"<input type=text//文本框 name="数据库定义的名字" ||text结束，>
<!--二、radio例子如下-->
<!-- <tr>
<td> 住房类型：</td>
<td>
<input type="radio" name="zhufangleixing" value="家庭住宅">家庭住所
<input type="radio" name="zhufangleixing" value="集体住所" checked>集体住所
<input type="radio" name="zhufangleixing" value="工作地住所">工作地住所
<input type="radio" name="zhufangleixing" value="其他住宅">其他住宅
<input type="radio" name="zhufangleixing" value="无住宅">无住宅
</td>
</tr> radio结束 -->
<!-- 三、下拉框
<tr>
<td>受教育程度：</td>
<td>
<select name="jiaoyuchengdu">
<option value="研究生">研究生</option>
<option value="大学本科">大学本科</option>
<option value="大学专科">大学专科</option>
<option value="高中" selected>高中</option>
<option value="初中">初中</option>
<option value="小学">小学</option>
<option value="未上过学">未上过学</option>
</select>
</td>
</tr> -->
<!-- 四、多选框
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="demo04.jsp" >
用户名：<input type="text" name="uname"><br>
兴趣：
<input type="checkbox" name="inst" value="bask">篮球
<input type="checkbox" name="inst" value="swim">游泳
<input type="checkbox" name="inst" value="sing">唱歌
<input type="checkbox" name="inst" value="dancd">跳舞
<input type="checkbox" name="inst" value="read">看书
<br>
<input type="submit" value="提交">
</form>
</body>
</html>
-->
<body>
<div id="addSubjectForm" align="center">
<form action="add1" method="post"><!-- servlet里要调用的函数 -->
<tr>
<h2>请输入图书信息</h2>
</tr>
<table align="center">
<tr>
<td>图书编号：</td>
<td>
<input type="text" name="number" >
</td>
</tr>
<tr>
<td>书名：</td>
<td>
<input type="text" name="bookname" >
</td>
</tr>
<tr>
<td>图书作者：</td>
<td>
<input type="text" name="writer" >
</td>
</tr>
<tr>
<td>借阅可借阅数量：</td>
<td>
<input type="text" name="quantity" >
</td>
</tr>
<td>
<input type="submit" value="提交" />
<input type="reset" value="重置" />
<input type="button" name="Submit" onclick="javascript:history.back(-1);" value="返回上一页">
</td>
</body>
</html>
delite.html
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<div id="addSubjectForm" align="center">
<form action="delite1" method="post"><!-- servlet里要调用的函数 -->
<tr>
<h2>请输入要删除的图书信息</h2>
</tr>
<table align="center">
<tr>
<td>图书编号：</td>
<td>
<input type="text" name="number" >
</td>
</tr>
<td>
<input type="submit" value="提交" />
<input type="reset" value="重置" />
<input type="button" name="Submit" onclick="javascript:history.back(-1);" value="返回上一页">
</td>
</body>
</html>
select.jsp
<%@page import="Util.util"%>
<%@page import="Servlet.select9"%>
<%@page import="java.util.ArrayList"%>
<%@page import="java.util.List"%>
<%@page import="Bean.BookInformation"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>展示数据</title>
</head>
<body>
<table border="1">
<tr>
<th>图书编号</th>
<th>图书名称</th>
<th>作者</th>
<th>可借阅数量</th>
</tr>
<%
//先把数据取出来，通过request对象（内置对象，不需要我们去创建，其实是httpservletRequest对象的实例）
ArrayList <BookInformation> book = (ArrayList<BookInformation> )request.getAttribute("book");
for (int i = 0; i < book.size(); i++) {
BookInformation book1 = book.get(i);//user是个变量
%>
<tr>
<td><%=book1.getNumber()%></td>
<td><%=book1.getBookname()%></td>
<td><%=book1.getWriter()%></td>
<td><%=book1.getQuantity()%></td>
</tr>
<%
}
%>
</table>
</body>
</html>
select2.html
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<!-- "<input type=radio//按钮text//文本框 name="数据库定义的名字" ||text结束，radio例子如下>
<!-- <tr>
<td> 住房类型：</td>
<td>
<input type="radio" name="zhufangleixing" value="家庭住宅">家庭住所
<input type="radio" name="zhufangleixing" value="集体住所" checked>集体住所
<input type="radio" name="zhufangleixing" value="工作地住所">工作地住所
<input type="radio" name="zhufangleixing" value="其他住宅">其他住宅
<input type="radio" name="zhufangleixing" value="无住宅">无住宅
</td>
</tr> -->
<!-- 下拉框
<tr>
<td>受教育程度：</td>
<td>
<select name="jiaoyuchengdu">
<option value="研究生">研究生</option>
<option value="大学本科">大学本科</option>
<option value="大学专科">大学专科</option>
<option value="高中" selected>高中</option>
<option value="初中">初中</option>
<option value="小学">小学</option>
<option value="未上过学">未上过学</option>
</select>
</td>
</tr> -->
<body>
<div id="addSubjectForm" align="center">
<form action="select9" method="post"><!-- servlet里要调用的函数 -->
<tr>
<h2>请输入要查询的图书信息</h2>
</tr>
<table align="center">
<tr>
<td>图书书名：</td>
<td>
<input type="text" name="bookname" >
</td>
</tr>
<td>
<input type="submit" value="提交" />
<input type="reset" value="重置" />
<input type="button" name="Submit" onclick="javascript:history.back(-1);" value="返回上一页">
</td>
</body>
</html>
showall.html
<%@page import="Dao.showall"%>
<%@page import="java.util.ArrayList"%>
<%@page import="Bean.BookInformation"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>展示数据</title>
</head>
<body>
<table border="1">
<tr>
<th>图书编号</th>
<th>书名</th>
<th>图书作者</th>
<th>借阅时间</th>
<div>return Home ? <a href="zhujiemian.html">home</a></div>
</tr>
<%
ArrayList <BookInformation> people = new ArrayList<BookInformation>();
showall dao = new showall();
dao.showall(people);
for (int i = 0; i < people.size(); i++) {
BookInformation A = people.get(i);
%>
<tr>
<td><%=A.getNumber()%></td>
<td><%=A.getBookname()%></td>
<td><%=A.getWriter()%></td>
<td><%=A.getQuantity()%></td>
</tr>
<%
}
%>
</table>
</body>
</html>
update.html
<%@page import="Dao.showall"%>
<%@page import="java.util.ArrayList"%>
<%@page import="Bean.BookInformation"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>展示数据</title>
</head>
<body>
<table border="1">
<tr>
<th>图书编号</th>
<th>书名</th>
<th>图书作者</th>
<th>借阅时间</th>
<div>return Home ? <a href="zhujiemian.html">home</a></div>
</tr>
<%
ArrayList <BookInformation> people = new ArrayList<BookInformation>();
showall dao = new showall();
dao.showall(people);
for (int i = 0; i < people.size(); i++) {
BookInformation A = people.get(i);
%>
<tr>
<td><%=A.getNumber()%></td>
<td><%=A.getBookname()%></td>
<td><%=A.getWriter()%></td>
<td><%=A.getQuantity()%></td>
</tr>
<%
}
%>
</table>
</body>
</html>
zhujiemian.html
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<h1 align = "center">欢迎使用图书管理系统</h1><br>
</head>
<body>
<div align = "center"> <!-- 居中 --><a href="add.html" > <!-- 链接 --> 登记图书信息</button ></a></div><br>
<div align = "center"> <a href="update.html" >修改图书信息</button></a></div><br>
<div align = "center"> <a href="delite.html ">删除图书信息</button></a></div><br>
<div align = "center"> <a href="select2.html">查询图书信息</button></a></div><br>
<div align = "center"> <a href="showall.jsp">浏览图书信息</button></a></div><br>
</body>
</html>
四、后台代码
BookInformation.java
package Bean;
public class BookInformation {
private String number;//编号
private String bookname;//书名
private String writer;//作者
private String quantity;//借阅量
public String getNumber() {
return number;
}
public void setNumber(String number) {
this.number = number;
}
public String getBookname() {
return bookname;
}
public void setBookname(String bookname) {
this.bookname = bookname;
}
public String getWriter() {
return writer;
}
public void setWriter(String writer) {
this.writer = writer;
}
public String getQuantity() {
return quantity;
}
public void setQuantity(String quantity) {
this.quantity = quantity;
}
}
add.java
package Dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import Bean.BookInformation;
import Util.util;
public class add {
//创建连接对象，载体，结果集对象
// private static Connection conn=null;
// private static PreparedStatement ps=null;
// private static ResultSet rs=null;
public void add(BookInformation A) throws ClassNotFoundException, SQLException {
Connection connection = util.getConnection();
String sql = "INSERT INTO tushu (number,bookname,writer,quantity) values(?,?,?,?)";
PreparedStatement preparedStatement = null;//载体
try {
//
preparedStatement = connection.prepareStatement(sql);
// preparedStatement = connection.prepareStatement(sql);
preparedStatement.setString(1, A.getNumber());
preparedStatement.setString(2, A.getBookname());
preparedStatement.setString(3, A.getWriter());
preparedStatement.setString(4, A.getQuantity());
System.out.println(A.getNumber());//测试用
preparedStatement.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
}
}
}
delite.java
package Dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import Bean.BookInformation;
import Util.util;
public class delite {
public void delite(BookInformation A) throws ClassNotFoundException, SQLException {
Connection connection = util.getConnection();
String sql = "delete from tushu where number=?";
PreparedStatement preparedStatement = null;
//
preparedStatement = connection.prepareStatement(sql);
// preparedStatement = connection.prepareStatement(sql);
preparedStatement.setString(1, A.getNumber());//获取编号
System.out.println(A.getNumber());//测试用
preparedStatement.executeUpdate();
}
}
select.java
package Dao;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import Bean.BookInformation;
import Util.util;
import Bean.BookInformation;
import Util.util;
public class select {
//创建连接对象，载体，结果集对象
// private static Connection conn=null;
// private static PreparedStatement ps=null;
// private static ResultSet rs=null;
public void select11(ArrayList<BookInformation> book,String name) throws ClassNotFoundException, SQLException{
String sql1 ="select * from tushu where bookname = ?";
Connection connection = util.getConnection();
try {
PreparedStatement ps = connection.prepareStatement(sql1);
ps.setString(1, name);
ResultSet rs = ps.executeQuery();
while(rs.next()) {
BookInformation A = new BookInformation();
A.setNumber(rs.getString(1));
A.setBookname(rs.getString(2));
A.setWriter(rs.getString(3));
A.setQuantity(rs.getString(4));
book.add(A);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
showall.java
package Dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import Bean.BookInformation;
import Util.util;
public class showall {
public void showall(ArrayList<BookInformation> people) throws ClassNotFoundException, SQLException{
String sql1 ="select * from tushu";
//������䴫�����
Connection connection = util.getConnection();
try {
PreparedStatement ps = connection.prepareStatement(sql1);
ResultSet rs = ps.executeQuery();
while(rs.next()) {
BookInformation A = new BookInformation();
A.setNumber(rs.getString(1));
A.setBookname(rs.getString(2));
A.setWriter(rs.getString(3));
A.setQuantity(rs.getString(4));
people.add(A);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
updata.java
package Dao;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import Bean.BookInformation;
import Util.util;
public class updata {
//创建连接对象，载体，结果集对象
// private static Connection conn=null;
// private static PreparedStatement ps=null;
// private static ResultSet rs=null;
public void updata(BookInformation A) throws ClassNotFoundException, SQLException {
Connection connection = util.getConnection();
String sql = " update tushu set number = ?,bookname = ?,writer = ?,quantity = ?";
PreparedStatement preparedStatement = null;//载体
try {
preparedStatement = connection.prepareStatement(sql);
// preparedStatement = connection.prepareStatement(sql);
preparedStatement.setString(1, A.getNumber());
preparedStatement.setString(2, A.getBookname());
preparedStatement.setString(3, A.getWriter());
preparedStatement.setString(4, A.getQuantity());
System.out.println(A.getNumber());//测试用
preparedStatement.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
}
}
}
add1.java
package Servlet;
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;
import Bean.BookInformation;
import Dao.add;
/**
* Servlet implementation class add
*/
@WebServlet("/add1")
public class add1 extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public add1() {
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
// TODO Auto-generated method stub
request.setCharacterEncoding("utf-8");
//������Ӧ���ı�����
response.setContentType("text/html;charset=utf-8");//设置字符集
String number = request.getParameter("number");
String bookname = request.getParameter("bookname");
String writer = request.getParameter("writer");
String quantity = request.getParameter("quantity");
// System.out.println(number);
BookInformation B = new BookInformation();
B.setNumber(number);
B.setBookname(bookname);
B.setWriter(writer);
B.setQuantity(quantity);
// response.sendRedirect("showall.jsp");\
add A=new add();
try {
A.add(B);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}}
delite1.java
package Servlet;
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;
import Bean.BookInformation;
import Dao.delite;
/**
* Servlet implementation class delite1
*/
@WebServlet("/delite1")
public class delite1 extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public delite1() {
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
// TODO Auto-generated method stub
request.setCharacterEncoding("utf-8");
//������Ӧ���ı�����
response.setContentType("text/html;charset=utf-8");//设置字符集
String number = request.getParameter("number");
BookInformation B = new BookInformation();
B.setNumber(number);
// response.sendRedirect("showall.jsp");\
delite A=new delite();
try {
A.delite(B);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}}
select9.java
package Servlet;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
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 Bean.BookInformation;
import Dao.select;
import Bean.BookInformation;
import Dao.select;
import Util.util;
/**
* Servlet implementation class add
*/
@WebServlet("/select9")
public class select9 extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public select9() {
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
// TODO Auto-generated method stub
request.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=utf-8");
String bookname = request.getParameter("bookname");;
ArrayList <BookInformation> book = new ArrayList<BookInformation>();
//���ݿ����
System.out.println(bookname);
select dao=new select();
if(bookname!=null)
{
try {
dao.select11(book,bookname);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
request.setAttribute("book",book);//setAttribute() 方法添加指定的属性，并为其赋指定的值。
request.getRequestDispatcher("select.jsp").forward(request, response);
}
else {
response.getWriter().write("输入数据不存在请重新输入。");
}
// else if(number!=null) {
// try {
// dao.select1(book,number);
// } catch (ClassNotFoundException e) {
// // TODO Auto-generated catch block
// e.printStackTrace();
// } catch (SQLException e) {
// // TODO Auto-generated catch block
// e.printStackTrace();
// }
// request.setAttribute("people",people);
// request.getRequestDispatcher("chakan.jsp").forward(request, response);
// }
// else if(minzu!=null) {
// try {
// dao.select4(people,minzu);
// } catch (ClassNotFoundException e) {
// // TODO Auto-generated catch block
// e.printStackTrace();
// } catch (SQLException e) {
// // TODO Auto-generated catch block
// e.printStackTrace();
// }
// request.setAttribute("people",people);
// request.getRequestDispatcher("chakan.jsp").forward(request, response);
// }
// else {
// try {
// dao.select5(people,jiaoyuchengdu);
// } catch (ClassNotFoundException e) {
// // TODO Auto-generated catch block
// e.printStackTrace();
// } catch (SQLException e) {
// // TODO Auto-generated catch block
// e.printStackTrace();
// }
// request.setAttribute("people",people);
// request.getRequestDispatcher("chakan.jsp").forward(request, response);
// }
}}
uapata1.java
package Servlet;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
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;
import Bean.BookInformation;
import Dao.updata;
import Util.util;
/**
* Servlet implementation class add
*/
@WebServlet("/uapata1")
public class uapata1 extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public uapata1() {
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
// TODO Auto-generated method stub
request.setCharacterEncoding("utf-8");
//������Ӧ���ı�����
response.setContentType("text/html;charset=utf-8");//设置字符集
String number = request.getParameter("number");
String bookname = request.getParameter("bookname");
String writer = request.getParameter("writer");
String quantity = request.getParameter("quantity");
// System.out.println(number);
//
String Bookname[]=new String [100];
String Number[]=new String[100];
int i=0,j=0,count=0;
try{Connection connection = util.getConnection();
PreparedStatement preparedStatement = connection.prepareStatement("select * from tushu");//载体
ResultSet set=preparedStatement.executeQuery("select * from tushu");
while(set.next())
{
Bookname[i]=set.getString("bookname");
Number[i]=set.getString("number");
i++;
count++;
}
for(int k=0;k<count;k++)
{
if(bookname.equals(Bookname[k])
{
BookInformation B = new BookInformation();
B.setNumber(number);
B.setBookname(bookname);
B.setWriter(writer);
B.setQuantity(quantity);
// response.sendRedirect("showall.jsp");\
updata A=new updata();
try {
A.updata(B);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
break;
}
else{
response.sendRedirect("print.html");
}
}}
catch(SQLException e)
{
e.printStackTrace();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}}
util.java
package Util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
/**
* JDBC��������
*/
public class util{
public static Connection getConnection() throws ClassNotFoundException, SQLException {//创建了一个方法后面会调用
Connection connection = null;//创建连接对象
PreparedStatement ps = null;////创建载体
ResultSet rs = null;//创建结果集对象
Class.forName("com.mysql.cj.jdbc.Driver");
connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/tushu","root", "222238");//数据库的名称和自己的账号密码记得改！！！
return connection;
}
public static void close(Connection connection ) {
try {
if (connection != null) {
connection.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void close(PreparedStatement preparedStatement ) {
try {
if (preparedStatement != null) {
preparedStatement.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void close(ResultSet resultSet ) {
try {
if (resultSet != null) {
resultSet.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
浙公网安备 33010602011771号