数据库技术A实验二--基本SQL语句使用与编程连接SQLServer数据库

说明：基本SQL语句使用略。eclipse编程连接SQLServer数据库，新建实验二Java Project项目，新增demo1.java.并修改相关代码片段的参数至符合自己项目结构的要求。

Demo1.java:

package 实验二;
import java.sql.*;

public class Demo1 {
 public static void main(String [] args)
 {
  String driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";
  String dbURL="jdbc:sqlserver://localhost:10086;DatabaseName=study2";
  String userName="sa1";
  String userPwd="202005295";
 try
{
    Class.forName(driverName);
    System.out.println("加载驱动成功！");   
}catch(Exception e){
    e.printStackTrace();
    System.out.println("加载驱动失败！");
}
try{
    Connection dbConn = DriverManager.getConnection(dbURL,userName,userPwd);
        System.out.println("连接数据库成功！");
        //Connection con = DriverManager.getConnection(dbURL, "sa1","202005295");
        Statement statement = dbConn.createStatement();
        ResultSet rs = statement.executeQuery("select * from student");
        while (rs.next()) {
               System.out.println(rs.getString(1) + "|" + rs.getString(2));
            };  
}catch(Exception e)
{
    e.printStackTrace();
    System.out.print("SQL Server连接失败！");
}       
}
}