控制台输出mysql语句_mybatis查询入门(log4j控制台sql语句日记输出的)

先看demo的结构,可以先讲数据库建立起来,下面有代码里面有数据库sql语句数据库建模好之后,只要运行junit下面的test目录下面的相应方法,注意去掉ignore

数据库的模型图

import java.io.FileNotFoundException;

import java.io.IOException;

import java.io.Reader;

import org.apache.ibatis.io.Resources;

import org.apache.ibatis.session.SqlSessionFactory;

import org.apache.ibatis.session.SqlSessionFactoryBuilder;

/**

* MyBatis Connection Factory, which reads the configuration data from a XML file.

* static只读取一次xml配置文件

* @author Loiane Groner

* http://loianegroner.com (English)

* http://loiane.com (Portuguese)

*/

public class MyBatisConnectionFactory {

private static SqlSessionFactory sqlSessionFactory;

static {

try {

String resource = "SqlMapConfig.xml";

Reader reader = Resources.getResourceAsReader(resource);

if (sqlSessionFactory == null) {

sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);

}

}

catch (FileNotFoundException fileNotFoundException) {

fileNotFoundException.printStackTrace();

}

catch (IOException iOException) {

iOException.printStackTrace();

}

}

public static SqlSessionFactory getSqlSessionFactory() {

return sqlSessionFactory;

}

}

/p>

PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

resultType="Article">

SELECT id, title, author

FROM article

WHERE id_status = 1

AND title LIKE #{title}

resultType="Article">

SELECT id, title, author

FROM article

WHERE id_status = 1

AND title LIKE #{title}

AND author LIKE #{author}

resultType="Article">

SELECT id, title, author

FROM article

WHERE id_status = 1

AND title LIKE #{title}

AND author LIKE #{author}

AND id_category = 3

resultType="Article">

SELECT id, title, author

FROM article

title LIKE #{title}

OR author LIKE #{author}

resultType="Article">

SELECT id, title, author

FROM article

title LIKE #{title}

AND author LIKE #{author}

SELECT id, title, author

FROM article

WHERE id_category IN

open="(" separator="," close=")">

#{category}

分享到：

2012-08-19 09:25

浏览 7083

评论

2 楼

wangxuehui

2012-12-28

什么意思？？

1 楼

青春的、脚步

2012-12-28