jdbc连接oracle数据库功能实例

packagecom.sefvang.jdbc;

importjava.sql.Connection;

importjava.sql.DriverManager;

importjava.sql.PreparedStatement;

importjava.sql.ResultSet;

importjava.sql.SQLException;

publicclassDb_conn {

 privatestaticfinalString url ="jdbc:oracle:thin:@localhost:1521:orcl";

 privatestaticfinalString name ="system";

 privatestaticfinalString passwd ="sefvang";

 privatestaticfinalString Db_driver ="oracle.jdbc.OracleDriver";

 publicConnection getConnection() {

  Connection conn =null;

  try{

   Class.forName(Db_driver);

   conn = DriverManager.getConnection(url, name, passwd);

   if(conn !=null) {

    System.out.println("success!!!");

   }

  }catch(ClassNotFoundException e) {

   // TODO Auto-generated catch block

   e.printStackTrace();

  }catch(SQLException e) {

   // TODO Auto-generated catch block

   e.printStackTrace();

  }

  returnconn;

 }

 publicvoidclose(Connection conn) {

  try{

   if(conn !=null) {

    if(!conn.isClosed()) {

     conn.close();

    }

   }

  }catch(SQLException e) {

   // TODO Auto-generated catch block

   e.printStackTrace();

  }

 }

 publicstaticvoidmain(String[] args) {

  Db_conn conn=newDb_conn();

  Connection con = conn.getConnection();

  try{

   PreparedStatement papt = con.prepareStatement("select tname from text where tid=1");

   ResultSet rs = papt.executeQuery();

   if(rs.next())

   System.out.println(rs.getString(1));

  }catch(SQLException e) {

   // TODO Auto-generated catch block

   e.printStackTrace();

  }

  conn.close(con);

 }

}