java 插入时间格式
Date now = new Date();
SimpleDateFormat dateFormat = new SimpleDateFormat("yyyyMMdd");//可以方便地修改日期格式
String newdata = dateFormat.format(now);
String sql = "insert into yd_czzl(zlbh,yqbh,bmdm,czzl,yjsj) VALUES(?,?,?,?,to_date(?,'yyyy-mm-dd'))";
java获取值count
String sql = "select count(*) from file_upload where file_id=?";// 将file_upload中的bz改为1
Object obj = runner.query(conn, sql, new ScalarHandler<Object>());
if(obj == null){
zh_len = 0;
}else{
zh_len = Integer.parseInt(String.valueOf(obj));
}
Mysql语句
先查询值进行相加,然后插入到其他字段中。
注意: b.s from (XXXX) b 类似一个虚拟表。
update yhxx set jifen=(
select b.s from
(select (t1.jifen+t2.jfy_jf) as s
from yhxx t1,file_upload t2 where t2.file_id='2021-10-273b1672bb-cc43-4aa5-a3d7-daefae1db223'
and t1.yhbh=t2.yhbh
) b) where yhbh='hws'
Mysql 关联查询,将主表中多个字段中的值 与 字典表 进行映射替换。
通过左连接进行多个关联表映射。
SELECT t1.*,d.yhxm as sh_xm,d1.yhxm as jf_xm FROM file_upload t1
left join yhxx d on t1.sh_id = d.user_id
left join yhxx d1 on t1.jf_id = d1.user_id
where t1.sh_id is not null and t1.jf_id is not null
order by fbsj desc