sqldatasource.java

一个jsp翻页的小例子

package com.page.inc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;

public class SQLDataSource
{
	private static Connection conn;

	private static final String DRIVER_CLASS = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
	private static final String DATABASE_URL = "jdbc:sqlserver://localhost:1433;DatabaseName=db_web";
	private static final String DATABASE_USRE = "sa";
	private static final String DATABASE_PASSWORD = "";

	public SQLDataSource()
	{
		
	}

	public static Connection getConn() throws SQLException
	{
		try
		{
		
		Class.forName(DRIVER_CLASS);
		conn = DriverManager.getConnection(DATABASE_URL,
				DATABASE_USRE, DATABASE_PASSWORD);
		
		} catch (Exception e)
		{
			System.out.print("数据库连接池-数据源错误");
		}
		return conn;

	}

	public static void CloseConn(Connection conn) throws SQLException
	{
		if (!conn.isClosed())
		{
			conn.close();
		}

	}
	
	public static void main(String args[])
	{
		try {
			System.out.println(SQLDataSource.getConn());
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
	}

}