From fa00382db413a8489d07983b66f0869305b51a9a Mon Sep 17 00:00:00 2001
From: 81041 <81041@DESKTOP-025NVD9>
Date: 星期五, 11 一月 2019 11:35:54 +0800
Subject: [PATCH] 批量读取系统参数
---
gx_tieta/src/com/fgkj/dao/impl/User_infImpl.java | 29 +++++++++++++++++++++++++++++
1 files changed, 29 insertions(+), 0 deletions(-)
diff --git a/gx_tieta/src/com/fgkj/dao/impl/User_infImpl.java b/gx_tieta/src/com/fgkj/dao/impl/User_infImpl.java
index a42c68d..37fbf77 100644
--- a/gx_tieta/src/com/fgkj/dao/impl/User_infImpl.java
+++ b/gx_tieta/src/com/fgkj/dao/impl/User_infImpl.java
@@ -289,6 +289,35 @@
return list;
}
+ //鏍规嵁uId鏌ョ敤鎴峰鍚�
+ public String changeUidToUname(Object obj) {
+ int uid=(Integer) obj;
+ String sql = "select distinct uName from db_user.tb_user_inf where uId=? limit 1";
+ List list = DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{uid},new CallBack() {
+ public List getResults(ResultSet rs) {
+ List list=new ArrayList();
+ try {
+ while(rs.next()){
+ String uname="";
+ if(rs.getString("uname")!=null){
+ uname=rs.getString("uname");
+ list.add(uname);
+ }
+ }
+ } catch (SQLException e) {
+ // TODO Auto-generated catch block
+ e.printStackTrace();
+ }
+ return list;
+ }
+
+ });
+ String uname="";
+ if(list!=null&&list.size()>0){
+ uname=(String) list.get(list.size()-1);
+ }
+ return uname;
+ }
//鏌ヨ鎵�鏈塽id鍦ㄥ瓧绗︿覆objs涓殑鎵�鏈夌敤鎴峰悕,骞朵笖鐢紝杩炴帴澶氫釜鐢ㄦ埛鍚�
public List searchUnams(Object objs){
String sql = "SELECT GROUP_CONCAT(DISTINCT(uname))as unames from db_user.tb_user_inf where locate(uid,?);";
--
Gitblit v1.9.1