connectionbean.java

树形菜单

package com.sdjs.tree.db;

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

/**
 *createTime:2008-10-14	下午04:20:32
 *source:http://www.taxchina.com
 *file_PATH:com.sdjs.tree.dbConnectionBean.java
 *project_name:AjaxTree
 *author:Administrator
 */

public class ConnectionBean
{

	public ConnectionBean()
	{
		super();
		// TODO 自动生成构造函数存根
		try
		{
			Class.forName("com.mysql.jdbc.Driver");
		}
		catch (ClassNotFoundException e)
		{
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		
	}
	private String url = "jdbc:mysql://localhost:3306/j2setrain";
	private String user = "root";
	private String password = "root";
	
	
	public Connection getConnection()
	{
		Connection tconn=null ;
		try
		{
			tconn = DriverManager.getConnection(url, user, password);
		}
		catch (SQLException e)
		{
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		return tconn;
	}
	
	public String getPassword()
	{
		return password;
	}
	public void setPassword(String password)
	{
		this.password = password;
	}
	public String getUrl()
	{
		return url;
	}
	public void setUrl(String url)
	{
		this.url = url;
	}
	public String getUser()
	{
		return user;
	}
	public void setUser(String user)
	{
		this.user = user;
	}

}