tools.java

超市管理系统,jsp+javabean+sqlserver

package dao;

import java.sql.Connection;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;

public class Tools {
	
	public static Connection getConnection()
	{
		
		Connection conn = null;
		DataSource data = null;
		try {
			//Class.forName("oracle.jdbc.driver.OracleDriver");
			//conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:oracle","scott","tiger");
		
		Context ctx = new InitialContext();
		data = (DataSource) ctx.lookup("java:comp/env/news");
		
		conn = data.getConnection();
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		return conn;
	}

}