import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
/**
*
* @author spirit_fly
* oracle连接数据库
*/
public class OracleJDBC {
//这里需要加上oracle的jar包
private final static String oracleDriverName = "oracle.jdbc.driver.OracleDriver";
private final static String URL = "jdbc:oracle:thin:@localhost:1521:yangrs"; //yangrs是全局数据库
private final static String USERNAME = "scott"; //使用默认的用户名
private final static String PASSWORD = "tiger";
private static Connection conn = null;
static PreparedStatement pstmt = null;
static ResultSet rs = null;
// 打开连接
public static Connection getCon() {
try {
Class.forName(oracleDriverName);
conn = DriverManager.getConnection(URL, USERNAME, PASSWORD);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
// 关闭连接
public static void closeCon() {
if(conn!=null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
// 关闭PreparedStatement
public void closepstmt() {
if (pstmt != null) {
try {
pstmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
//关闭ResultSet
public static void closeRs() {
if(rs !=null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
/**
* 测试连接,查询emp表
* @param args
*/
public static void main(String[] args) {
String sql = "select * from emp";
try {
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
System.out.println(rs.getString(1)+rs.getString(2)+rs.getString(3));
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
//最后关闭连接
closeRs();
closeCon();
}
}
}
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
/**
*
* @author spirit_fly
* oracle连接数据库
*/
public class OracleJDBC {
//这里需要加上oracle的jar包
private final static String oracleDriverName = "oracle.jdbc.driver.OracleDriver";
private final static String URL = "jdbc:oracle:thin:@localhost:1521:yangrs"; //yangrs是全局数据库
private final static String USERNAME = "scott"; //使用默认的用户名
private final static String PASSWORD = "tiger";
private static Connection conn = null;
static PreparedStatement pstmt = null;
static ResultSet rs = null;
// 打开连接
public static Connection getCon() {
try {
Class.forName(oracleDriverName);
conn = DriverManager.getConnection(URL, USERNAME, PASSWORD);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
// 关闭连接
public static void closeCon() {
if(conn!=null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
// 关闭PreparedStatement
public void closepstmt() {
if (pstmt != null) {
try {
pstmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
//关闭ResultSet
public static void closeRs() {
if(rs !=null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
/**
* 测试连接,查询emp表
* @param args
*/
public static void main(String[] args) {
String sql = "select * from emp";
try {
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
System.out.println(rs.getString(1)+rs.getString(2)+rs.getString(3));
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
//最后关闭连接
closeRs();
closeCon();
}
}
}