basicservice.java

来自「java带进度条上传尽量不要让站长把时间都花费在为您修正说明上」· Java 代码 · 共 40 行

package com.jmwl.biz;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

import com.jmwl.common.BlogException;

public class BasicService {

	protected Connection conn = null;

	
	public Connection getConn() throws BlogException
	{
		try {
			Class.forName("com.mysql.jdbc.Driver");
			conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/blog", "root", "yinhe");
		} catch (ClassNotFoundException e) {
			throw new BlogException("对不起，mysql驱动没有找到");
		} catch (SQLException e) {
			throw new BlogException("对不起，连接数据库的地址或者密码错误");
		}
		return conn;
	}
	
	public void closeConn() throws BlogException
	{
		if(this.conn!=null)
		{
			try {
				this.conn.close();
			} catch (SQLException e) {
				throw new BlogException("对不起，关闭数据库失败");
			}
		}
	}
	
}