/**
*
*/
package com.umcservice.test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import org.apache.log4j.Logger;
/**
* @ClassName: test
* @Description: TODO
* @author: szj
* @date: 2018年9月27日 上午11:21:04
*/
public class test {
private Logger logger = Logger.getLogger(test.class);
public static void main(String[] args) throws ClassNotFoundException, SQLException {
//注册驱动,反射方式加载
Class.forName("oracle.jdbc.driver.OracleDriver");
//设置url
String url = "jdbc:oracle:thin:@127.0.0.1:1521:Test";
//设置用户名
String username = "root";
//设置用户密码
String password = "root";
//获得链接对象
Connection conn = DriverManager.getConnection(url, username, password);
//获得执行者对象
String sql = "select * from userPhone";
PreparedStatement pr = conn.prepareStatement(sql);
//获得结果集
ResultSet rs = pr.executeQuery();
//获得结果集处理
while(rs.next()){
System.out.println("遍历结果打印结果!");
}
//释放资源
rs.close();
pr.close();
conn.close();
}
}
oracle原生JDBC访问数据库
最新推荐文章于 2023-01-13 15:08:13 发布