public class UserDao implements DAO<User> {
private static final long serialVersionUID = 1L;
private Connection connection = null;
private PreparedStatement preparedStatement = null;
private ResultSet resultSet = null;
public boolean doAdd(User entity) {
// TODO Auto-generated catch block
return doInsertOrUpdate(entity, "add");
}
public boolean doDeleteById(Serializable id) {
boolean flag = false;
String sql = "delete from users where id =?";
try {
connection = DBHandle.getConnection();
preparedStatement = connection.prepareStatement(sql);
preparedStatement.setInt(1, Integer.parseInt(id.toString()));
int rows = preparedStatement.executeUpdate();
if (rows > 0)
flag = true;
} catch (SQLException e) {
// TODO Auto-generated catch block
flag = false;
e.printStackTrace();
} finally {
DBHandle.close(preparedStatement, connection);
}
return flag;
}
public List<User> doSelect() {
List<User> list = new ArrayList<User>();
String sql = "select id,name,age,tel,address from users";
try {
connection = DBHandle.getConnection();
preparedStatement = connection.prepareStatement(sql);
resultSet = preparedStatement.executeQuery();
while (resultSet.next()) {
User user = new User();
user.setId(resultSet.getInt("id"));
user.setName(resultSet.getString("name"));
user.setAge(resultSet.getInt("age"));
user.setTel(resultSet.getString("tel"));
user.setAddress(resultSet.getString("address"));
list.add(user);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
list = null;
e.printStackTrace();
} finally {
DBHandle.close(resultSet, preparedStatement, connection);
}
if (list.size() > 0)
return list;
return null;
}
public User doSelectById(Serializable id) {
User user = null;
String sql = "select * from users where id=?";
try {
connection = DBHandle.getConnection();
preparedStatement = connection.prepareStatement(sql);
preparedStatement.setInt(1, Integer.parseInt(id.toString()));
resultSet = preparedStatement.executeQuery();
if (resultSet.next()) {
user = new User();
user.setId(resultSet.getInt("id"));
user.setName(resultSet.getString("name"));
user.setAge(resultSet.getInt("age"));
user.setTel(resultSet.getString("tel"));
user.setAddress(resultSet.getString("address"));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
user = null;
e.printStackTrace();
} finally {
DBHandle.close(resultSet, preparedStatement, connection);
}
return user;
}
public boolean doUpdate(User entity) {
// TODO Auto-generated method stub
return doInsertOrUpdate(entity, "update");
}
private boolean doInsertOrUpdate(User entity, String identity) {
boolean flag = false;
StringBuilder sql = new StringBuilder("");
try {
connection = DBHandle.getConnection();
if ("add" == identity) {
sql
.append("insert into users (name, age, tel, address) values(?,?,?,?);");
} else if ("update" == identity) {
sql
.append("update users set name=?,age=?,tel=?,address=? where id=?;");
}
preparedStatement = connection.prepareStatement(sql.toString());
preparedStatement.setString(1, entity.getName());
preparedStatement.setInt(2, entity.getAge());
preparedStatement.setString(3, entity.getTel());
preparedStatement.setString(4, entity.getAddress());
if ("update" == identity) {
preparedStatement.setInt(5, entity.getId());
}
int rows = preparedStatement.executeUpdate();
if (rows > 0)
flag = true;
} catch (SQLException e) {
// TODO Auto-generated catch block
flag = false;
e.printStackTrace();
} finally {
DBHandle.close(preparedStatement, connection);
}
return flag;
}
public List<User> doList(Page<User> page) {
List<User> list = new ArrayList<User>();
connection = DBHandle.getConnection();
StringBuilder sql = new StringBuilder("");
if (page.getNowPage() >= 1)
sql.append("select * from users order by id desc limit "
+ (page.getNowPage() - 1) * page.getPageSize() + ","
+ page.getPageSize() + ";");
else
sql
.append("select * from users order by id desc limit "
+ (0 * page.getPageSize()) + ","
+ page.getPageSize() + ";");
// String sql = "select * from users order by id desc limit "
// + (nowPage - 1) * pageRow + "," + pageRow;
try {
preparedStatement = connection.prepareStatement(sql.toString());
resultSet = preparedStatement.executeQuery();
while (resultSet.next()) {
User user = new User();
user.setId(resultSet.getInt("id"));
user.setName(resultSet.getString("name"));
user.setAge(resultSet.getInt("age"));
user.setTel(resultSet.getString("tel"));
user.setAddress(resultSet.getString("address"));
list.add(user);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
DBHandle.close(resultSet, preparedStatement, connection);
}
return list;
}
public Page<User> doTotalPage(Page<User> page) {
int totalPage = 0;
connection = DBHandle.getConnection();
try {
preparedStatement = connection
.prepareStatement("select count(id) from users");
resultSet = preparedStatement.executeQuery();
if (resultSet.next()) {
// 获得总页数;总页数=上取整(总记录/每页大小)
// System.out.println("总记录:"+rs.getInt(1)+"每页大小:"+dopage.getPageSize()+"页数:"+rs.getInt(1)/Double.parseDouble(dopage.getPageSize()+""));
totalPage = (int) Math.ceil(resultSet.getInt(1)
/ Double.parseDouble(page.getPageSize() + ""));
page.setTotalPage(totalPage);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
DBHandle.close(resultSet, preparedStatement, connection);
}
return page;
}
}
增删改查和分页,学习、练习,附件为源码
private static final long serialVersionUID = 1L;
private Connection connection = null;
private PreparedStatement preparedStatement = null;
private ResultSet resultSet = null;
public boolean doAdd(User entity) {
// TODO Auto-generated catch block
return doInsertOrUpdate(entity, "add");
}
public boolean doDeleteById(Serializable id) {
boolean flag = false;
String sql = "delete from users where id =?";
try {
connection = DBHandle.getConnection();
preparedStatement = connection.prepareStatement(sql);
preparedStatement.setInt(1, Integer.parseInt(id.toString()));
int rows = preparedStatement.executeUpdate();
if (rows > 0)
flag = true;
} catch (SQLException e) {
// TODO Auto-generated catch block
flag = false;
e.printStackTrace();
} finally {
DBHandle.close(preparedStatement, connection);
}
return flag;
}
public List<User> doSelect() {
List<User> list = new ArrayList<User>();
String sql = "select id,name,age,tel,address from users";
try {
connection = DBHandle.getConnection();
preparedStatement = connection.prepareStatement(sql);
resultSet = preparedStatement.executeQuery();
while (resultSet.next()) {
User user = new User();
user.setId(resultSet.getInt("id"));
user.setName(resultSet.getString("name"));
user.setAge(resultSet.getInt("age"));
user.setTel(resultSet.getString("tel"));
user.setAddress(resultSet.getString("address"));
list.add(user);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
list = null;
e.printStackTrace();
} finally {
DBHandle.close(resultSet, preparedStatement, connection);
}
if (list.size() > 0)
return list;
return null;
}
public User doSelectById(Serializable id) {
User user = null;
String sql = "select * from users where id=?";
try {
connection = DBHandle.getConnection();
preparedStatement = connection.prepareStatement(sql);
preparedStatement.setInt(1, Integer.parseInt(id.toString()));
resultSet = preparedStatement.executeQuery();
if (resultSet.next()) {
user = new User();
user.setId(resultSet.getInt("id"));
user.setName(resultSet.getString("name"));
user.setAge(resultSet.getInt("age"));
user.setTel(resultSet.getString("tel"));
user.setAddress(resultSet.getString("address"));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
user = null;
e.printStackTrace();
} finally {
DBHandle.close(resultSet, preparedStatement, connection);
}
return user;
}
public boolean doUpdate(User entity) {
// TODO Auto-generated method stub
return doInsertOrUpdate(entity, "update");
}
private boolean doInsertOrUpdate(User entity, String identity) {
boolean flag = false;
StringBuilder sql = new StringBuilder("");
try {
connection = DBHandle.getConnection();
if ("add" == identity) {
sql
.append("insert into users (name, age, tel, address) values(?,?,?,?);");
} else if ("update" == identity) {
sql
.append("update users set name=?,age=?,tel=?,address=? where id=?;");
}
preparedStatement = connection.prepareStatement(sql.toString());
preparedStatement.setString(1, entity.getName());
preparedStatement.setInt(2, entity.getAge());
preparedStatement.setString(3, entity.getTel());
preparedStatement.setString(4, entity.getAddress());
if ("update" == identity) {
preparedStatement.setInt(5, entity.getId());
}
int rows = preparedStatement.executeUpdate();
if (rows > 0)
flag = true;
} catch (SQLException e) {
// TODO Auto-generated catch block
flag = false;
e.printStackTrace();
} finally {
DBHandle.close(preparedStatement, connection);
}
return flag;
}
public List<User> doList(Page<User> page) {
List<User> list = new ArrayList<User>();
connection = DBHandle.getConnection();
StringBuilder sql = new StringBuilder("");
if (page.getNowPage() >= 1)
sql.append("select * from users order by id desc limit "
+ (page.getNowPage() - 1) * page.getPageSize() + ","
+ page.getPageSize() + ";");
else
sql
.append("select * from users order by id desc limit "
+ (0 * page.getPageSize()) + ","
+ page.getPageSize() + ";");
// String sql = "select * from users order by id desc limit "
// + (nowPage - 1) * pageRow + "," + pageRow;
try {
preparedStatement = connection.prepareStatement(sql.toString());
resultSet = preparedStatement.executeQuery();
while (resultSet.next()) {
User user = new User();
user.setId(resultSet.getInt("id"));
user.setName(resultSet.getString("name"));
user.setAge(resultSet.getInt("age"));
user.setTel(resultSet.getString("tel"));
user.setAddress(resultSet.getString("address"));
list.add(user);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
DBHandle.close(resultSet, preparedStatement, connection);
}
return list;
}
public Page<User> doTotalPage(Page<User> page) {
int totalPage = 0;
connection = DBHandle.getConnection();
try {
preparedStatement = connection
.prepareStatement("select count(id) from users");
resultSet = preparedStatement.executeQuery();
if (resultSet.next()) {
// 获得总页数;总页数=上取整(总记录/每页大小)
// System.out.println("总记录:"+rs.getInt(1)+"每页大小:"+dopage.getPageSize()+"页数:"+rs.getInt(1)/Double.parseDouble(dopage.getPageSize()+""));
totalPage = (int) Math.ceil(resultSet.getInt(1)
/ Double.parseDouble(page.getPageSize() + ""));
page.setTotalPage(totalPage);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
DBHandle.close(resultSet, preparedStatement, connection);
}
return page;
}
}
增删改查和分页,学习、练习,附件为源码
- TestInterview.zip (1 MB)
- 下载次数: 2
发表评论
-
Spring aop
2018-09-10 18:23 447org.springframework.aop.aspectj ... -
Java并发编程-客户端加锁机制
2017-06-25 17:14 1168Java并发编程P61 public class List ... -
Java并发实战-私有构造函数捕获
2017-06-24 21:58 739java并发编程实战P58 私有构造函数捕获:私有构造 ... -
java.lang.Void
2017-06-20 23:39 504java.util.concurrent.ForkJoinP ... -
java.lang.NoSuchMethodError: org.objectweb.asm.ClassVisitor.visit
2014-06-11 13:11 1196严重: Exception sending context i ... -
jvm学习笔记
2014-03-25 13:47 725学习笔记 HotSpot不区分虚拟机栈和本地方法栈,所以 ... -
自定义标签与spring注入报空
2014-03-25 13:08 714在自定义标签中注入spring对象报空 参考链接: ... -
javascript学习笔记
2013-05-02 17:32 1097<!-- form表单提交时, ... -
java中基本数据类型和引用类型的==和equals判断体会
2013-04-19 13:23 1161今天下午遇到一个问题 :两个相等的整数相比结果返回false, ... -
出现Exception之后会影响程序的执行流程吗
2013-04-19 13:02 841程序出现异常后catch块以后的代码是否执行?以下是一个小示例 ... -
eclipse时间
2013-03-14 21:50 697eclipse时间@date @time 时间格式转换成,例如 ... -
eclipse集成tomcat
2013-03-14 21:46 691在eclipse中找到${path}\eclipse\plug ... -
eclipse实现openexplorer功能
2013-03-14 21:42 686在eclipse中找到${path}\eclipse\plug ... -
连接工厂
2012-12-05 22:58 844//JDBC编程练习 public class DBHandl ... -
java有关英文缩写
2012-06-06 21:36 999JDK(Java Development Kit,java ... -
解决Myeclipse导入包出现不了referenced libraries的问题
2011-09-02 09:29 2506我想往Web工程里面导入些包,复制到WebRoot ---&g ... -
Java多态性详解——父类引用子类对象
2011-08-17 12:41 1270面向对象编程有三个特征,即封装、继承和多态。 封装隐藏 ...
相关推荐
jdbc封装(实现对实体的增删改查[分页]),辅助学习Hibernate 包含三个文件夹,分别是: code-access实现 是用access实现的,本意是access方便,就一个文件,方便部署。但access有好多不支持,就写成这样.主要是可参考Dao...
绝对不会让你后悔的,此为自己练习时做的项目,综合了标题所述的技术
struts2增删改查,struts2分页查询
使用jquery easyui和原生jdbc实现 增删改查以及分页显示
如题,采用jdbc实现增删改查,范例采用mysql数据库,没有实现分页,适合初学者
这是有jsp+jdbc+servlet编写的分页,而且带增删查改,采用MVC模式,思路清晰,看代码建立数据库,打开即可运行
* 分页查询数据 4.准备环境 5.Servlet + JSP +JavaBean + JDBC(DBUtils)+ mysql 6.数据库 create database day19; use day19; create table t_customer( id varchar(40) primary key, username varchar(20)...
一个servlet + JDBC 写的一个新闻发布系统,附带Oracle 数据库,前台用户对新闻的点击查看,后台管理新闻,对新闻的增删改查,附带最基本的数据库分页,Myeclipse9.0 + Tomcat6.0 直接可以用
数据库采用oracle,完成jsp增删改查、查询、过滤、分页、排序功能。对刚刚接触jsp的软件开发人员来说绝对是最好的范例。
简易的JSP信息管理程序,JSP+MVC+数据分页_增删改查
使用Servlet+Jsp+JDBC实现增删改查,前台显示界面使用JavaScript、Ajax与后台交互进行登录验证,并对查询结果实现分页、局部刷新,以及复选框(全选、反选)操作,适合Web开发的初学者
编写Web应用程序(JavaEE平台上的应用,能够运行在Tomcat服务器上),实现学生信息的增删改查。 在Web页面上实现添加一个学生记录,删除某个学生记录,修改某个学生记录,和按照姓名,学号进行查询。 要求列表输出...
初学者尝试写的一个jdbc+mysql+jsp实现的简单管理系统,包含数据的增删改查分页等功能。
jdbc-servlet-jsp01实现用户-登录-添加删出修改查询等功能
登录+注册的增删改差有分页!
Servlet+JSP+JDBC实现增删查(真分页)改j2ee小项目,数据库采用MySQL,log4j记录日志,自已封装了查询条件类和分页类,欢迎大家下载,互相学习。
1:本系统为servlet,jdbc,oracle实现的数据库增删改查处理; 功能包含有分页查询,jquery日历控件; 简单的登陆处理页面; 数据库存数据时,密码采用MD5 32位小写加密保存 注:ie浏览器下能够正常显示样式,...
分页查询分页查询
自己学习时候写的, 下载了注意添加Jar包就OK. 数据库很简单, 看User类就OK. 连数据库 自己修改一下DBConn类里面的 连接地址.