调整日志信息

wuxw

2019-02-02 9454b49eeabd56894550f1419f14e96f9d10c2ef

 java110-service/src/main/java/com/java110/service/dao/impl/QueryServiceDAOImpl.java

@@ -4,6 +4,8 @@
import com.java110.core.base.dao.BaseServiceDao;
import com.java110.entity.service.ServiceSql;
import com.java110.service.dao.IQueryServiceDAO;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

@@ -16,6 +18,8 @@
@Service("queryServiceDAOImpl")
@Transactional
public class QueryServiceDAOImpl extends BaseServiceDao implements IQueryServiceDAO {

    private final static Logger logger = LoggerFactory.getLogger(QueryServiceDAOImpl.class);

    /**
     *  防止sql注入 改造成直接用prepareStatement 预处理sql
@@ -60,8 +64,12 @@
        }finally{
            try {
                //conn.close();
                ps.close();
                rs.close();
                if( ps!=null) {
                    ps.close();
                }
                if(rs != null) {
                    rs.close();
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }