jdbcutil.java

加拿大达内科技有限公司配需java程序员的上课时的代码

package com.tarena.bank.persist;
import java.sql.*;

public class JdbcUtil
{
	//加载驱动、创建连接、释放资源
	static{
	  String d = 
		"oracle.jdbc.driver.OracleDriver";
	  try{
	    Class.forName(d);
	  }catch(Exception e){
	    e.printStackTrace();
	  }
	}
    public static Connection getConnection(){
	  String url = 
		"jdbc:oracle:thin:@192.168.0.23:1521:tarena";
	  String username = "openlab";
	  String pwd = "open123";
	  Connection con = null;
	  try{
	    con = DriverManager.getConnection(url,username,pwd);
	  }catch(Exception e){
	    e.printStackTrace();
	  }
	  return con;
	}
    public static void release(
	  ResultSet rs,Statement stmt,Connection con){
	  if(rs!=null){
	    try{
		  rs.close();
		}catch(Exception e){
		  e.printStackTrace();
		}
	  }
	  if(stmt!=null){
	    try{
		  stmt.close();
		}catch(Exception e){
		  e.printStackTrace();
		}
	  }
	  if(con!=null){
	    try{
		  con.close();
		}catch(Exception e){
		  e.printStackTrace();
		}
	  }
	}
    public static void release(Object o){
	  try{
	    if(o instanceof ResultSet){
	      ((ResultSet)o).close();
	    }else if(o instanceof Statement){
	      ((Statement)o).close();
	    }else if(o instanceof Connection){
	      ((Connection)o).close();
	    }
	  }catch(Exception e){
	    e.printStackTrace();
	  }
	}
	public static void printRs(ResultSet rs){
	  if(rs==null) {
	      System.out.println("rs is null");
		  return;
	  }
	  try{
	    ResultSetMetaData md = rs.getMetaData();
	    int colnum = md.getColumnCount();
	    StringBuffer sb = new StringBuffer();
	    while(rs.next()){
	      for(int i=1;i<=colnum;i++){
		    sb.append(md.getColumnName(i));
		    sb.append("="+rs.getString(i)+"  ");
		  }
		  sb.append("\n");
	    }
	    System.out.println(sb.toString());
	  }catch(Exception e){
	    e.printStackTrace();
	  }
	}


}