1.1lombokmysql mysql-connector-java8.0.28 org.mybatis mybatis3.5.9 org.projectlombok lombok1.18.24 junit junit4.13.2 log4j log4j1.2.17
它可以帮助生成实体类的get和set方法 而且可以帮你生成构造方法。重写toString方法
(1)首先进行此插件下载
(2) 工程中引入lombok依赖(上图代码展示)
(3)在实体类上添加lombok注解。
@Data //set和get方法以及toString方法
@NoArgsConstructor //无参构造方法
@AllArgsConstructor //所有参数的构造方法
public class User {
private int userid;
private String username;
private String realname;
}
2. 在src下的main文件夹下添加java,resources
3.在java,resources下进行功能添加
3.1添加 Mybatis 的配置文件conf.xml
3.1.1为实体类起别名给
mybatis.xml配置文件
3.2定义操作 users 表的 sql 映射文件 userMapper.xml
注意:在操作不同的表操作时注意要使用对应的语句,例如更新
3.3添加sql日志
添加日志的文件配置--log4j.properties必须
log4j.rootLogger=DEBUG, Console #Console log4j.appender.Console=org.apache.log4j.ConsoleAppender log4j.appender.Console.layout=org.apache.log4j.PatternLayout log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n log4j.logger.java.sql.ResultSet=INFO log4j.logger.org.apache=INFO log4j.logger.java.sql.Connection=DEBUG log4j.logger.java.sql.Statement=DEBUG log4j.logger.java.sql.PreparedStatement=DEBUG
以上方法为了方便直接设置全局,方法如下
mapper对应模板代码
config.xml模板
4.java代码
4.1接口userMapper
4.2测试类
package com.qy151wd;
import com.qy151wd.entity.User;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Test;
import java.io.Reader;
import java.util.List;
public class Test01 {
@Test
public void testGetOne() throws Exception{
String reader="conf.xml";
//注意此处包不要导错
//1.读取mybatis配置文件的内容----未来不需要写tomcat 解析配置文件
Reader resource = Resources.getResourceAsReader(reader);
//2. 获取SqlSessionFactory对象
SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(resource);
//3. 获取SqlSession对象----封装了对数据库操作的各种方法
SqlSession sqlSession=sqlSessionFactory.openSession();
//此处要写方法
User o = sqlSession.selectOne("com.qy151wd.mapper.userMapper.getUser", 1);
System.out.println(o);
}
@Test
public void testFindAll() throws Exception{
String reader="conf.xml";
Reader resource = Resources.getResourceAsReader(reader);
SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(resource);
SqlSession sqlSession=sqlSessionFactory.openSession();
//此处要写方法
List o = sqlSession.selectList("com.qy151wd.mapper.userMapper.findAll");
for (User u:o
) {
System.out.println(u.getId()+"t"+u.getUername()+"t"+u.getPassword());
}
}
@Test
public void testupdate() throws Exception{
String reader="conf.xml";
Reader resource = Resources.getResourceAsReader(reader);
SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(resource);
SqlSession sqlSession=sqlSessionFactory.openSession();
User u=new User(12,"轻轻","111111");
sqlSession.update("com.qy151wd.mapper.userMapper.updateUser", u);
//只要更改表就要使用commit
sqlSession.commit();
sqlSession.close();
}
@Test
public void testdelete() throws Exception{
String reader="conf.xml";
Reader resource = Resources.getResourceAsReader(reader);
SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(resource);
SqlSession sqlSession=sqlSessionFactory.openSession();
sqlSession.delete("com.qy151wd.mapper.userMapper.deleteUser", 12);
sqlSession.commit();
sqlSession.close();
}
@Test
public void testinsert() throws Exception{
String reader="conf.xml";
Reader resource = Resources.getResourceAsReader(reader);
SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(resource);
SqlSession sqlSession=sqlSessionFactory.openSession();
User user=new User("小艾张","235689");
sqlSession.insert("com.qy151wd.mapper.userMapper.insertUser", user);
sqlSession.commit();
sqlSession.close();
}
}



