数据库单元测试

@org.junit.Test
  public void testSQL(){
      DriverManagerDataSource dataSource = new DriverManagerDataSource();
      dataSource.setDriverClassName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
      dataSource.setUrl("jdbc:sqlserver://10.11.11.111:1433;database=spiderDB");
      dataSource.setUsername("111");
      dataSource.setPassword("111");

      JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
      List<Map<String, Object>> maps = jdbcTemplate.queryForList("SELECT * FROM marine_ship_price");
      for (Iterator it = maps.iterator(); it.hasNext();it.next()) {
          System.out.println(it);
      }
  }

转载于:https://my.oschina.net/pcwan/blog/678149