一.环境搭建
1.前期准备
下载
mybatis-3.1.1
Mysql 5.5
mysql 5.5驱动包
Eclipse 3.4以上
2.安装mySQL(详细安装步骤请参考mysql参考手册)本文用户和密码全部都是root
创建数据库 CREATE DATABASE mydb;
创建名为user的表 :
CREATE TABLE user (
id int(11) DEFAULT NULL,
username varchar(40) DEFAULT NULL,
password varchar(40) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8
运行Eclipse
3.在Eclipse创建名为 mybatis3 的工程并在工程下创建名为lib的文件夹。
将mybatis-3.1.1.jar与mySql的驱动包拷贝到lib目录
选中这两个jar包右击->build path-->Add to build path
至此环境搭建工作完成
二.创建类和映射文件
1.创建名为com.fly31.mybatis的包,在该包的下面创建与表相对应的类(User.java),
public class User {
private int id;
private String username;
private String password;
//get&set本例中不做描述
}
2.创建操作类接口
public interface UserMapper {
//可以通过注入的方式生成映射本例不采用,本例采用Xml映射方式
//@Select("select * from user where username = #{username}")
User getUser(String username);
}
3.在src目录下创建总映射文件(MySqlConfig.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> <typeAliases> <!--给实体类起一个别名 user --> <typeAlias type="com.fly31.mybatis.User" alias="User" /> </typeAliases> <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://localhost/mydb" /> <property name="username" value="root" /> <property name="password" value="root" /> </dataSource> </environment> </environments> <mappers> <mapper resource="user.xml" /> </mappers> </configuration>
4.在src目录下创建user映射文件(user.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.fly31.mybatis.UserMapper"> <!-- 下面这段代码可有可无,如果没有的话可以在mapper类中通过注解的方式实现 --> <select id="getUser" parameterType="java.lang.String" resultType="User"> select * from user where username = #{username} </select> </mapper>
5.创建名为com.fly31.utils包,并在该包下面创建名为MyBatisUtil.java的工具类(为以后拿SqlSession做准备)
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 MyBatisUtil {
private static SqlSessionFactory sqlSessionFactory = null;
static {
String resource = "MySqlConofig.xml";
Reader reader = null;
try {
reader = Resources.getResourceAsReader(resource);
sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
} catch (IOException e) {
System.out.println(e.getMessage());
} finally {
try {
if (reader != null)
reader.close();
} catch (IOException e) {
throw new RuntimeException("reader 关闭失败");
}
}
}
public static SqlSessionFactory getSqlSessionFactory() {
return sqlSessionFactory;
}
public static SqlSession getSession() {
return sqlSessionFactory.openSession();
}
public static SqlSession getSession(boolean b) {
return sqlSessionFactory.openSession(b);
}
}
至此用mybatis完成user类的操作已经完成。
三.测试(我这里暂时不用junit,就用一个main函数打印出来吧)
测试类就创建在com.fly31.mybatis包下面吧。类名就叫Test.java吧
先用sql插入一条数据
insert into user(id,username,password)
values(1,'aaa','123');
import org.apache.ibatis.session.SqlSession;
import com.fly31.utils.MyBatisUtil;
public class Test {
public static void main(String args[]) throws Exception {
// 获取SqlSession
SqlSession session = MyBatisUtil.getSession();
// 获取Mapper
UserMapper userMapper = session.getMapper(UserMapper.class);
// 执行sql
User user = userMapper.getUser("aaa");
if (user != null) {
System.out.println("username:" + user.getUsername() + ", password:"
+ user.getPassword());
}
session.close();
}
}
以application方式运行就可。如果在控制台打印出了相关信息,
那就恭喜你,已经入门啦!