li_chuansong
发贴: 55
积分: 21
|
于 2003-07-22 12:52
1.通过oracle自带的jdbc即thin方法 须在weblogic下startWebLogic.cmd中set CLASSPATH=下加入oracle/jdbc驱动classes12.jar // 建立数据库的连接 // package com.yourCompany.yourApp; package db_beans; import javax.sql.DataSource; import javax.naming.*; import java.lang.*; import java.sql.*; import java.io.*; import java.util.*; public class connect_db_oracle{ public Connection con = null; public ResultSet ret=null; public Statement stmt=null; //此连接为采用oracle的jdbc直连接 public connect_db_oracle(){ try{ String dbdrive = "oracle.jdbc.driver.OracleDriver"; String dburl = "jdbc:oracle:thin:@qdgs-lcs-note:1521:study"; String userName = "cygs"; String pass = "cygs"; try{ DriverManager.registerDriver((java.sql.Driver)Class.forName(dbdrive).newInstance()); con= DriverManager.getConnection(dburl, userName, pass); }catch(Exception e){ System.out.println(e.getMessage()+e.toString()); } }catch(Exception ex){ ex.printStackTrace(); System.out.print(ex.toString()); return; } } //执行select语句,并返回结果集 public ResultSet execsql(String sql){ try { stmt=con.createStatement(); ret = stmt.executeQuery(sql); }catch(Exception e){ e.printStackTrace(); System.out.println(e.toString()); } return ret; } //执行insert,update,delete,ddl等,返回结果数或0 public int execupdate(String sql){ int recount=0; try { stmt=con.createStatement(); recount = stmt.executeUpdate(sql); }catch(Exception e){ e.printStackTrace(); System.out.println(e.toString()); } return recount; } //关闭打开的内容 public void closecon(){ try{ if (ret != null){ ret.close(); } if (stmt != null){ stmt.close(); } if (con != null){ con.close(); } }catch(Exception ex){ ex.printStackTrace(); } } }
九佰 edited on 2003-07-24 10:39
|