Java连接Oracle数据库
将以一个小例子说明Java连接、查询Oracle数据库的过程。在本例子中使用的是Oracle 11g的数据库。首先确保Oracle安装成功,这里不再叙述安装过程。
工程目录
导入JAR包
将Oracle安装路径下的几个jar包导入到工程中,如我的JAR路径为D:\database\db_2\jdbc\lib。
- DBUtils.java
DBUtils.java是连接数据库的工具类
package com.cug.test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DBUtils {
private static final String driverUrl = "oracle.jdbc.driver.OracleDriver";
private static final String url = "jdbc:oracle:thin:@59.71.244.71:1521:ORCL";
private static final String username = "SSUSER"; //数据库用户名
private static final String password = "1234"; //密码
public static Connection getConnection(){
Connection connection = null;
try {
Class.forName(driverUrl);
connection = DriverManager.getConnection(url, username, password);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
System.out.println("连接成功!");
return connection;
}
}
- DBTest.java
package com.cug.test;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DBTest {
public static void main(String[] args) {
// TODO Auto-generated method stub
Statement stmt = null;
ResultSet res = null;
Connection conn = null;
String sql = " select * from SS_TESTDATA t";
try {
conn=DBUtils.getConnection();
stmt = conn.createStatement();
res = stmt.executeQuery(sql);
while(res.next())
{
int id = res.getInt("ID");
int age=res.getInt("AGE");
String name = res.getString("NAME");
String sex = res.getString("SEX");
System.out.println("ID:"+id+" NAME:"+name+" AGR:"+age+" SEX:"+sex);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
}
}
}
运行DBTest.java可得结果: