一个简单的三层架构包含关系图
实体类Student.java中的内容:
@NoArgsConstructor
@Getter
@Setter
@ToString
public class Student {
private Integer id;
private String name;
private Integer age;
public Student(String name, Integer age) {
super();
this.name = name;
this.age = age;
}
}
测试类MyView.java中的内容:
IStudentService service = new StudentServiceImpl();
Student student = new Student("口口", 23);
service.addStudent(student);
IStudentService接口:
public interface IStudentService {
void addStudent(Student student);
}
StudentServiceImpl实现类:
public class StudentServiceImpl implements IStudentService {
IStudentDao dao = new StudentDaoImpl();
@Override
public void addStudent(Student student) {
dao.insertStudent(student);
}
}
IStudentDao接口:
public interface IStudentDao {
void insertStudent(Student student);//插入
}
StudentDaoImpl实现类:
public class StudentDaoImpl implements IStudentDao {
private SqlSession session;
@Override
public void insertStudent(Student student) {
try {
//1、加载主配置文件
InputStream inputStream = Resources.getResourceAsStream("mybatis.xml");
//2、创建SqlSessionFactory对象
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(inputStream);
//3、创建SqlSession对象
SqlSession session = factory.openSession();
//4、操作
session.insert("insertStu",student);
//5、提交
session.commit();
} catch (IOException e) {
e.printStackTrace();
}finally {
if (session != null) {
//6、关闭
session.close();
}
}
}
}
此时mapper.xml配置文件中insert标签的id属性值应与session.insert(“insertStu”,student);中的第一个参数保持一致。
若有多个mapper.xml文件,应指定具体的mapper.xml文件。
做法是session.insert(“namespace名称.insertStu”,student);
mapper.xml配置文件:
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="test">
<insert id="insertStu" parameterType="com.beans.Student">
insert into student(name,age) value (#{name}, #{age})
</insert>
</mapper>
mybatis.xml主配置文件:
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC" />
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver" />
<property name="url" value="jdbc:mysql:///test"/>
<property name="username" value="root" />
<property name="password" value="root"/>
</dataSource>
</environment>
</environments>
<!-- 注册映射文件 -->
<mappers>
<mapper resource="com/dao/mapper.xml" />
</mappers>
</configuration>
现在并不能成功向数据库插入信息,需要配置日志文件
导入jar包:log4j-1.2.17.jar
添加日志配置文件:log4j.properties
运行测试类可看见控制台上显示的日志信息:
如果想简化日志信息的显示内容,可在日志配置文件log4j.properties中修改。
添加一句log4j.logger.test=trace,console,注释掉以前的。
其中log4j.logger后跟的内容是mapper.xml文件中namespace属性名称。
简化后
现在的结构