mybatis入门程序开发步骤教程

mybatis入门程序

新建maven项目

配置项目jdk

pom.xml导入依赖,非maven项目则导入jar包

<dependencies> <!-- mybatis依赖包 --> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.5.3</version> </dependency> <!-- 数据库驱动连接包 --> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.47</version> </dependency> <!-- log4j日志记录包 --> <dependency> <groupId>log4j</groupId> <artifactId>log4j</artifactId> <version>1.2.17</version> </dependency> </dependencies> 配置log4j文件 如果没有可以新建一个 log4j.properties log4j.rootLogger = debug,stdout,D,E log4j.appender.stdout = org.apache.log4j.ConsoleAppender log4j.appender.stdout.Target = System.out log4j.appender.stdout.layout = org.apache.log4j.PatternLayout log4j.appender.stdout.layout.ConversionPattern = [%-5p] %d{yyyy-MM-dd HH:mm:ss,SSS} method:%l%n%m%n log4j.appender.D = org.apache.log4j.DailyRollingFileAppender log4j.appender.D.File = E://logs//mybatis//log.log log4j.appender.D.Append = true log4j.appender.D.Threshold = DEBUG log4j.appender.D.layout = org.apache.log4j.PatternLayout log4j.appender.D.layout.ConversionPattern = %-d{yyyy-MM-dd HH:mm:ss} [ %t:%r ] - [ %p ] %m%n log4j.appender.E = org.apache.log4j.DailyRollingFileAppender log4j.appender.E.File =E://logs//mybatis//error.log log4j.appender.E.Append = true log4j.appender.E.Threshold = ERROR log4j.appender.E.layout = org.apache.log4j.PatternLayout log4j.appender.E.layout.ConversionPattern = %-d{yyyy-MM-dd HH:mm:ss} [ %t:%r ] - [ %p ] %m%n 创建数据库和表 DROP TABLE IF EXISTS `employee`; CREATE TABLE `employee` ( `empid` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(55) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `gender` int(1) DEFAULT NULL, `birthday` date DEFAULT NULL, `mobile` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `email` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `position` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `note` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, PRIMARY KEY (`empid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of employee -- ---------------------------- INSERT INTO `employee` VALUES (1, '张三', 1, '1999-10-01', '13554875022', '3265487955@qq.com', '前端工程师', NULL); INSERT INTO `employee` VALUES (2, '王五', 1, '2020-10-05', '13654458553', '123456@qq.com', '大数据工程师', '新增'); INSERT INTO `employee` VALUES (3, '李刚', 1, '2020-10-02', '12554415223', '2336525412@qq.com', 'java工程师', NULL); INSERT INTO `employee` VALUES (4, '王超', 1, '1999-06-30', '13555288510', '255561223@qq', 'python工程师', NULL); INSERT INTO `employee` VALUES (5, '李欣', 0, '2000-10-02', '13655144012', '125456585@qq.com', 'java工程师', NULL); INSERT INTO `employee` VALUES (18, '李四', 1, '2020-10-07', '1365445855', '123456@qq.com', '工程师', '新增'); SET FOREIGN_KEY_CHECKS = 1; 创建持久化类（实体类pojo） public class Employee implements Serializable { private static final long serialVersionUID = 1L; private Integer empId; private String name; private Integer gender; private Date birthday; private String mobile; private String email; private String position; private String note; public Integer getEmpId() { return empId; } public void setEmpId(Integer empId) { this.empId = empId; } public String getName() { return name; } public void setName(String name) { this.name = name; } public Integer getGender() { return gender; } public void setGender(Integer gender) { this.gender = gender; } public Date getBirthday() { return birthday; } public void setBirthday(Date birthday) { this.birthday = birthday; } public String getMobile() { return mobile; } public void setMobile(String mobile) { this.mobile = mobile; } public String getEmail() { return email; } public void setEmail(String email) { this.email = email; } public String getPosition() { return position; } public void setPosition(String position) { this.position = position; } public String getNote() { return note; } public void setNote(String note) { this.note = note; } @Override public String toString() { return "Employee [empId=" + empId + ", name=" + name + ", gender=" + gender + ", birthday=" + birthday + ", mobile=" + mobile + ", email=" + email + ", position=" + position + ", note=" + note + "]"; } public Employee(String name, Integer gender, Date birthday, String mobile, String email, String position, String note) { super(); this.name = name; this.gender = gender; this.birthday = birthday; this.mobile = mobile; this.email = email; this.position = position; this.note = note; } public Employee() { super(); } } 创建mybatis映射文件(xxxmapper.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="com.zwh.mapper.EmployeeMapper"> </mapper> 映射文件中编写sql语句 <?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="com.zwh.mapper.EmployeeMapper"> <select id="selectEmployee" parameterType="Integer" resultType="com.zwh.pojo.Employee"> select * from employee where empid=#{empId} </select> </mapper> 创建mybatis核心配置文件(mybatis-config.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> <!-- 配置环境，指定默认的环境 id --> <environments default="mysql"> <!-- 配置 environment 元素定义的环境 id --> <environment id="mysql"> <!-- 事务管理器的配置，使用JDBC事务管理器 --> <transactionManager type="JDBC"></transactionManager> <!-- 数据源的配置，使用数据库连接池 --> <dataSource type="POOLED"> <property name="driver" value="com.mysql.jdbc.Driver" /> <property name="url" value="jdbc:mysql://127.0.0.1:3306/mybatisdb?characterEncoding=utf-8" /> <property name="username" value="root" /> <property name="password" value="123456" /> </dataSource> </environment> </environments> <!-- 配置映射文件mapper.xml的位置 --> <mappers> <mapper resource="com/zwh/mapper/EmployeeMapper.xml" /> </mappers> </configuration> 编写测试类 import java.io.IOException; import java.io.InputStream; 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; public class test { @Test public void selectEmployee() throws IOException { /* 读取配置文件 */ InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml"); /* 根据配置文件构建SqlSessionFactory会话工厂 */ SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream); /* 通过SqlSessionFactory创建SqlSession */ SqlSession sqlSession = sqlSessionFactory.openSession(); /* SqlSession执行映射文件中自定义的SQL，并返回映射结果 */ try { Employee employee = sqlSession.selectOne("com.zwh.mapper.EmployeeMapper.selectEmployee", 1); System.out.println(employee); } finally { /*关闭SqlSession*/ sqlSession.close(); } } }