JDBC连接SQL SERVER 和JUNIT4单元测试

这是一个spring下利用jdbc连接SQL SERVER 2008 R2，并且利用Junit4做单元测试的合并例子。

import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import org.junit.Test;import org.junit.runner.RunWith;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import org.springframework.test.context.ContextConfiguration;import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;import org.springframework.test.context.transaction.TransactionConfiguration;import org.springframework.transaction.annotation.Transactional;import com.thinkgem.jeesite.common.utils.IdGen;import com.thinkgem.jeesite.modules.mancs.gov.agri.demonarea.demoninfo.entity.DemonInfo;import com.thinkgem.jeesite.modules.mancs.gov.agri.demonarea.demoninfo.service.DemonInfoService;/** 声明用的是Spring的测试类 **/@RunWith(SpringJUnit4ClassRunner.class)/** 声明spring主配置文件位置，注意：以当前测试类的位置为基准,有多个配置文件以字符数组声明 **/@ContextConfiguration(locations = { "classpath:spring-context.xml" })/** 声明事务回滚，要不测试一个方法数据就没有了岂不很杯具，注意：插入数据时可注掉，不让事务回滚 **/@TransactionConfiguration(transactionManager = "transactionManager", defaultRollback = false)@Service@Transactional(readOnly = true)public class GetDataFromOldDB {    @Autowired    private DemonInfoService demonInfoService;    @Test    public void test() {        String JDriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";        String connectDB = "jdbc:sqlserver://10.2.146.120:1433; DatabaseName=AgriRegion";        try {            Class.forName(JDriver);        } catch (ClassNotFoundException e) {            System.out.println("加载数据库引擎失败");        }        System.out.println("数据库驱动成功");        try {            String user = "sa";            String password = "abc.123456";            Connection con = DriverManager.getConnection(connectDB, user, password);            System.out.println("连接数据库成功");            Statement stmt = con.createStatement();            ResultSet rs = stmt                    .executeQuery("SELECT * FROM [AgriRegion].[dbo].[BaseUsers] t where t.UserName='山东省寿光市国家现代农业示范区'");// 返回SQL语句查询结果集(集合)            // 循环输出每一条记录            while (rs.next()) {                // 输出每个字段                System.out                        .println(rs.getString("ID") + "\t" + rs.getString("UserName") + "\t" + rs.getString("Province")                                + rs.getString("City") + rs.getString("County") + rs.getString("Address"));                DemonInfo demonInfo = new DemonInfo();                demonInfo.setId(IdGen.uuid());                demonInfo.setReportName(rs.getString("UserName"));                demonInfo.setConfirmName(rs.getString("UserName"));                demonInfo.setAddress(rs.getString("Province") + rs.getString("City") + rs.getString("County")                        + rs.getString("Address"));                demonInfo.setDemonareaType(1);                demonInfo.setTelephone(rs.getString("Phone"));                demonInfo.setAreaNames(                        rs.getString("Province") + "," + rs.getString("City") + "," + rs.getString("County"));                demonInfoService.saveDaseData4TestCreate(demonInfo);            }            System.out.println("读取完毕");            stmt.close();// 关闭命令对象连接            con.close();// 关闭数据库连接        } catch (SQLException e) {            e.printStackTrace();            System.out.print(e.getErrorCode());        }    }}