1、数据库连接配置

class="org.springframework.jdbc.datasource.DriverManagerDataSource">

com.microsoft.sqlserver.jdbc.SQLServerDriver

jdbc:sqlserver://172.16.253.122:1433;DatabaseName=joytone;

sa

class="com.ztkj.his.mzregister.server.dao.jdbc.impl.NetpreLgfyDaoJdbcImpl" >

2、访问 sqlserver 代码

public List getYuyueInfo(String orderno, String cardno) throws DaoException {

GlobalFun.logIn();

List list = null;

try {

String sql = "SELECT * FROM JOYTONE_YUYUE where 1=1 ";

if (!Assert.isNull(orderno)) {

sql = sql.concat(" and order_no='").concat(orderno).concat("'");

} else if ((!Assert.isNull(cardno)) && cardno.length() > 0) {

sql = sql.concat(" and his_member_id='").concat(cardno).concat("'");

}

sql = sql.concat(" order by order_no desc ");

logger.info("orderno=" + orderno + ",cardno=" + cardno);

logger.debug(sql);

list = this.getJdbcTemplate().query(sql, new ObjectMapper(JoytoneYuyue.class));

} catch (Exception e) {

throw new DaoException(e.getMessage());

}

GlobalFun.logOut();

return list;

}

3、解决办法

在 web 服务器 c:\windows\system32\drivers\etc\HOSTS表中添加一条

172.16.253.122172.16.253.122

问题原因：servername(本例中是172.116.253.122)，程序访问172.116.253.122时，把它当成机器名称进行解析，长时间没有结果最后才访问IP为172.116.253.122的机器。