[bigdata-077] maven+mybatis+mysql 数据库 mybatis xml文件方式 示例

1. 在eclipse创建安一个maven项目

2. 给pom增加依赖

<dependency>
    	<groupId>org.mybatis</groupId>
    	<artifactId>mybatis</artifactId>
    	<version>3.4.4</version>
    </dependency>
    <dependency>
    	<groupId>mysql</groupId>
    	<artifactId>mysql-connector-java</artifactId>
    	<version>5.1.25</version>
    </dependency>

3. 项目的目录和文件结构

├── config
│   ├── com
│   │   └── tttzzz
│   │       └── demo
│   │           └── mybatisxml
│   │               └── UserDaoMapper.xml
│   └── MyBatis-Configuration.xml
├── pom.xml
├── src
│   ├── main
│   │   └── java
│   │       └── com
│   │           └── tttzzz
│   │               └── demo
│   │                   └── mybatisxml
│   │                       ├── App.java
│   │                       ├── UserDao.java
│   │                       └── User.java

4. App.java文件内容如下：

package com.tttzzz.demo.mybatisxml;

import java.io.IOException;
import java.io.Reader;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

public class App 
{
    public static void main( String[] args ) throws IOException
    {
    	String resource = "MyBatis-Configuration.xml";
    	Reader reader = Resources.getResourceAsReader(resource);
    	SqlSessionFactoryBuilder builfer = new SqlSessionFactoryBuilder();
    	SqlSessionFactory factory = builfer.build(reader);
    	SqlSession session = factory.openSession();
    	
    	UserDao userDao = session.getMapper(UserDao.class);
    	//查询数据库中记录总数
    	System. out .println("数据库中的记录数:" + userDao.countAll());
    	session.commit();
    }
}

5. UserDao.java 内容如下

package com.tttzzz.demo.mybatisxml;

public interface UserDao {

	public int insert(User user);
	public int countAll();

}

6. User.java内容如下

package com.tttzzz.demo.mybatisxml;

public class User {
	
	private int id;
	private String usename;
	
	public int getId() {
		return id;
	}
	
	public void setId(int id) {
		this.id = id;
	}
	
	public String getUsename() {
		return usename;
	}
	
	public void setUsename(String usename) {
		this.usename = usename;
	}
	
}

7. UserDaoMapper.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.tttzzz.demo.mybatisxml.UserDao">
	<select id="countAll" resultType="int">
		<!-- 查询表中记录总数 -->
		select count(*) c from tb_user;
	</select>
</mapper>

8.MyBatis-Configuration.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>
  <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://192.168.1.22:3306/pyspiderdb?useUnicode=true&characterEncoding=UTF8"/>
        <property name= "username" value= "root" />
        <property name= "password" value= "t8" />
      </dataSource>
    </environment>
  </environments>
  <mappers>
    <mapper resource= "com/tttzzz/demo/mybatisxml/UserDaoMapper.xml" />
  </mappers>
</configuration>