SQLServer连接语句

public class SqlServerTest {

    //驱动类

    staticString driverClass=

       "com.microsoft.jdbc.sqlserver.SQLServerDriver";

    //连接字符串

    staticString url=

       "jdbc:microsoft:sqlserver://127.0.0.1:1433;dataBaseName=Test";

    //密码

    staticString password= "peter";

     // 用户名

    staticString username= "peter";

    //待执行的 SQL 语句

    staticString sql= "SELECT * FROM Test";

 

    publicstatic voidmain(String[] args) {

       Connection conn = null ;

       PreparedStatement pstmt =null ;

       ResultSet rs = null;

 

       try{

           Class.forName(driverClass );

           conn = DriverManager.getConnection(url , username , password );

           pstmt = conn.prepareStatement(sql );

           rs = pstmt.executeQuery();

           while(rs.next()) {

              System. out.println( "OK.");

           }

           System. out.println( "OK too.");

           rs.close();

           pstmt.close();

           conn.close();

       } catch(ClassNotFoundException e) {

           System. out.println( "驱动类没有找到 ." );

           e.printStackTrace();

       } catch(SQLException e) {

           e.printStackTrace();

       } finally{

           if(rs != null) //结果集没有关闭时关闭结果集

              try{

                  rs.close();

              } catch(SQLException e) {

                  e.printStackTrace();

              }

           if(pstmt != null) //发送对象没有关闭时关闭发送对象

              try{

                  pstmt.close();

              } catch(SQLException e) {

                  e.printStackTrace();

              }

           if(conn != null)  //连接没有关闭时关闭连接

              try{

                  conn.close();

              } catch(SQLException e) {

                  e.printStackTrace();

              }

       }

 

    }

}

that well does capture Exception program .

原地址：http://www.blogjava.net/lpeter/archive/2006/12/22/89501.html