public class JDBC {

     public static void main(String[] args) {

         //1.加载驱动

         try{

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

         }catch( ClassNotFoundException e){

             e.printStackTrace();

         }

         //2.获得连接 url = jdbc:sqlserver://localhost:1433;datebaseName=schoolDB,username,password

         //jdbc:数据库://ip地址:端口号;数据库名

         try{

             Connection conn  = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;datebaseName=shoolDB","sa","sa");

             System.out.println(conn);

             //3.执行sql语句，得到返回结果

             String sql = "use shoolDB select * from EMP";

             //获得执行sql语句的对象

             Statement stat = conn.createStatement();

             ResultSet rs = stat.executeQuery(sql);

             //4.处理结果

             while(rs.next()){

 //                int empno = rs.getInt("empno");

 //                String ename = rs.getString("ename");

 //                String job = rs.getString("job");

 //                System.out.println(empno+ename+job);

                 int empno = rs.getInt(1);

                 String ename = rs.getString(2);

                 System.out.println(empno+"\t"+ename);

             }

             rs.close();

             stat.close();

             conn.close();

         }catch(SQLException e){

             e.printStackTrace();

         }

         //3.执行SQL语句，得到返回结果

         //4.处理结果

     }

 }