[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>