[bigdata-076] maven+mybatis+mysql 数据库 mybatis注解方式 示

1. 官网
http://www.mybatis.org/mybatis-3/zh/index.html


2. 创建一个maven项目


3. 增加mybatis的依赖和mysql的依赖
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.4</version>




4. 创建mysql表
192.168.1.34的pyspiderdb这个库，然后创建表格
create table tb_user(id int primary key auto_increment,username varchar(40) not null);
insert into tb_user (username) values('brian');
insert into tb_user (username) values('tim');




5. 在maven项目进行操作
5.1 目录结构
├── config
│ ? └── MyBatis-Configuration.xml
├── pom.xml
├── src
│ ? ├── main
│ ? │ ? └── java
│ ? │ ? ? ? └── com
│ ? │ ? ? ? ? ? └── tttiii
│ ? │ ? ? ? ? ? ? ? └── demo
│ ? │ ? ? ? ? ? ? ? ? ? └── demo_mybatis
│ ? │ ? ? ? ? ? ? ? ? ? ? ? ├── App.java
│ ? │ ? ? ? ? ? ? ? ? ? ? ? ├── DBHelper.java
│ ? │ ? ? ? ? ? ? ? ? ? ? ? ├── UserDao.java
│ ? │ ? ? ? ? ? ? ? ? ? ? ? └── User.java




5.2 App.java

package com.ttss.demo.demo_mybatis;


import java.io.Reader;
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;




public class App 
{
    public static void main( String[] args )
    {
        SqlSession session = DBHelper. getInstance ().getSqlSession();
        UserDao userDao = session.getMapper(UserDao.class);
        System. out .println("数据库中的记录数:" + userDao.countAll());
    }
    
}

5.3 DBHelper.java

package com.ttss.demo.demo_mybatis;


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 DBHelper {


private static DBHelper dbHelper = new DBHelper();
private SqlSessionFactory sqlSessionFactory = null;


private DBHelper() {
try {
String resource = "MyBatis-Configuration.xml"; // mybatis配置文件的路径
Reader reader = Resources.getResourceAsReader(resource);
SqlSessionFactoryBuilder builfer = new SqlSessionFactoryBuilder();
sqlSessionFactory = builfer.build(reader);
sqlSessionFactory.getConfiguration().addMapper(UserDao.class);
} catch (IOException e) {
e.printStackTrace();
}
}


public static DBHelper getInstance() {
return dbHelper;
}


public SqlSession getSqlSession() {
return sqlSessionFactory.openSession();
}
}

5.4 UserDao.java

package com.ttss.demo.demo_mybatis;


import java.util.List;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;


public interface UserDao {

@Select("select count(*) from tb_user")
public int countAll();


}

5.5 User.java

package com.ttss.demo.demo_mybatis;


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;
}

}

5.6 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.34:3306/pyspiderdb?useUnicode=true&characterEncoding=UTF8"/>
        <property name= "username" value= "root" />
        <property name= "password" value= "ttss88" />
      </dataSource>
    </environment>
  </environments>
</configuration>

5.7 pom.xml的内容

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>


  <groupId>com.ttss.demo</groupId>
  <artifactId>demo-mybatis</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <packaging>jar</packaging>


  <name>demo-mybatis</name>
  <url>http://maven.apache.org</url>


  <properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  </properties>


  <dependencies>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>3.8.1</version>
      <scope>test</scope>
    </dependency>
    <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>
  </dependencies>
</project>

6.推荐下，beetlsql