【数据库】JDBC工具类

package com.yinhai.util;
 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;
 
public class JdbcUtil
{
    static{
      String driver = "oracle.jdbc.driver.OracleDriver";
      try{
        Class.forName(driver);
      }catch(Exception e){
        e.printStackTrace();
      }
    }
    public static Connection getConnection(){
      String url = 
        "jdbc:oracle:thin:@192.192.192.239:1521:orcl";
      String usr = "xajgyl";
      String pwd = "xajgyl";
      Connection con = null;
      try{
        con = DriverManager.getConnection(url,usr,pwd);
      }catch(Exception e){
        e.printStackTrace();
      }
      return con;
    }
    public static void close(ResultSet rs, Statement stmt,Connection con){
       try{
          if(rs!=null) rs.close();
        }catch(Exception ex){
          ex.printStackTrace();
        }
        try{
          if(stmt!=null) stmt.close();
        }catch(Exception ex){
          ex.printStackTrace();
        }
        try{
          if(con!=null) con.close();
        }catch(Exception ex){
          ex.printStackTrace();
        }
    }
}