java oracle jdbc_Java JDBC连接Oracle

1. 安装Oracle数据库，我这里使用的是Oracle 12c

2. 创建Java工程 connection-oracle

注意：使用的JavaSE-1.8

3. 在Oracle的安装目录里，将djdbc8.jar 拷贝到java工程

路径为：C:\app\oracle\product\12.2.0\dbhome_1\jdbc\lib

4. 创建连接Oracle的java类

public class OracleJdbcTest {

//数据库连接对象

private static Connection conn = null;

private static String driver = "oracle.jdbc.driver.OracleDriver"; //驱动

private static String url = "jdbc:oracle:thin:@//127.0.0.1:1521/orcl"; //连接字符串

private static String username = "system"; //用户名

private static String password = "123456"; //密码

// 获得连接对象

private static synchronized Connection getConn(){

if(conn == null){

try {

Class.forName(driver);

conn = DriverManager.getConnection(url, username, password);

} catch (ClassNotFoundException e) {

e.printStackTrace();

}catch (SQLException e) {

e.printStackTrace();

}

}

return conn;

}

//执行查询语句

public void query(String sql, boolean isSelect) throws SQLException{

PreparedStatement pstmt;

try {

pstmt = getConn().prepareStatement(sql);

//建立一个结果集，用来保存查询出来的结果

ResultSet rs = pstmt.executeQuery();

while (rs.next()) {

String name = rs.getString("name");

System.out.println(name);

}

rs.close();

pstmt.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

public void query(String sql) throws SQLException{

PreparedStatement pstmt;

pstmt = getConn().prepareStatement(sql);

pstmt.execute();

pstmt.close();

}

//关闭连接

public void close(){

try {

getConn().close();

} catch (SQLException e) {

e.printStackTrace();

}

}

}

5. 创建调用类

public class ConnOracle {

public static void main(String[] args) throws SQLException {

OracleJdbcTest test = new OracleJdbcTest();

try {

test.query("drop table student");

} catch (SQLException e) {}

test.query("create table student(id int, name nchar(20))");

test.query("insert into student values(1,'zhangsan')");

test.query("insert into student values(2,'lisi')");

test.query("select * from student", true);

test.close();

}

}

6. 显示结果