dbconnection.java

基于java的医院门诊管理系统

package crqs.dboperation;

import java.sql.*;
import javax.sql.*;
import javax.naming.*;

public class DBConnection {

	private static Context ctx;

	private static DataSource ds;

	private static Connection conn;

	private static Statement stmt;

	private static String DSName = "jdbc/sqlserver";
	static {
		try {
			ctx = new InitialContext();
			ds = (DataSource) ctx.lookup("java:comp/env/" + DSName);
		} catch (NamingException e) {
			e.printStackTrace();
		}
	}

	public static synchronized Connection getConnection() throws SQLException {
		conn = ds.getConnection();
		return conn;
	}
}