首页 > 代码库 > java- 综合实例-增删查改查，删除多项，分页
java- 综合实例-增删查改查，删除多项，分页
重点内容：分页、令牌机制（重定向下防止重复提交）、使用c3p0连接数据库（以及数据库连接类）
项目结构：
类：
项目展示：
数据库：
/* SQLyog Ultimate v12.09 (64 bit) MySQL - 5.5.53 : Database - phone_store ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=‘‘*/; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=‘NO_AUTO_VALUE_ON_ZERO‘ */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; CREATE DATABASE /*!32312 IF NOT EXISTS*/`phone_store` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `phone_store`; /*Table structure for table `phone` */ DROP TABLE IF EXISTS `phone`; CREATE TABLE `phone` ( `id` varchar(255) NOT NULL COMMENT ‘主键‘, `name` varchar(255) NOT NULL COMMENT ‘名称‘, `price` double NOT NULL COMMENT ‘价格‘, `mark` varchar(255) DEFAULT NULL COMMENT ‘简介‘ ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*Data for the table `phone` */ insert into `phone`(`id`,`name`,`price`,`mark`) values (‘9DE38AA976B34441B1511C0266B07F00‘,‘phone555555‘,2323.43,‘1phone1mark顶顶顶顶‘),(‘E0923B7C3CC1434B8E2BF55EB47195BE‘,‘phone555555‘,2323.43,‘2阿达是的发送到发送的‘),(‘13BAEC11CB0D4789BC935B47C396A81D‘,‘张三‘,234.322222222,‘3阿达是的发送到发送的顶顶顶‘),(‘178B12C84D6E4C1583BC71735F3683FC‘,‘phone555555‘,234.32,‘4phone1mark顶顶顶顶‘),(‘5DC9D361571B4B9EAD545B57819B7BE0‘,‘phone555555‘,21341,‘5小米手机‘),(‘9E0B9164FE564A51BC61141017792BF3‘,‘phone555555‘,21341,‘6小米手机‘),(‘A8936D9946B04FBFA543463F35B0A587‘,‘phone555555‘,2323.43,‘7阿达是的发送到发送的‘),(‘C623F1FB4A2E4D7FBBF6109BF1DE0471‘,‘张三‘,2323.43,‘8阿达是的发送到发送的‘),(‘6184E8770C5B471E91EDDBE6B2632DE4‘,‘phone555555‘,2323.43,‘9phone1mark顶顶顶顶‘),(‘9DE38AA976B34441B1511C0266B07F00‘,‘phone555555‘,2323.43,‘1phone1mark顶顶顶顶‘),(‘E0923B7C3CC1434B8E2BF55EB47195BE‘,‘phone555555‘,2323.43,‘2阿达是的发送到发送的‘),(‘13BAEC11CB0D4789BC935B47C396A81D‘,‘张三‘,234.322222222,‘3阿达是的发送到发送的顶顶顶‘),(‘178B12C84D6E4C1583BC71735F3683FC‘,‘phone555555‘,234.32,‘4phone1mark顶顶顶顶‘),(‘5DC9D361571B4B9EAD545B57819B7BE0‘,‘phone555555‘,21341,‘5小米手机‘),(‘9E0B9164FE564A51BC61141017792BF3‘,‘phone555555‘,21341,‘6小米手机‘),(‘A8936D9946B04FBFA543463F35B0A587‘,‘phone555555‘,2323.43,‘7阿达是的发送到发送的‘),(‘C623F1FB4A2E4D7FBBF6109BF1DE0471‘,‘张三‘,2323.43,‘8阿达是的发送到发送的‘),(‘6184E8770C5B471E91EDDBE6B2632DE4‘,‘phone555555‘,2323.43,‘9phone1mark顶顶顶顶‘); /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
src/dao/AddDataDao.java:
package com.gordon.dao;
import java.sql.SQLException;
import org.apache.commons.dbutils.QueryRunner;
import com.gordon.domain.Phone;
import com.gordon.utils.DataSourceUtils;
public class AddDataDao {
public void addData(Phone phone) throws SQLException {
QueryRunner qr = new QueryRunner(DataSourceUtils.getDataSource());
String sql = "insert into phone (id, name, price, mark) values (?,?,?,?)";
qr.update(sql, phone.getId(), phone.getName(), phone.getPrice(), phone.getMark());
}
}
src/dao/DeleteDataDao.java:
package com.gordon.dao;
import java.sql.SQLException;
import org.apache.commons.dbutils.QueryRunner;
import com.gordon.utils.DataSourceUtils;
public class DeleteDataDao {
/**
* 根据id删除数据
* @param id
* @throws SQLException
*/
public void deleteDataById(String id) throws SQLException {
QueryRunner qr = new QueryRunner(DataSourceUtils.getDataSource());
String sql = "delete from phone where id = ?";
qr.update(sql, id);
}
}
src/dao/GetDataDao.java:
package com.gordon.dao;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import org.apache.commons.dbutils.handlers.ScalarHandler;
import com.gordon.domain.Phone;
import com.gordon.utils.DataSourceUtils;
public class GetDataDao {
/**
* 获取所有数据
*
* @return
* @throws SQLException
*/
public List<Phone> getAllData() throws SQLException {
QueryRunner qr = new QueryRunner(DataSourceUtils.getDataSource());
String sql = "select * from phone";
return qr.query(sql, new BeanListHandler<Phone>(Phone.class));
}
/**
* 根据id获取数据
*
* @param id
* @return
* @throws SQLException
*/
public Phone getDataById(String id) throws SQLException {
QueryRunner qr = new QueryRunner(DataSourceUtils.getDataSource());
String sql = "select * from phone where id = ?";
return qr.query(sql, new BeanHandler<Phone>(Phone.class), id);
}
/**
* 根据关键词查询信息
*
* @param category
* @param keyword
* @return
* @throws SQLException
*/
public List<Phone> getDataByKeyword(String category, String keyword) throws SQLException {
QueryRunner qr = new QueryRunner(DataSourceUtils.getDataSource());
String sql = "select * from phone where 1 = 1 ";
ArrayList<String> arrayList = new ArrayList<>();
if (category != null && category.trim().length() > 0) {
sql += " and mark like ? ";
arrayList.add("%" + category + "%");
}
if (keyword != null && keyword.trim().length() > 0) {
sql += " and mark like ? ";
arrayList.add("%" + keyword + "%");
}
return qr.query(sql, new BeanListHandler<Phone>(Phone.class), arrayList.toArray());
}
/**
* 分页查询
*
* @param start
* @param page_size
* @return
* @throws SQLException
*/
public List<Phone> getDataByLimit(int start, int page_size) throws SQLException {
QueryRunner qr = new QueryRunner(DataSourceUtils.getDataSource());
String sql = "select * from phone limit ?, ?";
return qr.query(sql, new BeanListHandler<Phone>(Phone.class), start, page_size);
}
/**
* 获取查询数据总条数
*
* @return
* @throws SQLException
* @throws NumberFormatException
*/
public int getDataTotalCount() throws NumberFormatException, SQLException {
QueryRunner qr = new QueryRunner(DataSourceUtils.getDataSource());
String sql = "select count(*) from phone";
return Integer.valueOf(qr.query(sql, new ScalarHandler(1)).toString());
}
}
src/dao/UpdateDataDao.java:
package com.gordon.dao;
import java.sql.SQLException;
import org.apache.commons.dbutils.QueryRunner;
import com.gordon.domain.Phone;
import com.gordon.utils.DataSourceUtils;
public class UpdateDataDao {
/**
* 根据id更新数据
*
* @param phone
* @throws SQLException
*/
public void updateDataById(Phone phone) throws SQLException {
QueryRunner qr = new QueryRunner(DataSourceUtils.getDataSource());
String sql = "update phone set name = ?, price = ?, mark = ? where id = ?";
qr.update(sql, phone.getName(), phone.getPrice(), phone.getMark(), phone.getId());
}
}
---------------------------------------------------------------------
src/domain/Page.java:
package com.gordon.domain;
import java.util.List;
public class Page<T> {
private List<T> list = null; // 存储每一页的数据
private int curr_page = 1; // 当前页数
private int page_size = 2; // 每一页大小
private int total_page = 0; // 总页数
private int total_count = 0; // 总记录条数
// 显示页码时，当前页码前后要显示的页数。
// 如，show_page=2，且当前页是第5页，则前面显示3,4 后面显示6,7其余页不显示。
private int show_page = 3;
public int getShow_page() {
return show_page;
}
public void setShow_page(int show_page) {
this.show_page = show_page;
}
public List<T> getList() {
return list;
}
public void setList(List<T> list) {
this.list = list;
}
public int getCurr_page() {
return curr_page;
}
public void setCurr_page(int curr_page) {
this.curr_page = curr_page;
}
public int getPage_size() {
return page_size;
}
public void setPage_size(int page_size) {
this.page_size = page_size;
}
public int getTotal_page() {
this.total_page = (int) Math.ceil((total_count * 1.0) / page_size);
return total_page;
}
public void setTotal_page(int total_page) {
this.total_page = total_page;
}
public int getTotal_count() {
return total_count;
}
public void setTotal_count(int total_count) {
this.total_count = total_count;
}
}
src/domain/Phone.java:
package com.gordon.domain;
public class Phone {
private String id;
private String name;
private Double price;
private String mark;
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 Double getPrice() {
return price;
}
public void setPrice(Double price) {
this.price = price;
}
public String getMark() {
return mark;
}
public void setMark(String mark) {
this.mark = mark;
}
}
---------------------------------------------------------------------
src/service/AddDataService.java:
package com.gordon.service;
import java.sql.SQLException;
import com.gordon.dao.AddDataDao;
import com.gordon.domain.Phone;
public class AddDataService {
/**
* 添加一条数据
* @param phone
* @throws SQLException
*/
public void addData(Phone phone) throws SQLException {
new AddDataDao().addData(phone);
}
}
src/service/DeleteDataService.java:
package com.gordon.service;
import java.sql.SQLException;
import com.gordon.dao.DeleteDataDao;
public class DeleteDataService {
/**
* 根据id删除数据
*
* @param id
* @throws SQLException
*/
public void deleteDataById(String id) throws SQLException {
new DeleteDataDao().deleteDataById(id);
}
}
src/service/GetDataService.java:
package com.gordon.service;
import java.sql.SQLException;
import java.util.List;
import com.gordon.dao.GetDataDao;
import com.gordon.domain.Phone;
public class GetDataService {
/**
* 获取所有数据
*
* @return
* @throws SQLException
*/
public List<Phone> getAllData() throws SQLException {
return new GetDataDao().getAllData();
}
/**
* 根据id获取数据
*
* @param id
* @return
* @throws SQLException
*/
public Phone getDataById(String id) throws SQLException {
return new GetDataDao().getDataById(id);
}
/**
* 根据关键词查询数据
*
* @param category
* @param keyword
* @return
* @throws SQLException
*/
public List<Phone> getDataByKeyword(String category, String keyword) throws SQLException {
return new GetDataDao().getDataByKeyword(category, keyword);
}
/**
* 分页查询
*
* @param start
* @param page_size
* @return
* @throws SQLException
*/
public List<Phone> getDataByLimit(int start, int page_size) throws SQLException {
return new GetDataDao().getDataByLimit(start, page_size);
}
/**
* 获取查询数据总条数
* @return
* @throws SQLException
* @throws NumberFormatException
*/
public int getDataTotalCount() throws NumberFormatException, SQLException {
return new GetDataDao().getDataTotalCount();
}
}
src/service/UpdateDataService.java:
package com.gordon.service;
import java.sql.SQLException;
import com.gordon.dao.UpdateDataDao;
import com.gordon.domain.Phone;
public class UpdateDataService {
/**
* 更新数据
* @param phone
* @throws SQLException
*/
public void updateDataById(Phone phone) throws SQLException {
new UpdateDataDao().updateDataById(phone);
}
}
---------------------------------------------------------------------
src/utils/DataSourceUtils.java:
package com.gordon.utils;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.sql.DataSource;
import com.mchange.v2.c3p0.ComboPooledDataSource;
public class DataSourceUtils {
private static ComboPooledDataSource ds=new ComboPooledDataSource();
/**
* 获取数据源
* @return 连接池
*/
public static DataSource getDataSource(){
return ds;
}
/**
* 获取连接
* @return 连接
* @throws SQLException
*/
public static Connection getConnection() throws SQLException{
return ds.getConnection();
}
/**
* 释放资源
*
* @param conn
* 连接
* @param st
* 语句执行者
* @param rs
* 结果集
*/
public static void closeResource(Connection conn, Statement st, ResultSet rs) {
closeResultSet(rs);
closeStatement(st);
closeConn(conn);
}
/**
* 释放连接
*
* @param conn
* 连接
*/
public static void closeConn(Connection conn) {
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
conn = null;
}
}
/**
* 释放语句执行者
*
* @param st
* 语句执行者
*/
public static void closeStatement(Statement st) {
if (st != null) {
try {
st.close();
} catch (SQLException e) {
e.printStackTrace();
}
st = null;
}
}
/**
* 释放结果集
*
* @param rs
* 结果集
*/
public static void closeResultSet(ResultSet rs) {
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
rs = null;
}
}
}
src/utils/RandomNumber.java:
package com.gordon.utils;
import java.util.UUID;
public class RandomNumber {
public static String getRandomId() {
return UUID.randomUUID().toString().replace("-", "").toUpperCase();
}
}
---------------------------------------------------------------------
src/web.servlet/AddDataServlet.java:
package com.gordon.web.servlet;
import java.io.IOException;
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 org.apache.commons.beanutils.BeanUtils;
import com.gordon.domain.Phone;
import com.gordon.service.AddDataService;
import com.gordon.utils.RandomNumber;
/**
* 添加用户数据
*/
@WebServlet("/addData")
public class AddDataServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public AddDataServlet() {
super();
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
* response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
response.setContentType("text/html;charset=utf-8;");
// 判断是否为重复提交
String r_token = request.getParameter("r_token");
String s_token = (String) request.getSession().getAttribute("s_token");
//清除s_token，以便于重新生成。
request.getSession().removeAttribute("s_token");
// 判断session中是否存在Token，并且是否与客户端Token相同，不同则不是同一次请求。
if(s_token == null || !s_token.equals(r_token)) {
request.setAttribute("msg", "重复提交！");
request.getRequestDispatcher("/msg.jsp").forward(request, response);
return;
}
try {
Phone phone = new Phone();
BeanUtils.populate(phone, request.getParameterMap());
BeanUtils.setProperty(phone, "id", RandomNumber.getRandomId());
new AddDataService().addData(phone);
} catch (Exception e) {
e.printStackTrace();
}
/**
* 使用请求转发，会导致数据重复提交。
* 两种解决方法：
* 1.使用重定向 sendRedirect()。但是不能再同意请求内传递数据，最好使用令牌技术.
* 2.使用令牌技术
*/
request.getRequestDispatcher("/getAllData").forward(request, response);
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
* response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
}
src/web.servlet/DeleteDataByIdServlet.java:
package com.gordon.web.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 com.gordon.service.DeleteDataService;
/**
* 根据id删除数据
*/
@WebServlet("/deleteDataById")
public class DeleteDataByIdServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public DeleteDataByIdServlet() {
super();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
String id = request.getParameter("id");
try {
new DeleteDataService().deleteDataById(id);
} catch (SQLException e) {
e.printStackTrace();
}
response.sendRedirect(request.getContextPath() + "/getAllData");
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
}
src/web.servlet/DeleteMultipleDataByIdServlet.java:
package com.gordon.web.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 com.gordon.service.DeleteDataService;
/**
* 删除多项数据
*/
@WebServlet("/deleteMultipleDataByIds")
public class DeleteMultipleDataByIdsServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public DeleteMultipleDataByIdsServlet() {
super();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String[] ids = request.getParameterValues("ids");
try {
for (int i = 0; i < ids.length; i++) {
new DeleteDataService().deleteDataById(ids[i]);
}
} catch (SQLException e) {
e.printStackTrace();
}
response.sendRedirect(request.getContextPath() + "/getAllData");
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
}
src/web.servlet/GetAllDataServlet.java:
package com.gordon.web.servlet;
import java.io.IOException;
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.gordon.domain.Page;
import com.gordon.domain.Phone;
import com.gordon.service.GetDataService;
/**
* 获取所有数据
*/
@WebServlet("/getAllData")
public class GetAllDataServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public GetAllDataServlet() {
super();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
Page<Phone> page_phone = new Page<Phone>();
try {
// 当前页，不存在默认为 1
int curr_page = (request.getParameter("page") == null) ? 1 : Integer.valueOf(request.getParameter("page"));
page_phone.setCurr_page(curr_page);
// 总条数
page_phone.setTotal_count(new GetDataService().getDataTotalCount());
// 开始位置&每页大小
int start = (Integer.valueOf(curr_page) - 1) * page_phone.getPage_size();
int pagesize = page_phone.getPage_size();
// 设置获取的结果集
page_phone.setList(new GetDataService().getDataByLimit(start, pagesize));
} catch (Exception e) {
e.printStackTrace();
}
// 向域中传递Page&list对象
request.setAttribute("list", page_phone.getList()); // 数据集
request.setAttribute("page", page_phone); //page对象
request.getRequestDispatcher("/show_data.jsp").forward(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
}
src/web.servlet/GetDataByIdServlet.java:
package com.gordon.web.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 com.gordon.domain.Phone;
import com.gordon.service.GetDataService;
/**
* 根据id获取数据，并转发到修改数据页面
*/
@WebServlet("/getDataById")
public class GetDataByIdServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public GetDataByIdServlet() {
super();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
String id = request.getParameter("id");
Phone phone = null;
try {
phone = new GetDataService().getDataById(id);
} catch (SQLException e) {
e.printStackTrace();
}
request.setAttribute("phone", phone);
request.getRequestDispatcher("/update_data.jsp").forward(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
}
src/web.servlet/GetDataByKeyword.java:
package com.gordon.web.servlet;
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 com.gordon.domain.Phone;
import com.gordon.service.GetDataService;
/**
* 根据关键字查询数据库
*/
@WebServlet("/getDataByKeyword")
public class GetDataByKeywordServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public GetDataByKeywordServlet() {
super();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
String category = request.getParameter("category");
String keyword = request.getParameter("keyword");
List<Phone> plist = null;
try {
plist = new GetDataService().getDataByKeyword(category, keyword);
} catch (SQLException e) {
e.printStackTrace();
}
request.setAttribute("list", plist);
request.getRequestDispatcher("/show_data.jsp").forward(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
}
src/web.servlet/UpdateDataByIdServlet.java:
package com.gordon.web.servlet;
import java.io.IOException;
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 org.apache.commons.beanutils.BeanUtils;
import com.gordon.domain.Phone;
import com.gordon.service.UpdateDataService;
/**
* 修改数据
*/
@WebServlet("/updateDataById")
public class UpdateDataByIdServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public UpdateDataByIdServlet() {
super();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
try {
Phone phone = new Phone();
BeanUtils.populate(phone, request.getParameterMap());
new UpdateDataService().updateDataById(phone);
} catch (Exception e) {
e.printStackTrace();
}
response.sendRedirect(request.getContextPath() + "/getAllData");
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
}
---------------------------------------------------------------------
c3po-config.xml
<c3p0-config> <!-- 默认配置，如果没有指定则使用这个配置 --> <default-config> <!-- 基本配置 --> <property name="driverClass">com.mysql.jdbc.Driver</property> <property name="jdbcUrl">jdbc:mysql://localhost:3306/phone_store</property> <property name="user">root</property> <property name="password">root</property> <!--扩展配置--> <property name="checkoutTimeout">30000</property> <property name="idleConnectionTestPeriod">30</property> <property name="initialPoolSize">10</property> <property name="maxIdleTime">30</property> <property name="maxPoolSize">100</property> <property name="minPoolSize">10</property> <property name="maxStatements">200</property> </default-config> <!-- 命名的配置 --> <named-config name="itcast"> <property name="driverClass">com.mysql.jdbc.Driver</property> <property name="jdbcUrl">jdbc:mysql://127.0.0.1:3306/xxxx</property> <property name="user">root</property> <property name="password">1234</property> <!-- 如果池中数据连接不够时一次增长多少个 --> <property name="acquireIncrement">5</property> <property name="initialPoolSize">20</property> <property name="minPoolSize">10</property> <property name="maxPoolSize">40</property> <property name="maxStatements">20</property> <property name="maxStatementsPerConnection">5</property> </named-config> </c3p0-config>
---------------------------------------------------------------------
add_data.jsp
<%@page import="com.gordon.utils.RandomNumber"%>
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="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>
<%
String randomToken = RandomNumber.getRandomId();
request.getSession().setAttribute("s_token", randomToken);
%>
<form action="${ pageContext.request.contextPath }/addData" method="post">
<input type="hidden" name="r_token" value="http://www.mamicode.com/">
<table border="1" align="center">
<tr>
<td>名称：</td>
<td><input type="text" name="name"></td>
</tr>
<tr>
<td>价格：</td>
<td><input type="text" name="price"></td>
</tr>
<tr>
<td>简介：</td>
<td><input type="text" name="mark"></td>
</tr>
<tr>
<td><input type="submit" value="http://www.mamicode.com/提交"></td>
</tr>
</table>
</form>
</body>
</html>
index.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="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>
<a href="http://www.mamicode.com/${ pageContext.request.contextPath }/getAllData">显示所有数据</a><br/>
<a href="http://www.mamicode.com/${ pageContext.request.contextPath }/add_data.jsp">添加数据</a><br/>
</body>
</html>
msg.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="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>
${ msg }
</body>
</html>
show_data.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@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>
<form action="${ pageContext.request.contextPath }/getDataByKeyword" method="post">
<table border="1" align="center">
<tr>
<td colspan="5">分类查询：<input type="text" name="category"> 关键字查询：<input
type="text" name="keyword"></td>
<td><input type="submit" value="http://www.mamicode.com/查询"></td>
</tr>
</table>
</form>
<br>
<form id="deleteMultipleForm" action="${ pageContext.request.contextPath }/deleteMultipleDataByIds"
method="post">
<table border="1" align="center">
<tr>
<td><input type="checkbox" onclick="allCheck(this)"></td>
<td>ID</td>
<td>名称</td>
<td>价格</td>
<td>简介</td>
<td>操作</td>
</tr>
<c:forEach items="${ list }" var="p">
<tr>
<td><input type="checkbox" name="ids" value="http://www.mamicode.com/${ p.id }"></td>
<td>${ p.id }</td>
<td>${ p.name }</td>
<td>${ p.price }</td>
<td>${ p.mark }</td>
<td><a href="http://www.mamicode.com/${ pageContext.request.contextPath }/getDataById?id=${ p.id }">修改</a> | <a
href="javascript:void(0);" onclick="deleteData(‘${ p.id }‘)">删除</a></td>
</tr>
</c:forEach>
<tr>
<td colspan="6"><input type="button" onclick="deleteMultiple()" value="http://www.mamicode.com/删除"></td>
</tr>
</table>
</form>
<br>
<table border="1" align="center">
<tr>
<td colspan="5">
<c:choose>
<c:when test="${ empty page.list }">
[首页][下一页][上一页][尾页]
</c:when>
<c:otherwise>
<!-- 首页&上一页 -->
<c:choose>
<c:when test="${ page.curr_page == 1 }">
[首页] [上一页]
</c:when>
<c:otherwise>
<!-- 首页 -->
<a href="http://www.mamicode.com/${ pageContext.request.contextPath }/getAllData">[首页]</a>
<!-- 上一页 -->
<c:choose>
<c:when test="${ (page.curr_page - 1) <= 0 }">
<a href="http://www.mamicode.com/${ pageContext.request.contextPath }/getAllData">[上一页]</a>
</c:when>
<c:otherwise>
<a href="http://www.mamicode.com/${ pageContext.request.contextPath }/getAllData?page=${ page.curr_page - 1 }">[上一页]</a>
</c:otherwise>
</c:choose>
</c:otherwise>
</c:choose>
<!-- 显示页码 -->
<c:set var="showpage" value="http://www.mamicode.com/${ page.show_page }"></c:set>
<!-- 计算起始位置 -->
<c:choose>
<c:when test="${ page.curr_page - showpage > 0}">
<c:set var="start" value="http://www.mamicode.com/${ page.curr_page - showpage }"></c:set>
</c:when>
<c:otherwise>
<c:set var="start" value="http://www.mamicode.com/1"></c:set>
</c:otherwise>
</c:choose>
<!-- 计算结束位置 -->
<c:choose>
<c:when test="${ page.curr_page + showpage <= page.total_page }">
<c:set var="end" value="http://www.mamicode.com/${ page.curr_page + showpage }"></c:set>
</c:when>
<c:otherwise>
<c:set var="end" value="http://www.mamicode.com/${ page.total_page }"></c:set>
</c:otherwise>
</c:choose>
<!-- 循环显示页码 -->
<c:forEach begin="${ start }" end="${ end }" var="i">
<c:choose>
<c:when test="${ page.curr_page == i }">
${ i }
</c:when>
<c:otherwise>
<a href="http://www.mamicode.com/${ pageContext.request.contextPath }/getAllData?page=${ i }">${ i }</a>
</c:otherwise>
</c:choose>
</c:forEach>
<!-- 下一页&尾页 -->
<c:choose>
<c:when test="${ page.curr_page == page.total_page }">
[下一页] [尾页]
</c:when>
<c:otherwise>
<!-- 下一页 -->
<c:choose>
<c:when test="${ (page.curr_page + 1) > page.total_page }">
<a href="http://www.mamicode.com/${ pageContext.request.contextPath }/getAllData?page=${ page.curr_page }">[下一页]
</a>
</c:when>
<c:otherwise>
<a href="http://www.mamicode.com/${ pageContext.request.contextPath }/getAllData?page=${ page.curr_page + 1 }">[下一页]</a>
</c:otherwise>
</c:choose>
<!-- 尾页 -->
<a href="http://www.mamicode.com/${ pageContext.request.contextPath }/getAllData?page=${ page.total_page }">[尾页]</a>
</c:otherwise>
</c:choose>
<!-- 信息 -->
第${ page.curr_page }页 / 共${ page.total_page }页
</c:otherwise>
</c:choose>
</td>
</tr>
</table>
</body>
<script type="text/javascript">
//根据id删除数据
function deleteData(id) {
if (confirm("确定删除吗？")) {
window.location.href = "http://www.mamicode.com/${ pageContext.request.contextPath }/deleteDataById?id="
+ id;
}
}
//全选/全不选
function allCheck(this_obj) {
var arrs = document.getElementsByName("ids");
for (var i = 0; i < arrs.length; i++) {
arrs[i].checked = this_obj.checked;
}
}
//多选删除时，判断是否选中
function deleteMultiple() {
var flag = false;
var arrs = document.getElementsByName("ids");
for (var i = 0; i < arrs.length; i++) {
if (arrs[i].checked) {
flag = true;
break;
}
}
if (flag) {
if (confirm("确定删除选中项目？")) {
document.getElementById("deleteMultipleForm").submit();
}
} else {
alert("请选择删除项目！");
}
}
</script>
</html>
update_data.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="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>
<form action="${ pageContext.request.contextPath }/updateDataById" method="post">
<input type="hidden" name="id" value="http://www.mamicode.com/${ phone.id }">
<table border="1" align="center">
<tr>
<td>名称：</td>
<td><input type="text" name="name" value="http://www.mamicode.com/${ phone.name }"></td>
</tr>
<tr>
<td>价格：</td>
<td><input type="text" name="price" value="http://www.mamicode.com/${ phone.price }"></td>
</tr>
<tr>
<td>简介：</td>
<td><input type="text" name="mark" value="http://www.mamicode.com/${ phone.mark }"></td>
</tr>
<tr>
<td><input type="submit" value="http://www.mamicode.com/修改"></td>
</tr>
</table>
</form>
</body>
</html>
java- 综合实例-增删查改查，删除多项，分页
声明：以上内容来自用户投稿及互联网公开渠道收集整理发布，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任，若内容有误或涉及侵权可进行投诉： 投诉/举报 工作人员会在5个工作日内联系你，一经查实，本站将立刻删除涉嫌侵权内容。