java- 综合实例-增删查改查，删除多项，分页

标签：mod数据页面index.jspvax定向简介statementthishar

重点内容：分页、令牌机制（重定向下防止重复提交）、使用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);
}

}