1.需要jar包sqljdbc.jar（附件提供），下载地址
[url]http://www.microsoft.com/downloads/details.aspx?FamilyID=e22bc83b-32ff-4474-a[/url]44a-22b6ae2c4e17
 
2.SqlServer的tcp/ip端口查询
SQL Server Configuration Manager-SQL Server 2005 网络配置-SQLEXPRESS-右键单击ICP/IP-属性-IP地址
 
3.设置sa账户与密码
使用Microsoft SQL Server Management Studio Express管理SqlServer数据库，第一次选择Windows身份验证模式登录。
3.1右键sqlserver-安全性-服务器身份验证-“SQL SERVER和Windows身份验证模式”；
3.2安全性-登录名-双击sa，设置用户名和密码；
3.3在sa的右侧-状态-登录-选择启用；
 
4.建立测试数据库并导入sql脚本
4.1数据库-右键新建数据库-tmp；
4.2导入下面的sql脚本，选择执行。
student.sql
use tmp;
 
CREATE TABLE student_table (
  id varchar(32) NOT NULL,
  name varchar(32) DEFAULT NULL,
  cardId varchar(32) NOT NULL,
  age int DEFAULT NULL,
  PRIMARY KEY (id)
);
 
INSERT INTO student_table VALUES
 ('297ed8ec1efde79a011efde79e670001','tomclus','200512345',33);
 
5.Java连接文件
SqlServerCon.java
package com.zj.connector;
 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
 
public class SqlServerCon {
    public static void main(String[] arg) {
       String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; // 加载JDBC驱动
       String dbURL = "jdbc:sqlserver://localhost:1025; DatabaseName=tmp"; // 连接服务器和数据库
       String userName = "sa"; // 用户名
       String userPwd = "root"; // 密码
        Connection dbConn;
       try {
           Class.forName(driverName);
           dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
           Statement stmt = dbConn.createStatement();
           ResultSet rs = null;
           String sql = "select * from student_table";
           rs = stmt.executeQuery(sql);
           while (rs.next()) {
              String id = rs.getString("id");
              String name = rs.getString("name");
              String cardId = rs.getString("cardId");
              int age = rs.getInt("age");
              System.out.println(id + " " + name + " " + cardId + " " + age);
           }
       } catch (Exception e) {
           e.printStackTrace();
       }
    }
}
 
6.连接MySQL，使用的jar包见附件。使用mysqldump 将sql脚本导入数据库，Java测试类为
MySQLCon.java
package com.zj.connector;
 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
 
public class MySQLCon {
    public static void main(String[] arg) {
       String driverName = "com.mysql.jdbc.Driver"; // 加载JDBC驱动
       String dbURL = "jdbc:mysql://localhost:3306/tmp?useUnicode=true&characterEncoding=UTF-8"; // 连接服务器和数据库
       String userName = "root"; // 用户名
       String userPwd = "root"; // 密码
       Connection dbConn;
       try {
           Class.forName(driverName);
           dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
           Statement stmt = dbConn.createStatement();
           ResultSet rs = null;
           String sql = "select * from student_table";
           rs = stmt.executeQuery(sql);
           while (rs.next()) {
              String id = rs.getString("id");
              String name = rs.getString("name");
              String cardId = rs.getString("cardId");
              int age = rs.getInt("age");
              System.out.println(id + " " + name + " " + cardId + " " + age);
           }
       } catch (Exception e) {
           e.printStackTrace();
       }
    }
}