《jdbc操作oracle数据库(增删改查)》.docx

 HYPERLINK /blog/321535 jdbc操作oracle数据库(增删改查) 博客分类：?  HYPERLINK /category/47627 JAVA积累  HYPERLINK /blogs/tag/SQL SQL HYPERLINK /blogs/tag/Oracle Oracle HYPERLINK /blogs/tag/JDBC JDBC HYPERLINK /blogs/tag/DAO DAO DAOFactory.java Java代码 package?cn.mldn.lxh.factory?;?? ?? import?cn.mldn.lxh.dao.*?;?? import?cn.mldn.lxh.dao.impl.*?;?? ?? public?class?DAOFactory?? {?? ????public?static?PersonDAO?getPersonDAOInstance()?? ????{?? ????????return?new?PersonDAOImpl()?;?? ????}?? };?? ? DataBaseConnection.java Java代码?? package?cn.mldn.lxh.dbc?;?? import?java.sql.*?;?? ?? //?主要功能就是连接数据库、关闭数据库?? public?class?DataBaseConnection?? {?? ????private?final?String?DBDRIVER?=?oracle.jdbc.driver.OracleDriver?;?? ????private?final?String?DBURL?=?jdbc:oracle:thin:@localhost:1521:MLDN?;?? ????private?final?String?DBUSER?=?scott?;?? ????private?final?String?DBPASSWORD?=?tiger?;?? ????private?Connection?conn?=?null?;?? ?? ????public?DataBaseConnection()?? ????{?? ????????try?? ????????{?? ????????????Class.forName(DBDRIVER)?;?? ????????????this.conn?=?DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD)?;???? ????????}?? ????????catch?(Exception?e)?? ????????{?? ????????}?? ????}?? ?? ????//?取得数据库连接?? ????public?Connection?getConnection()?? ????{?? ????????return?this.conn?;?? ????}?? ?? ????//?关闭数据库连接?? ????public?void?close()?? ????{?? ????????try?? ????????{?? ????????????this.conn.close()?;?? ????????}?? ????????catch?(Exception?e)?? ????????{?? ????????}????????? ????}?? };?? ? Person.java Java代码?? package?cn.mldn.lxh.vo?;?? ?? //?值对象，包含属性，setter，getter方法?? public?class?Person?? {?? ????private?String?id?;?? ????private?String?name?;?? ????private?String?password?;?? ????private?int?age?;?? ????private?String?email?;?? ?? ????//?生成getter、setter方法?? ????public?void?setId(String?id)?? ????{?? ????????this.id?=?id?;?? ????}?? ????public?void?setName(String?name)?? ????{?? ?????????=?name?;?? ????}?? ????public?void?setPassword(String?password)?? ????{?? ????????this.passwo