dbcon.java

用mysql

package com.wenhua.ser.base;

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

public class Dbcon {

	private Connection con;

	private String url;

	private String user;

	private String password;

	public void dbconnect() {
		
		url = "jdbc:mysql://localhost:3306/test";
		user = "root";
		password = "123";
		
		try {

			// 第一步 ，导入驱动程序
			Class.forName("com.mysql.jdbc.Driver");
			// 从DriverManager中获得数据库连接对象
			con = DriverManager.getConnection(url, user, password);
			
			System.out.println("连接成功！");

		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	
	public Connection getCon()
	{
		if(con == null)
		{
			this.dbconnect();
		}
		return con;
	}
	
	public void closeCon(Connection con)
	{
		try {
			if(con != null)
			{
				con.close();
				con = null;
			}			
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	
}