创意电子

标题: JDBC连接oracle数据库步骤 [打印本页]

作者: 黑马程序员 时间: 2021-8-11 10:57
标题: JDBC连接oracle数据库步骤
(一)创建工程，引入驱动包

在下图目次中可以找到驱动包ORACLE的JDBC驱动包，拷贝到工程即可使用

创建java工程waterboss，建立lib文件夹，将ojdbc.jar拷贝到此文件夹，然后add build path

(二)BaseDao

我们通常编写BaseDao负责加载驱动，获取数据库连接，关闭资源，代码如下：
package cn.itcast.waterboss.dao;import java.sql.SQLException;/** * 根本数据访问类 * @author Administrator * */public class BaseDao {  //加载驱动  static { try {    Class.forName("oracle.jdbc.driver.OracleDriver"); } catch (ClassNotFoundException e) {    e.printStackTrace(); }  }  /** * 获取数据库连接 * @return * @throws SQLException */  public static java.sql.Connection getConnection() throws SQLException { return java.sql.DriverManager.getConnection(    "jdbc:oracle:thin:@192.168.80.10:1521:orcl",    "wateruser",    "itcast" );  }  /** * 关闭资源 * @param rs * @param stmt * @param conn */  public static void closeAll( java.sql.ResultSet rs, java.sql.Statement stmt, java.sql.Connection conn  ) { //关闭结果集 if (rs != null) {    try {       rs.close();    } catch (SQLException e) {       e.printStackTrace();    } } //关闭执行对象 if (stmt != null) {    try {       stmt.close();    } catch (SQLException e) {       e.printStackTrace();    } } //关闭执行对象 if (conn != null) {    try {       conn.close();    } catch (SQLException e) {       e.printStackTrace();    } }  }}JDBC驱动为：
oracle.jdbc.OracleDriver
连接字符串( 瘦连接 )：
jdbc:oracle:thin:@虚拟机的 IP:1521:orcl
(三)业主增编削代码编写

1.创建实体类
package cn.itcast.waterboss.entity;import java.util.Date;/** * 业主实体类 * @author Administrator * */public class Owners {  private Long id; //编号  private String name; //业主名称  private Long addressid; //地址编号  private String housenumber; //门牌号  private String watermeter; //水表编号  private Date adddate; //登记日期  private Long ownertypeid; //业主类型 ID  public Long getId() { return id;  }  public void setId(Long id) { this.id = id;  }  public String getName() { return name;  }  public void setName(String name) { this.name = name;  }  public Long getAddressid() { return addressid;  }  public void setAddressid(Long addressid) { this.addressid = addressid;  }  public String getHousenumber() { return housenumber;  }  public void setHousenumber(String housenumber) { this.housenumber = housenumber;  }  public String getWatermeter() { return watermeter;  }  public void setWatermeter(String watermeter) { this.watermeter = watermeter;  }  public Date getAdddate() { return adddate;  }  public void setAdddate(Date adddate) { this.adddate = adddate;  }  public Long getOwnertypeid() { return ownertypeid;  }  public void setOwnertypeid(Long ownertypeid) { this.ownertypeid = ownertypeid;  }}2.创建Dao类实现增编削
package cn.itcast.waterboss.dao;import cn.itcast.waterboss.entity.Owners;import java.sql.SQLException;/** * 业主数据访问类 * @author Administrator * */public class OwnersDao {  /** * 新增业主 * @param owners */  public static void add(Owners owners) { java.sql.Connection conn = null; java.sql.PreparedStatement stmt = null; try {    conn = BaseDao.getConnection();    stmt =       conn.prepareStatement("insert into T_OWNERS values(?,?,?,?,?,?,?)");    stmt.setLong(1, owners.getId());    stmt.setString(2, owners.getName());    stmt.setLong(3, owners.getAddressid());    stmt.setString(4, owners.getHousenumber());    stmt.setString(5, owners.getWatermeter());    stmt.setDate(6, new java.sql.Date(owners.getAdddate().getTime()));    stmt.setLong(7, owners.getOwnertypeid());    stmt.execute(); } catch (SQLException e) {    e.printStackTrace(); } finally {    BaseDao.closeAll(null, stmt, conn); }  }  /** * 修改业主 * @param owners */  public static void update(Owners owners) { java.sql.Connection conn = null; java.sql.PreparedStatement stmt = null; try {    conn = BaseDao.getConnection();    stmt =       conn.prepareStatement(       "update T_OWNERS set    name=?,addressid=?,housenumber=?," +       "watermeter=?,adddate=?, ownertypeid=? where    id=?"       );    stmt.setString(1, owners.getName());    stmt.setLong(2, owners.getAddressid());    stmt.setString(3, owners.getHousenumber());    stmt.setString(4, owners.getWatermeter());    stmt.setDate(5, new java.sql.Date(owners.getAdddate().getTime()));    stmt.setLong(6, owners.getOwnertypeid());    stmt.setLong(7, owners.getId());    stmt.execute(); } catch (SQLException e) {    e.printStackTrace(); } finally {    BaseDao.closeAll(null, stmt, conn); }  }  /** * 删除业主 * @param owners */  public static void delete(Long id) { java.sql.Connection conn = null; java.sql.PreparedStatement stmt = null; try {    conn = BaseDao.getConnection();    stmt = conn.prepareStatement("delete from T_OWNERS where id=?");    stmt.setLong(1, id);    stmt.execute(); } catch (SQLException e) {    e.printStackTrace(); } finally {    BaseDao.closeAll(null, stmt, conn); }  }}

作者: 网事2008 时间: 2021-8-12 07:06
转发了

作者: 宇过添情58828478 时间: 2021-8-12 17:11
还可以再封装一下，动态传递参数，让查询返回list《map》修改返回记录数

欢迎光临创意电子 (https://wxcydz.cc/)