public void getData(){

    String URL = "jdbc:sqlserver://127.0.0.1:1433;databaseName=news";

    Connection con = null;
    Statement statement = null;
    ResultSet rs = null;

    try {

        // 加载驱动

        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

        // 获得数据库连接对象

        con = DriverManager.getConnection(URL, "sa", "12345yehuan");

        // 执行sql语句

        String sql = "select * from student";

        statement = con.createStatement();
        // 接收查询结果

        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);

        }

        } catch (ClassNotFoundException e) {

            e.printStackTrace();

        } catch (SQLException e) {

            // TODO Auto-generated catch block

            e.printStackTrace();

        } finally {

            try {
                // 释放资源
                rs.close();
                statement.close();

                con.close();

            } catch (SQLException e) {

                // TODO Auto-generated catch block

                e.printStackTrace();

            }

        }

}