java 访问sqlserver慢_JDBC 远程 SQLSERVER 速度很慢的处理方式

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='").conca