官网下载MyBatis jar包项目中直接导入即可,下载地址:MyBatis下载地址 另外导入自己用的数据库的驱动包以及log4j的jar包。
目录截图如下:
数据库的格式:
数据库对应的实体类User.java
package org.fkit.domain; public class User { private Integer id; private String name; private String sex; private Integer age; public User(){ super(); } public User(String name,String sex,Integer age){ super(); this.name=name; this.sex=sex; this.age=age; } public Integer getId() { return id; } public void setId(Integer id) {
<?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="org.fkit.mapper.UserMapper"> <insert id="save" parameterType="org.fkit.domain.User" useGeneratedKeys="true"> insert into tb_user(name,sex,age) values (#{name},#{sex},#{age}) </insert> </mapper>
this.id = id;}public String getName() {return name;}public void setName(String name) {this.name = name;}public String getSex() {return sex;}public void setSex(String sex) {this.sex = sex;}public Integer getAge() {return age;}public void setAge(Integer age) {this.age = age;}} 映射文件UserMapper.XMLMyBatis的配置文件mybatis-config.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="org.fkit.mapper.UserMapper"> <insert id="save" parameterType="org.fkit.domain.User" useGeneratedKeys="true"> insert into tb_user(name,sex,age) values (#{name},#{sex},#{age}) </insert> </mapper>
<?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> <settings> <setting name="logImpl" value="LOG4J"/> </settings> <environments default="mysql"> <environment id="mysql"> <transactionManager type="JDBC"/> <dataSource type="POOLED"> <property name="driver" value="com.mysql.jdbc.Driver"/> <property name="url" value="jdbc:mysql://localhost:3306/mybatis"/> <property name="username" value="root"/> <property name="password" value="cptbtptp89757"/> </dataSource> </environment> </environments> <mappers>
测试类:<mapper resource="org/fkit/mapper/UserMapper.xml"/> </mappers> </configuration>
log4j.properties用于控制台输出信息package org.fkit.test; 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.fkit.domain.User; public class MyBatisTest { public static void main(String[] args) throws Exception{ InputStream inputStream=Resources.getResourceAsStream("mybatis-config.xml"); SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(inputStream); SqlSession session=sqlSessionFactory.openSession(); User user=new User("admin","男",26); session.insert("org.fkit.mapper.UserMapper.save",user); session.commit(); session.close(); } }
运行结果:# Global logging configuration log4j.rootLogger=ERROR, stdout # MyBatis logging configuration... log4j.logger.org.fkit.test=TRACE log4j.logger.org.fkit.mapper.UserMapper.save=TRACE # Console output... log4j.appender.stdout=org.apache.log4j.ConsoleAppender log4j.appender.stdout.layout=org.apache.log4j.PatternLayout log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n
数据库结果: