oracle-jdbc

最新推荐文章于 2022-11-30 11:09:25 发布

firedinner

最新推荐文章于 2022-11-30 11:09:25 发布

阅读量407

点赞数

本文链接：https://blog.csdn.net/firedinner/article/details/28701649

版权

bak 专栏收录该内容

60 篇文章 0 订阅

订阅专栏

1.附加jar包

1）Build Path -> Configure Build Path...

public static void main(String[] args) {
		//定义变量
		Connection ct = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		try{
			//1.加载驱动
			Class.forName("oracle.jdbc.driver.OracleDriver");
			//2.得到连接
			ct=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:susan","scott","scott");
			//3.创建PreparedStatement的接口引用对象
			ps=ct.prepareStatement("select * from emp");
			System.out.println(ps);
			//4.完成查询
			rs=ps.executeQuery();
			//5.循环输出结果
			while(rs.next()){
				System.out.println(rs.getString(2));				
			}
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			//关闭资源
			if(rs!=null){
				try {
					rs.close();
				} catch (Exception e2) {
					// TODO: handle exception
				}
				rs=null;
			}
			if(ps!=null){
				try {
					ps.close();
				} catch (Exception e3) {
					// TODO: handle exception
				}
				ps=null;
			}
			if(ct!=null){
				try {
					ct.close();
				} catch (Exception e2) {
					// TODO: handle exception
				}
				ct=null;
			}
		}
	}