datasourceservlet.java

选课系统,基于SSH2的选课系统,欢迎下载

package xiong.gang.servlet;

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

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.sql.DataSource;

@SuppressWarnings("serial")
public class DataSourceServlet extends HttpServlet {
	final String JNDINAME= "java:comp/env/jdbc/gang";
	private static Connection conn= null;
	HttpServletRequest request = null;

	public DataSourceServlet() {
	}

	@Override
	public void init() throws ServletException {
		//System.out.print("init...........");
	}

	public Connection getconn() throws ServletException {
		try {
			// 初始化查找命名空间
			Context ctx = new InitialContext();
			// 找到DataSource
			DataSource ds = (DataSource) ctx.lookup(JNDINAME);
			conn = ds.getConnection();
			// System.out.print(conn);
		} catch (Exception e) {
			System.out.println(e);
		}
		return conn;
	}


	public static void cloes() {
		try {
			if (conn != null){
				conn.close();
				//System.out.print("conn.close()"+"....");
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

}