DriverManager是一种相当古老的做事方式。更好的方法是
DataSource通过查找已经为您配置的应用服务器容器来获取一个:
Context context = new InitialContext();DataSource dataSource = (DataSource) context.lookup("java:comp/env/jdbc/myDB");或直接从数据库驱动程序实例化和配置一个:
MysqlDataSource dataSource = new MysqlDataSource();dataSource.setUser("scott");dataSource.setPassword("tiger");dataSource.setServerName("myDBHost.example.org");然后从中获取连接,如上:
Connection conn = dataSource.getConnection();Statement stmt = conn.createStatement();ResultSet rs = stmt.executeQuery("SELECt ID FROM USERS");...rs.close();stmt.close();conn.close();


