| | |
|---|
| | | List<Map<String,Object>> projectList = tjProjectService.zdysqlcx(sql); |
|---|
| | | if(null !=projectList && !projectList.isEmpty()){ |
|---|
| | | for (Map<String, Object> map : projectList) { |
|---|
| | | Object zd1 = map.get("zd"); |
|---|
| | | Object zd1 = map.get(zd); |
|---|
| | | if(null !=zd1 && StringUtil.isNotBlank(zd1.toString())){ |
|---|
| | | String letter = PinyinUtil.getFirstLetter(zd1.toString(), ""); |
|---|
| | | sql="UPDATE "+ tbname +" "+ " set " +pymzd+" = "+ letter; |
|---|
| | | sql="UPDATE "+ tbname +" "+ " set " +pymzd+" = "+ "'" +letter+"'"+" where "+zd+" = "+"'"+zd1+"'" ; |
|---|
| | | tjProjectService.zdysqlxg(sql); |
|---|
| | | } |
|---|
| | | } |
|---|
