jdbc连接oracle数据库功能示例

package com.sefvang.jdbc;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;public class Db_conn { private static final String url = "jdbc:oracle:thin:@localhost:1521:orcl"; private static final String name = "system"; private static final String passwd = "sefvang"; private static final String Db_driver = "oracle.jdbc.OracleDriver"; public Connection 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();  }  return conn; } public void close(Connection conn) {  try {   if (conn != null) {    if (!conn.isClosed()) {     conn.close();    }   }  } catch (SQLException e) {   // TODO Auto-generated catch block   e.printStackTrace();  } } public static void main(String[] args) {  Db_conn conn=new Db_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); }}