# Set root category priority to INFO and its only appender to CONSOLE. #log4j.rootCategory=INFO, CONSOLE debug info warn error fatal log4j.rootCategory=debug, CONSOLE, LOGFILE
# Set the enterprise logger category to FATAL and its only appender to CONSOLE. log4j.logger.org.apache.axis.enterprise=FATAL, CONSOLE
# CONSOLE is set to be a ConsoleAppender using a PatternLayout. log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender log4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayout log4j.appender.CONSOLE.layout.ConversionPattern=%d{ISO8601} %-6r [%15.15t] %-5p %30.30c %x - %mn
# LOGFILE is set to be a File appender using a PatternLayout. log4j.appender.LOGFILE=org.apache.log4j.FileAppender log4j.appender.LOGFILE.File=d:axis.log log4j.appender.LOGFILE.Append=true log4j.appender.LOGFILE.layout=org.apache.log4j.PatternLayout log4j.appender.LOGFILE.layout.ConversionPattern=%d{ISO8601} %-6r [%15.15t] %-5p %30.30c %x - %mn
3.配置log4j为日志的实现
4.log4j的实现 直接测试运行刚才的查询
7.分页
7.1.使用Limit分页
select * from user limit startIndex,pageSize;
select * from user limit 3; #[0,n]
1.接口
//分页
List getUserByLimit(Map map);
2.Mapper.xml
select * from user limit #{startIndex},#{pageSize}
3.测试
@Test
public void getUserByLimit(){
SqlSession sqlSession = MybatisUtils.getSqlSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
Map map = new HashMap();
map.put("startIndex",0);
map.put("pageSize",2);
List userByLimit = mapper.getUserByLimit(map);
for (User user : userByLimit) {
System.out.println(user);
}
sqlSession.close();
}
7.2.RowBounds分页
不使用SQL实现分页
1.接口
//分页2
List getUserByRowBounds();
2.mapper.xml
3.测试
@Test
public void getUserByRowBounds(){
SqlSession sqlSession = MybatisUtils.getSqlSession();
//RowBounds实现
RowBounds rowBounds = new RowBounds(1,2);
//通过java代码层面实现分页
List list = sqlSession.selectList("com.lxyk.dao.UserMapper.getUserByRowBounds",null,rowBounds);
for (User user : list) {
System.out.println(user);
}
sqlSession.close();
}
@Test
public void test(){
SqlSession sqlSession = MybatisUtils.getSqlSession();
//底层主要应用反射
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
List allList = mapper.getAllList();
for (User user : allList) {
System.out.println(user);
}
sqlSession.close();
}
8.3.CRUD
我们可以在工具类创建的时候实现自动提交事务!
public static SqlSession getSqlSession(){
return sqlSessionFactory.openSession(true);
}
编写接口,增加注解
public interface UserMapper {
@Select("select * from user")
List getAllList();
//@Param注解的作用是给参数命名,参数命名后就能根据名字得到参数值,正确的将参数传入sql语句中
//方法存在多个参数,所有的参数前面必须加上 @Param("id") 注解
@Select("select * from user where id = #{id}")
User getUserByID(@Param("id") int id);
@Insert("insert into user(id,name,pwd) values (#{id},#{name},#{password})")
int addUser(User user);
@Update("update user set name=#{name},pwd=#{password} where id = #{id}")
int updateUser(User user);
@Delete("delete from user where id = #{id}")
int deleteUser(@Param("id") int id);
}
测试类
public class UserDaoTest {
@Test
public void test1(){
SqlSession sqlSession = MybatisUtils.getSqlSession();
//底层主要应用反射
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
List allList = mapper.getAllList();
for (User user : allList) {
System.out.println(user);
}
sqlSession.close();
}
@Test
public void test2(){
SqlSession sqlSession = MybatisUtils.getSqlSession();
//底层主要应用反射
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
User userByID = mapper.getUserByID(1);
System.out.println(userByID);
sqlSession.close();
}
@Test
public void test3(){
SqlSession sqlSession = MybatisUtils.getSqlSession();
//底层主要应用反射
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
mapper.addUser(new User(5,"Hello","999"));
sqlSession.close();
}
@Test
public void test4(){
SqlSession sqlSession = MybatisUtils.getSqlSession();
//底层主要应用反射
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
mapper.updateUser(new User(5,"hhh","9988"));
sqlSession.close();
}
@Test
public void test5(){
SqlSession sqlSession = MybatisUtils.getSqlSession();
//底层主要应用反射
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
mapper.deleteUser(5);
sqlSession.close();
}
}
CREATE TABLE teacher(
id INT(10) NOT NULL,
name VARCHAr(30) DEFAULT NULL,
PRIMARY KEY(id)
)ENGINE=INNODB DEFAULT CHARSET=utf8
INSERT INTO teacher (id,name) VALUES('1','宝宝老师');
CREATE TABLE student(
id INT(10) NOT NULL,
name VARCHAr(30) DEFAULT NULL,
tid INT(10) DEFAULT NULL,
PRIMARY KEY(id),
KEY fktid (tid),
CONSTRAINT fktid FOREIGN KEY(tid) REFERENCES teacher(id)
)ENGINE=INNODB DEFAULT CHARSET=utf8
INSERT INTO student (id,name,tid) VALUES('1','冯宝宝','1');
INSERT INTO student (id,name,tid) VALUES('2','tom','1');
INSERT INTO student (id,name,tid) VALUES('3','jeck','1');
INSERT INTO student (id,name,tid) VALUES('4','李白','1');
INSERT INTO student (id,name,tid) VALUES('5','妲己','1');
测试环境搭建
1.导入lombok
org.projectlombok
lombok
1.18.16
2.新建实体类Teacher,Users
@Data
public class Users {
private Integer id;
private String name;
private Integer uid;
private teacher teacher;
}
@Data
public class teacher {
private Integer tid;
private String tname;
}
按照查询嵌套处理
public interface usersDao {
List UsersById();
List UsersById1();
usesDao.xml
测试
public class mybatistess {
@Test
public void test() {
SqlSession sqlsession = Mybatisutils.getsqlsession();
usersDao mapper = sqlsession.getMapper(usersDao.class);
List users = mapper.UsersById();
users.forEach(System.out::println);
sqlsession.close();
}
@Test
public void test2() {
SqlSession sqlsession = Mybatisutils.getsqlsession();
usersDao mapper = sqlsession.getMapper(usersDao.class);
List users = mapper.UsersById1();
users.forEach(System.out::println);
sqlsession.close();
}
}
11.一对多处理
实体类
@Data
public class users {
private Integer id;
private String name;
private Integer uid;
}
@Data
public class teacher {
private Integer tid;
private String tname;
//一个老师对应多个学生
private List users;
}
按照结果嵌套处理
teacherDao.xml
select s.id ,s.name ,t.tid,t.tname
from users s,teacher t
where s.uid=t.tid and t.tid=#{tid};
测试
public class mybatistess {
@Test
public void test(){
SqlSession sqlsession = Mybatisutils.getsqlsession();
teacherDao mapper = sqlsession.getMapper(teacherDao.class);
teacher teacher = mapper.getteacherByid(1);
System.out.println(teacher);
sqlsession.close();
}
}
小结
1.关联-association【多对一】封装对象
2.集合-collection【一对多】封装集合
3.javaType ofType
javaType:用来指定实体类中属性的类型
ofType:用来指定映射到List或者集合中的pojo类型,泛型中的约束类型!
12.动态 SQL
什么是动态SQL:动态SQL就是根据不同的条件生成不同的SQL语句
利用动态 SQL,可以彻底摆脱这种痛苦。
实体类
@Data
public class users {
private int ID;
private String NAME;
private String Profession;
}
数据库
userMap
public interface usersMap {
List getselect();
List getusers(Map map);
List getusers1(Map map);
int Updatsuser(Map map);
List querFoeach(Map map);
}
userMap.xml
select *
from suser;
select * from suser where 1=1
AND NAME = #{NAME}
AND Perfession = #{Perfession}
select *from suser
and NAME = #{NAME}
and Profession = #{Profession}
and ID=#{ID}
update suser
NAME = #{NAME}
Perfession = #{Perfession}
where ID=#{ID}
select * from suser
#{id}