dbconnection.java

一个很好的BBS论坛项目

package com.ibm.common;

import java.sql.*;

public class DBConnection {
	private Connection conn;
	private static DBConnection dbcon;
	private DBConnection()
	{
		
	}
	
	public static DBConnection getInstance() {
		if(dbcon==null) 
		{
			dbcon = new DBConnection();
		}
		return dbcon;
	}
	
	public Connection getConnection()
	{
		try{
			Class.forName("com.mysql.jdbc.Driver");
			conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/bbs","root","admin");
			System.out.println("数据库连接成功");
			
		}
		catch(Exception e)
		{
			System.out.println("数据库连接失败！");
		}
		return conn;
	}
	
	public void close(Statement s,PreparedStatement ps,CallableStatement cs,Connection conn)
	{
		if(s!=null)
		{
			try {
				s.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		
		if(ps!=null)
		{
			try {
				ps.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		
		if(cs!=null)
		{
			try {
				cs.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		
		if(conn!=null)
		{
			try {
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
}