dataconn.java

某高校的门户网站源码

package com.zzx.util;

import java.sql.*;

public class DataConn {

	final String driver = "org.gjt.mm.mysql.Driver";
	final String url = "jdbc:mysql://localhost:3306/sportcollege?useUnicode=true&characterEncoding=GBK";
	final String user = "root";
	final String password = "root";
	static Connection conn = null;

	public DataConn() {
		try {
			Class.forName(driver);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
			System.out.println("驱动类加载失败!");
		}
		try {
			conn = DriverManager.getConnection(url, user, password);
		} catch (SQLException e) {
            e.printStackTrace();
			System.out.println("连接数据库失败!");
		}
	}	

	public Connection getConn() {		
		return conn;
	}
	
	public void closeConn() {
	     try {
			conn.close();
		} catch (SQLException e) {
			System.out.println("database can not close successfully !");
		}
	}
}