dbconnection.java

基于Struts的分页功能

package com.zhku.dbc;

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

public class DBConnection {
    
	private final String DBDriver="org.gjt.mm.mysql.Driver";
	private final String DBURL="jdbc:mysql://localhost:3306/user?characterEncoding=gb2312";
	private final String DBUSER="root";
	private final String DBPASSWORD="198605";
	private Connection conn=null;
   
	
	public DBConnection(){
		try {
			Class.forName(DBDriver);
			this.conn = DriverManager.getConnection(DBURL, DBUSER, DBPASSWORD);
			
		} catch (Exception e) {
			e.getStackTrace();
		}		
	}
	public Connection getConnection(){
		return this.conn;
	}
	public void close(){
		this.close();
	}
}