Oracle数据库封装

最新推荐文章于 2022-12-30 21:27:44 发布

weixin_44793200

最新推荐文章于 2022-12-30 21:27:44 发布

阅读量317

点赞数

分类专栏：大数据

本文链接：https://blog.csdn.net/weixin_44793200/article/details/89499057

版权

大数据专栏收录该内容

2 篇文章 0 订阅

订阅专栏

public class Dbutil {
	 
	 public Connection getConnection(){
			Connection conn=null;
			String i="oracle.jdbc.driver.OracleDriver";
			 	String a="jdbc:oracle:thin:@localhost:1521:orcl";
					String b ="scott";
			  	String bb="tiger";
			  	try {
			  		System.out.println("************");
					Class.forName(i);
					conn=DriverManager.getConnection(a,b,bb);
				} catch (ClassNotFoundException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}

			
			return conn;
			
	 }
	
	 public void close(ResultSet rs,PreparedStatement s,Connection conn)  {

			
			try {
				if (rs!=null) {
					rs.close();
				}
				
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			try {
				if (s!=null) {
					s.close();
				}
				
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			try {
				if (conn!=null) {
					conn.close();
				}
				
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			
		}

}