connutil.java

来自「sorry i have only one」· Java 代码 · 共 86 行

package cart.util;

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

public class ConnUtil
{
  private static final String CONNECTION_URL="jdbc:oracle:thin:@192.168.0.23:1521:dblab3";
  private static final String CONNECTION_DATABASE_NAME="jd0406";
  private static final String CONNECTION_DATABASE_PASSWORD="jd0406";

  public static Connection getConnection(){
    Connection con=null;
    try{
      Class.forName("oracle.jdbc.driver.OracleDriver");
      con=DriverManager.getConnection(CONNECTION_URL,CONNECTION_DATABASE_NAME,CONNECTION_DATABASE_PASSWORD);
    }catch(Exception e){
      e.printStackTrace();
    }

    return con;
  }

  /*public static Connection getConnection(){
    Connection con=null;
    try{
      Context ctx=new InitialContext();
      DataSource ds=(DataSource)ctx.lookup("java:comp/env/jdbc/apple");
      con=ds.getConnection();
    }catch(Exception e){
      e.printStackTrace();
    }
    return con;
  }*/

  public static void close(Statement st){
    try{
      if(st!=null){st.close();}
    }catch(SQLException e){
      e.printStackTrace();
    }
  }

  public static void close(ResultSet rs){
    try{
      if(rs!=null){rs.close();}
    }catch(SQLException e){
      e.printStackTrace();
    }
  }

  public static void close(Connection con){
    try{
      if(con!=null){con.close();}
    }catch(SQLException e){
      e.printStackTrace();
    }
  }

  public static void close(ResultSet rs,Statement st,Connection con){
    close(st);
    close(rs);
    close(con);
  }

  public static void close(ResultSet rs,Statement st){
    close(st);
    close(rs);
  }

  public static void main(String[] s){
    String sql="select * from products4";
    try{
      Connection con=getConnection();
      Statement stm=con.createStatement();
      ResultSet rs=stm.executeQuery(sql);
      while(rs.next()){
        System.out.println("id="+rs.getInt("id")+",name="+rs.getString("name"));
      }
    }catch(SQLException e){
      e.printStackTrace();
    }
  }
}