摘要:
1.注意事项:Mapper 里字符串用""双引号, select * from table where concat(col1,col2) like "%"#{col3}"%"; select count(id) from table; 1.实体类的属性名和数据库字段一致 2.绑定映射resourc 阅读全文
摘要:
一。 创建数据库: 1. create database if not exists `mybatis` default character set utf8 default collate utf8_general_ci; 2. show create database mybatis; 3. u 阅读全文
摘要:
1. import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement; public class Demo{ public stati 阅读全文
摘要:
1.权限管理:root 创建用户: create user chen identified by '123456 修改密码: update mysql.user set authentication_string='123456' where Host='localhost' and User='r 阅读全文
摘要:
1.分页 limit offset 和排序 order by desc 降序 asc 升序 select a.1,2,3,4 from a inner join b on a.1=b.1 inner join c on c.2=b.2 where 3='xxx' order by 4 desc (a 阅读全文