qq_41995845的博客

数据

sql

使用 console.log()打印参数

SELECT object_name( id ) AS 表名 , c.name AS 字段名 , t.name 数据类型 , c.prec AS 长度 FROM syscolumns c INNER JOIN systypes t ON c.xusertype= t.xusertype WHERE objectproperty( id, 'IsView' ) = 1 AND id = object_id( '视图名' ) ...

select ‘数据’ 字段名 FROM Damage

useResourceLogService.queryUseResourceLogsByPid(id,"equipment") @Transactional(readOnly = true) public List<Map> queryUseResourceLogsByPid(String pid,String type){ if(StringFacs.isEmpty(pid)||StringFacs.isEmpty(type)){ retur

SELECT a.sj completeTime, ad.id, CASE WHEN ad.dScopeId IS NULL THEN '否' WHEN ad.dScopeId = '' THEN '否' ELSE '是' END dScopeId, ad.khbh, ( SELECT area_name FROM T_area WHERE id = ad.sspq ) sspq, kd.smallName smallName, ( SELECT statusname FROM

public List<Map> queryAllAreaByPCodePc() { String hql = "select pd.*,t.area_name,t.ProDepartment from ProDepartment pd " + "left join T_area t on t.ProDepartment=pd.name \n" + "where pd.operationStatue=0 and

public List<ProDepartmentEntity> queryProDepartmentAppSspq(String sspq) { String hql = "select * from ProDepartment pd " + "left join T_area t on t.ProDepartment=pd.name \n" + "where pd.operationStatue=0 ...

@RequestMapping(value = "getAreaByTypeName.html", method = RequestMethod.GET) @ResponseBody public Map<String, Object> getAreaByTypeName(HttpServletRequest request) { Map<String, Object> map = new HashMap<>(); St..

//查询附件信息 public List queryAttaches(String id){ StringBuffer sql = new StringBuffer("select * from ATTACH where id = '"+id+"' "); return jdbcTemplate.queryEntitys(sql.toString(),AttachEntity.class); } //根据pid查询附件信息 public .

select * from assessData ad LEFT JOIN assessComplete ac ON ac.pid = ad.id AND ac.addTime = ( SELECT MAX ( addTime ) FROM assessComplete ac2 WHERE ac2.pid = ad.id ) left join khDamInfo kd on ac.id=kd.pid where kd.deviceName='莫力庙大街(创业大道-柳荫路)' ...

select d.yhdydm, d.id,concat(df1.type_name,'病害') damZy,dtype.damType, d.patrol_type_name damGrade,d.patrol_type_code,d.lsbh,ta.area_name sspq,d.dam_sources,d.add_time,d.user_name, d.node_name statusname,d.fac_name_new fac_name,d.device_type_name,d.fac_dire

UPDATE DamageComplete SET DamageComplete.DAMUNITNAME = ( SELECT DAMUNIT.NAME FROM damage d LEFT JOIN DamDaily ON d.DAMCODE = DamDaily.CODE LEFT JOIN DAMUNIT ON DamDaily.UNIT = DAMUNIT.CODE WHERE d.id = DamageComplete.pid ) where DamageComplete.

resultType很简单，数据库和实体类自动映射，=类名 resultMap比较复杂，数据库和实体类自定义映射，单独写出一段

exec sp_helpindex 表名