jdbc连接orcle数据库_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);

}

}