JDBC连接数据库的工具包代码

JDBC连接数据库的工具包代码

package donghongyu.tk.news.util;

import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
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 JdbcUtil {
	private  static Connection conn;

	private JdbcUtil() {
		super();
		// TODO Auto-generated constructor stub
	}

	//返回连接对象
	public  static synchronized Connection getConn() {
		if (conn == null) {
			try {
				// 加载驱动文件 
				
				Class.forName("com.mysql.jdbc.Driver");
				// 将属性文件加载
				File file = new File("src/jdbc.properties");
				// 将文件转化为输入流
				InputStream is = new FileInputStream(file);
				// 创建属性对象
				Properties prop = new Properties();
				// 将属性流加载到属性对象中
				prop.load(is);

				// 创建连接从属性文件取出相应值连接
				conn = DriverManager.getConnection(prop.getProperty("url"),
						prop.getProperty("user"), prop.getProperty("pass"));

			} catch (ClassNotFoundException | IOException | SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}

		return conn;
	}

	
	//关闭资源就行释放
	public static void release(Statement pstmt, ResultSet rs) {
		if (rs != null) {
			try {
				rs.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		if (pstmt != null) {
			try {
				pstmt.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}

}