databaseconnection.java

高效的jsp分页查询

package com.jida.gt.db;


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

public class DataBaseConnection {
	
	private final String DBDRIVER = "com.microsoft.jdbc.sqlserver.SQLServerDriver" ;
	private final String DBURL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=GT" ;
	private final String DBUSER = "sa" ;
	private final String DBPASSWORD = "sa" ;
	private Connection conn = null ;
	
	public DataBaseConnection()
	{
		try
		{
			Class.forName(DBDRIVER) ;
			this.conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD) ;	
		}
		catch (Exception e)
		{
			e.printStackTrace();
		}
	}

	public Connection getConnection() {
		// TODO Auto-generated method stub
		return this.conn;
	}
	
	public void close()
	{
		try {
			this.conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

}