《Java程序操作Oracle数据库,的增,删,改,查所有,按ID查,按条件查的封装类》由会员分享,可在线阅读,更多相关《Java程序操作Oracle数据库,的增,删,改,查所有,按ID查,按条件查的封装类(9页珍藏版)》请在金锄头文库上搜索。
1、Java程序操作 Oracle数据库 ,的增,删,改,查所有 ,按 ID 查,按条件查的封装类及 测试数据的方法/这是一个学生类 package entity; publicclass NewStudent private String id ; private String name; private String sex ; privateintage ; privateintminAge =-1; privateintmaxAge =-1; public String getId() returnid ; publicvoid setId(String id) this. id = id
2、; public String getName() returnname; publicvoid setName(String name) this. name = name; public String getSex() returnsex ; publicvoid setSex(String sex) this. sex = sex; publicint getAge() returnage ; publicvoid setAge(int age) this. age = age; publicint getMinAge() returnminAge ; publicvoid setMin
3、Age(int minAge) this. minAge = minAge; publicint getMaxAge() returnmaxAge ; publicvoid setMaxAge(int maxAge) this. maxAge = maxAge; /这是封装好的用于连接和关闭Oracle 数据库的类 package dao; import java.sql.*; publicclass BaseDao /1、-连接 Oracle数据库操作 publicstatic Connection getConnection()throws Exception Class.forName
4、( “oracle.jdbc.driver.OracleDriver“); String url = “jdbc:oracle:thin:127.0.0.1:1521:ORCL“; returnDriverManager.getConnection(url, “SCOTT“ , “admin“); /2、-关闭 Oracle数据库操作 publicstaticvoidclose(ResultSet rs,Statement sta,Connection con) throws Exception if(rs!=null) rs.close(); if(sta!=null) sta.close(
5、); if(con!=null) con.close(); /* * 1、专门针对 NewStudent表操作的数据访问类* 2、最常见的六大方法* 3、增 , 删, 改, 查所有 , 按ID 查, 按条件查。* author NO13 * */ package dao; import java.sql.*; import entity.*; import java.util.*; publicclass NewStudentDao /1、-插入数据的方法publicboolean save(NewStudent obj) Connection con = null; / 预编译操作句柄 Pr
6、eparedStatement psta = null; boolean flag = false; /SQL语句 String sql = “insert into newstudent values(stu_|sq_newstu.nextval,?,?,?)“; try con = BaseDao.getConnection(); /将SQL语句传入进行预编译 psta = con.prepareStatement(sql); /SQL语句里面的 ? 在以下将用对象的里面的属性替换掉 psta.setString(1, obj.getName(); psta.setString(2, ob
7、j.getSex(); psta.setInt(3, obj.getAge(); /判断SQL语句是否执行成功 flag = psta.executeUpdate()0; catch(Exception e) e.printStackTrace(); finally try / 关闭连接 BaseDao.close( null, psta, con); catch(Exception e) e.printStackTrace(); return flag; /2、-修改数据的方法 publicboolean update(NewStudent obj) Connection con = nul
8、l; PreparedStatement psta = null; boolean flag = false; String sql = “update newstudent set name=?,sex=?,age=? where id=?“; try con = BaseDao.getConnection(); /将SQL语句传入进行预编译 psta = con.prepareStatement(sql); /SQL语句里面的 ? 在以下将用对象的里面的属性替换掉 psta.setString(1, obj.getName(); psta.setString(2, obj.getSex()
9、; psta.setInt(3, obj.getAge(); psta.setString(4, obj.getId(); /判断SQL语句是否执行成功 flag = psta.executeUpdate()0; catch(Exception e) e.printStackTrace(); finally try BaseDao.close( null, psta, con); catch(Exception e) e.printStackTrace(); return flag; /3、-删除数据的方法 publicboolean remove(String id) Connection
10、con = null; PreparedStatement psta = null; boolean flag = false; String sql = “delete from newstudent where id = ?“; try con = BaseDao.getConnection(); psta = con.prepareStatement(sql); psta.setString(1, id); flag = psta.executeUpdate()0; catch(Exception e) e.printStackTrace(); finally try BaseDao.c
11、lose( null, psta, con); catch(Exception e) e.printStackTrace(); return flag; /4、-*-查询所有数据的方法 public ArrayList findAll() Connection con = null; PreparedStatement psta = null; ResultSet rs = null; String sql = “select * from newstudent“; ArrayList list = new ArrayList(); try con = BaseDao.getConnectio
12、n(); psta = con.prepareStatement(sql); rs = psta.executeQuery(); while(rs.next() NewStudent obj = new NewStudent(); obj.setId(rs.getString(1); obj.setName(rs.getString(2); obj.setSex(rs.getString(3); obj.setAge(rs.getInt(4); list.add(obj); catch(Exception e) e.printStackTrace(); finally try / 关闭 Ora
13、cle连接 BaseDao.close(rs, psta, con); catch(Exception e) e.printStackTrace(); return list; /5、-*-按ID 查询数据的方法 public NewStudent findById(String id) Connection con = null; PreparedStatement psta = null; ResultSet rs = null; String sql = “select * from newstudent where id = ?“; NewStudent obj = null; try
14、 con = BaseDao.getConnection(); psta = con.prepareStatement(sql); psta.setString(1, id); rs = psta.executeQuery(); if(rs.next() obj = new NewStudent(); obj.setId(rs.getString(1); obj.setName(rs.getString(2); obj.setSex(rs.getString(3); obj.setAge(rs.getInt(4); catch(Exception e) e.printStackTrace();
15、 finally try BaseDao.close(rs, psta, con); catch(Exception e) e.printStackTrace(); return obj; /6、-*-按条件查询数据的方法 public ArrayList findByWhere(NewStudent param) Connection con = null; PreparedStatement psta = null; ResultSet rs = null; ArrayList list = new ArrayList(); ArrayList params = new ArrayList(); String sql = “select * from newstudent where 1=1“; if(param.getId()!=null) sql = sql + “ and id=?“; params.add(param.getId(); if(param.getName()!=null) sql = sql + “ and name