JDBC工具类代码,Java代码库,德仔网

代码语言

代码分类

【Java】 JDBC工具类

作者:liudanlinux / 发布于2013/10/24/ 590


	package com.jsu.liudan;
	
	import java.io.InputStream;
	import java.sql.Connection;
	import java.sql.DriverManager;
	import java.sql.ResultSet;
	import java.sql.SQLException;
	import java.sql.Statement;
	import java.util.Properties;
	
	
	public class JDBCFactory {
	 //定义连接数据库所需要的字段
	 private static String driveClassName = null;
	 private static String url = null;
	 private static String username = null;
	 private static String password = null;
	 //通过配置文件为以上字段赋值
	 static{
	 try {
	 InputStream in = JDBCFactory.class.getClassLoader().getResourceAsStream("dbcfg.properties");
	 Properties prop = new Properties();
	 prop.load(in);
	 driveClassName = prop.getProperty("className");
	 url = prop.getProperty("url");
	 username = prop.getProperty("username");
	 password = prop.getProperty("password");
	 //加载驱动类
	 Class.forName(driveClassName);
	 } catch (Exception e) {
	 throw new RuntimeException("Can't find the properties!");
	 }
	 }
	 //得到连接
	 public static Connection getConnection() throws SQLException {
	 return DriverManager.getConnection(url,username,password);
	 }
	 //释放资源
	 public static void release(ResultSet rs,Statement stmt,Connection conn) {
	 if(rs != null) {
	 try{
	 rs.close();
	 }catch(Exception e){} //ignore
	 rs = null;
	 }
	 if(stmt != null) {
	 try{
	 stmt.close();
	 }catch(Exception e){} //ignore
	 stmt = null;
	 }
	 if(conn != null) {
	 try {
	 conn.close();
	 }catch(Exception e){} //ignore
	 }
	
	 }
	
	}

试试其它关键字

　JDBC　

同语言下

可能有用的

liudanlinux贡献的其它代码(1)

.JDBC工具类