jdbcutil.java

很多学校

package com.tarena.util;

import java.sql.*;
import javax.naming.*;
import javax.sql.DataSource;

public class JdbcUtil
{
    public static Connection getConnection()
    {
        try
        {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            return DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.23:1521:tarena", "openlab", "open123");
        }catch(ClassNotFoundException e)
        {
            System.out.println("can not load class :" + "oracle.jdbc.driver.OracleDriver");
            throw new RuntimeException(e.getMessage());
        }catch(SQLException e)
        {
            e.printStackTrace();
            throw new RuntimeException(e.getMessage());
        }
    }
    
  
    
    public static void close(ResultSet rs, Statement st, Connection con)
    {
        try
        {
            rs.close();
        }catch(Exception e)
        {
        }
        
        close(st, con);
    }
    
    public static void close(Statement st, Connection con)
    {        
        try
        {
            st.close();
        }catch(Exception e)
        {
        }
        
        try
        {
            con.close();
        }catch(Exception e)
        {
        }
    }
    public static void release(ResultSet rs,Statement st,Connection con){
		try {
			rs.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		try {
			st.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		try {
			con.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	
	public static void printRs(ResultSet rs){
		  if(rs==null) return;
		  try{
		   ResultSetMetaData md = rs.getMetaData();
		   int num = md.getColumnCount();
		   StringBuffer sb = new StringBuffer();
		   for(int i=1;i<=num;i++){
		    int size = md.getColumnDisplaySize(i);
			if(size!=0){
			  String cname = md.getColumnName(i);
			  int blank = (size-cname.length())/2;
			  for(int j=0;j<blank;j++) sb.append(" ");
			  sb.append(cname);
			  if((size-cname.length())%2!=0) blank++;
			  for(int j=0;j<blank;j++) sb.append(" ");
		    }
		   }
		   sb.append("\n");
		   while(rs.next()){
		    for(int i=1;i<=num;i++){
		       int size = md.getColumnDisplaySize(i);
			   if(size!=0){
			     String value = rs.getString(i);
			     int blank = (size-value.length())/2;
			     for(int j=0;j<blank;j++) sb.append(" ");
			     sb.append(value);
			     if((size-value.length())%2!=0) blank++;
			     for(int j=0;j<blank;j++) sb.append(" ");
		       }
			}
			sb.append("\n");
		   }
		   System.out.println(sb.toString());
		  }catch(Exception e){
		   e.printStackTrace();
		  }
		}
}