Mybatis入门-环境搭建(一)

1.首先下配置下maven项目所依赖的jar包

org.mybatis
mybatis
3.5.3

mysql
mysql-connector-java
5.1.8

junit
junit
4.12

org.slf4j
slf4j-log4j12
1.6.1

src/main/java

/*.xml

true


src/main/resources

/.xml
**/.properites

2.创建SqlMapConfig.xml全局配置文件模板
我们这里首先要再idea中配置模板文件 点击file->settings—>editor—>file and code templates->file tab页的+号

3.创建SqlMapper.xml映射文件模板

select * from Blog where id = #{id}

然后设置网址 点击file->settings—>language & frameworks->schemas and dtds（网址内容可以在模板文件中找到）
添加：http://mybatis.org/dtd/mybatis-3-config.dtd
添加：http://mybatis.org/dtd/mybatis-3-mapper.dtd

4.rescources文件夹下创建SqlMapConfig.xml全局配置文件
配置文件中填写的四要素就是jdbc连接数据库的四要素，创建完成后xml环境信息如下

<!-这里是加载mapper映射文件的-->

5.java文件夹下创建实体类

public class Dept {

private int deptno;

private String dname;

private String loc;

public int getDeptno() {
return deptno;
}

public void setDeptno(int deptno) {
this.deptno = deptno;
}

public String getDname() {
return dname;
}

public void setDname(String dname) {
this.dname = dname;
}

public String getLoc() {
return loc;
}

public void setLoc(String loc) {
this.loc = loc;
}

public Dept() {
}

public Dept(int deptno, String dname, String loc) {
this.deptno = deptno;
this.dname = dname;
this.loc = loc;
}
}

实体类的信息要和数据库表字段信息一致

6.rescources文件夹下创建SqlMapper.xml映射文件

select * from dept

8.加载log4j类

public class initLogRecord {
public static void initLog() {
FileInputStream fileInputStream = null;
try {
Properties properties = new Properties();
fileInputStream = new FileInputStream("src/main/resources/log4j.properites");
properties.load(fileInputStream);
PropertyConfigurator.configure(properties);
} catch (Exception e) {
e.printStackTrace();
} finally {
if (fileInputStream != null) {
try {
fileInputStream.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
}
}

9.log4j.properties

log4j.rootLogger=debug, stdout, R

log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout

Pattern to output the caller's file name and line number.

log4j.appender.stdout.layout.ConversionPattern=%5p [%t] (%F:%L) - %m%n

log4j.appender.R=org.apache.log4j.RollingFileAppender
log4j.appender.R.File=example.log

log4j.appender.R.MaxFileSize=100KB
# Keep one backup file
log4j.appender.R.MaxBackupIndex=5

log4j.appender.R.layout=org.apache.log4j.PatternLayout
log4j.appender.R.layout.ConversionPattern=%p %t %c - %m%n

10.测试类

public class MyBatisTest {
private SqlSessionFactory factory;

@Test
public void testSelectAllDept() throws IOException {
//获取session对象，返回结果
SqlSession session = factory.openSession();
List list = session.selectList("selectAllDept");
for (Dept dept : list) {
System.out.println(dept.getDeptno() + "," + dept.getDname() + "," + dept.getLoc());
}
session.close();
}

@Before
public void factoryInit() throws IOException{
initLogRecord.initLog();
//加载配置文件
InputStream resource = Resources.getResourceAsStream("SqlMapConfig.xml");
SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
factory = builder.build(resource);
}
}

运行结果