终于做好了JDBC在java和sql 2005之间的连接了，快哭了

好吧。。这是个艰难的过程。大神请绕过。

首先编写代码：

import java.sql.*;

class JdbcDemo1 {
    public static void main (String[] args) {
        Connection conn = null;
        try {
            //Class.forName("com.mysql.jdbc.Driver");
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

              //String url = "jdbc:mysql://127.0.0.1:3306/demoDB";
              String url = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=demoDB";
              
              //String userName = "root";
              String userName = "sa";
            String password = "";
              
            conn = DriverManager.getConnection(url, userName, password);
              
              Statement stmt = conn.createStatement( );
            String createTablePersonnel = "CREATE TABLE Personnel " +
                "(Name VARCHAR(32), ID INTEGER, Salary FLOAT, Gender VARCHAR(8))";    
            stmt.executeUpdate(createTablePersonnel);
            stmt.close( );

        }     catch (Exception e) {
               System.err.println(e.getMessage( ));
        }  finally {
            try{conn.close();}catch (Exception e){} 
        }
    }  // main
} // JdbcDemo1