JSP配置文件的使用

jdbc.SQLServerDriver.class=com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc.connection.url=jdbc:sqlserver://127.0.0.1:1433;databaseName=news
jdbc.connection.username=sa
jdbc.connection.password=12345yehuan

public void getData(){
    ConfigManager configManager = ConfigManager.getInstance();
    String url = configManager.getString("jdbc.connection.url");
    String username = configManager.getString("jdbc.connection.username");
    String password = configManager.getString("jdbc.connection.password");
    String driver = configManager.getString("jdbc.SQLServerDriver.class");
    Connection con=null;
    try {
        // 加载驱动
        Class.forName(driver);
        // 获得数据库连接
        con = DriverManager.getConnection(url, username, password);
        // 执行sql语句
        String sql = "select * from student";
        Statement statement = con.createStatement();
        ResultSet rs = statement.executeQuery(sql);
        while(rs.next()){
            int id = rs.getInt(1);
            String name = rs.getString(2);
            int age = rs.getInt(3);
            System.out.println(id+"\t"+name+"\t"+age);
        }
        System.out.println("连接成功");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } finally {    
            try {
                con.close();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
}