除selest都需要加sqlSession.commit();
查找:
select id from table
select *from table where id=1
增加:
insert into table(name,email) values('tom','tom@gmail.com')
修改:
update table set name='tom', email='tom@gmail.com' where id=1
删除:
delete from table where id=1
日期:
select id,uid ,DATE_FORMAT(date,"%y-%m-%d %H:%i:%s") As date from table order by date desc
insert into table(mid,date) values(#{mid},now()) 显示此时时间