package com.zzx.struts.dbc;

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

public class DataConn {

	final String driver = "com.mysql.jdbc.Driver";
	final String url = "jdbc:mysql://localhost:3306/mldn";
	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) {

			System.out.println("database connection fail !");
		}
	}	

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