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);
	}

}