JDBC操作Oracle数据库(增删改查详细实例教程)

《JDBC操作Oracle数据库(增删改查详细实例教程)》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、JDBC操作Oracle数据库(增删改查详细实例教程)实体类Person.javaJava代码 packagecom.connect.t01.vo;/***值对象，包含属性，setter，getter方法**@desc*@authorzzw*@data2013-11-20*@time上午09:42:48*/publicclassPerson{privateStringid;privateStringname;privateStringpassword;privateintage;privateStringemail;//生成getter、sette

2、r方法publicvoidsetId(Stringid){this.id=id;}publicvoidsetName(Stringname){this.name=name;}publicvoidsetPassword(Stringpassword){this.password=password;}publicvoidsetAge(intage){this.age=age;}publicvoidsetEmail(Stringemail){this.email=email;}publicStringgetId(){returnthis.id;}publ

3、icStringgetName(){returnthis.name;}publicStringgetPassword(){returnthis.password;}publicintgetAge(){returnthis.age;}publicStringgetEmail(){returnthis.email;}@OverridepublicStringtoString(){return"Person[age="+age+",email="+email+",id="+id+",name="+name+",password="+password+"]

4、";}}工厂列DAOFactory.java Java代码 packagecom.connect.t01.factory;importcom.connect.t01.dao.PersonDAO;importcom.connect.t01.dao.PersonDAOImpl;publicclassDAOFactory{publicstaticPersonDAOgetPersonDAOInstance(){returnnewPersonDAOImpl();}};抽象类PersonDAO.javaJava代码  packagecom.connect.t0

5、1.dao;importjava.util.*;importcom.connect.t01.vo.Person;//规定出了操作person表在此项目里的全部方法publicinterfacePersonDAO{//增加操作publicvoidinsert(Personperson)throwsException;//修改操作publicvoidupdate(Personperson)throwsException;//删除操作publicvoiddelete(Stringid)throwsException;//按ID查询操作publicPers

6、onqueryById(Stringid)throwsException;//查询全部publicListqueryAll()throwsException;//模糊查询publicListqueryByLike(Stringcond)throwsException;}抽象类的实现PersonDAOImpl.javaJava代码packagecom.connect.t01.dao;importjava.sql.*;importjava.util.*;importcom.connect.t01.db.DataBaseConnection;import

7、com.connect.t01.vo.Person;//此类需要完成具体的数据库操作，需要JDBC代码publicclassPersonDAOImplimplementsPersonDAO{//增加操作publicvoidinsert(Personperson)throwsException{Stringsql="INSERTINTOperson(id,name,password,age,email)VALUES(?,?,?,?,?)";PreparedStatementpstmt=null;DataBaseConnectiondbc=null;/

8、/下面是针对数据库的具体操作try{//连接数据库dbc=newDataBaseConnection();pstmt=db