使用ojdbc进行连接
//加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//获取连接
conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:服务器名", 用户名, 密码);
打开命令行查看服务器名称
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;public class ConnOrcl {
public static void main(String[] args) {
Connection conn = null;
PreparedStatement statement = null;
ResultSet resultSet = null;
try {
//加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//获取连接
conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ORCL", "scott", "Oracle11");
//准备sql语句
statement = conn.prepareStatement("select * from emp");
resultSet = statement.executeQuery();
while(resultSet.next()) {
System.out.println("用户名:" + resultSet.getString(1));
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
if(resultSet != null) {
try {
resultSet.close();
} catch (Exception e2) {
// TODO: handle exception
}
}
if(statement != null) {
try {
resultSet.close();
} catch (Exception e2) {
// TODO: handle exception
}
}
if(conn != null) {
try {
resultSet.close();
} catch (Exception e2) {
// TODO: handle exception
}
}
}
}
}