conn.java

来自「用selevet+ajax动态生成ajax树！」· Java 代码 · 共 58 行

package util;
import java.sql.*;

/**
 * @author Administrator
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class Conn {

	private Connection conn=null;
	
	public Connection getConnection()
	{
		return conn;
	}
	
	
	public Conn()
	{
		setConnection();
	} 
	public void setConnection()
	{
		try
		{
			Class.forName("org.gjt.mm.mysql.Driver");
			conn = DriverManager.getConnection("jdbc:mysql://192.168.1.7:3306/ajaxdatabase","root","root");		
		}catch(SQLException sqlEx)
		{
			System.out.println("SQLException : "); 
			sqlEx.printStackTrace();
		}catch(Exception ex){
			System.out.println("Exception : "); 
			ex.printStackTrace();
		}
	}
	
	public void disConnection()
	{
		try
		{
			if(conn!=null&&!conn.isClosed()){
				conn.close();
			}
		}catch(SQLException sqlEx)
		{
			System.out.println("SQLException : "); 
			sqlEx.printStackTrace();
		}catch(Exception ex){
			System.out.println("Exception : "); 
			ex.printStackTrace();
		}
	}
}