mybatis入门

使用maven管理mybatis 创建一个maven项目目录结构如下： 配置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> <typeAliases> <typeAlias type="com.penghui.demo.mybatis.bean.Student" alias="Student"/> <typeAlias type="com.penghui.demo.mybatis.bean.author" alias="author"/> </typeAliases> <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://localhost:3306/test"/> <property name="username" value="root"/> <property name="password" value="123456"/> </dataSource> </environment> </environments> </configuration>

log4j.propertis

### 设置### 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 ### 输出infor 级别以上的日志到=f://logs/infor.log ### log4j.appender.D = org.apache.log4j.DailyRollingFileAppender log4j.appender.D.File = f://logs/infor.log log4j.appender.D.Append = true log4j.appender.D.Threshold = INFO 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 ### 输出DEBUG 级别以上的日志到=f://logs/error.log ### log4j.appender.D = org.apache.log4j.DailyRollingFileAppender log4j.appender.D.File = f://logs/debug.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 ### 输出ERROR 级别以上的日志到=f://logs/error.log ### log4j.appender.E = org.apache.log4j.DailyRollingFileAppender log4j.appender.E.File =f://logs/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

APPSelect.测试类

package com.penghui.demo.mybatis; import java.io.InputStream; import java.util.List; 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 com.penghui.demo.mybatis.bean.Student; public class AppSelect { public static void main(String[] args) { // TODO Auto-generated method stub String resource = "mybatis-config.xml"; InputStream inputsream; try{ inputsream = Resources.getResourceAsStream(resource); SqlSessionFactory sqlsession = new SqlSessionFactoryBuilder().build(inputsream); SqlSession session = sqlsession.openSession(); try{ List<Student> list = session.selectList("selectMap"); for (Student student : list) { System.out.print("姓名："+student.getName()); System.out.print("密码："+student.getPassword()); System.out.println(); } session.commit(); }catch(Exception e){ e.printStackTrace(); }finally { session.close(); } }catch(Exception e){ e.printStackTrace(); } } }

Mapper文件代理

<?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.penghui.demo.mybatis.mapper.StudentMapper"> <select id="selectList" resultType="Student"> select * from student </select> </mapper>

pojo实体类

package com.penghui.demo.mybatis.bean; public class Student { private String name; private String password; private String id; public String getName() { return name; } public void setName(String name) { this.name = name; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } public String getId() { return id; } public void setId(String id) { this.id = id; } @Override public String toString() { return "Student [name=" + name + ", password=" + password + ", id=" + id + "]"; } }

测试结果如下：