package org.kevin.yo;
import java.sql.*;
public class connectSql {
    public static void main(String[] srg) {
      String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";  //加载JDBC驱动
      String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=test";  //连接服务器和数据库test
      String userName = "sa";  //默认用户名
      String userPwd = "kevin";  //密码
      Connection dbConn;
      Statement state=null;
      ResultSet rs=null;
      String sql="select * from stu_info";
      try {
       Class.forName(driverName);
       dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
       System.out.println("Connection Successful!");  //如果连接成功 控制台输出Connection Successful!
       state=dbConn.createStatement();
       rs=state.executeQuery(sql);
       while(rs.next()){
           String id= rs.getString(1);
           String name= rs.getString(2);
           String age = rs.getString(3);
           String sex=rs.getNString(4);
           System.out.println(id+""+name+""+age+""+sex+"");
           System.out.println("\n");
            }
      } catch (Exception e) {
       e.printStackTrace();
      }
    }
}