java连接sqlserver数据库

import java.sql.*;
import com.microsoft.jdbc.sqlserver.SQLServerDriver;
public class connSQLServer
{
 public static void main(String[] args)
 {
  Connection conn;
  Statement stmt;
  ResultSet rs;
  String driver;
  String url;
  String uid;
  String pwd;
  String sql;
  uid="sa";
  pwd="sa";
  sql="select * from chengyu";
  driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
  url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=chengyu";
  try
  {
   Class.forName(driver);
   conn=DriverManager.getConnection(url,uid,pwd);
   stmt=conn.createStatement();
   stmt.execute(sql);
   rs=stmt.getResultSet();
   while(rs.next())
   {
    System.out.println(rs.getString(1));
   }
  }
  catch(Exception e)
  {
   e.printStackTrace();
  }
 }
}