jdbc 连接数据库

package test;
 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class dd
{
public static void main(String args[]){
   String url="jdbc:sqlserver://localhost:1433;DatabaseName=homeWork";
   String user="sa";
   String password="";
   String sqlStr="select * from information";
   Connection con=null;
   Statement st=null;
   ResultSet rs=null;
   
    
    try {
     //第一步
     Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
    } catch (ClassNotFoundException e2) {
     System.out.println("111");
    }
    System.out.println("类实例化成功!");
   
     //第二步
    try {
     con = DriverManager.getConnection(url,user,password);
    } catch (SQLException e2) {
     System.out.println("222");
    }
    System.out.println("连接数据库成功!");
   
     //第三步
    try {
     System.out.println("123");
     st=con.createStatement();
     System.out.println("创建Statement成功!");
     rs = st.executeQuery(sqlStr);
     System.out.println("操作数据表成功!");
     System.out.println("----------------!");
     
     while(rs.next())
     {
     System.out.print(rs.getString("name") + " ");
     
     }
    } catch (SQLException e1) {
     System.out.println("444");
    }
   try {
    rs.close();
    st.close();
    con.close();
   } catch (SQLException e) {
    System.out.println("555");
   }
   
 }
}