如何配置mybatis开发环境

1、打开MyEclipse或者Eclipse，新建一个JavaProject项目mybatis

2、下载所需jar包http://pan.baidu.com/s/1mgmtNcs，右键点击项目依次选择New--Folder，此时弹出对话框，Folder name填写lib。复制jar包粘贴到lib文件夹，展开lib文件夹，选中2个jar包，右键点击jar包，依次选择Build Path--Add to Path。

3、打开SQL Server 2008查询分析器，创建mybatis数据库create database mybatis选择mybatis数据库，创建users表create table users(userId int identity(1,1) primary key,userName varchar(50) not null,userPassword char(32) not null,userBal int default 0)

4、在mybatis项目下创建cn.hans.mybatis.domain、cn.hans.mybatis.mapper、cn.hans.mybatis.test

5、在cn.hans.mybatis.domain包下创建类Userpackage cn.hans.mybatis.domain;public class User {private Integer userId; private String userName; private String userPassword; // account balance 账户余额 private Integer userBal; public User(){ } public Integer getUserId() { return userId; } public void setUserId(Integer userId) { this.userId = userId; } public String getUserName() { return userName; } public void setUserName(String userName) { this.userName = userName; } public String getUserPassword() { return userPassword; } public void setUserPassword(String userPassword) { this.userPassword = userPassword; } public Integer getUserBal() { return userBal; } public void setUserBal(Integer userBal) { this.userBal = userBal; } }

6、在cn.hans.mybatis.mapper包下创建接口UserMapperpa罕铞泱殳ckage cn.ha荏鱿胫协ns.mybatis.mapper;import cn.hans.mybatis.domain.User;public interface UserMapper{public User selectUser(Integer userId); public void insertUser(User user); public void updateUser(User user); public void deleteUser(Integer userId); }配置文件UserMapper.xml<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE mapper PUBLIC "-//ibatis.apache.org//DTD Mapper 3.0//EN" "http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd"><mapper namespace="cn.hans.mybatis.mapper.UserMapper"> <select id="selectUser" parameterType="Integer" resultType="cn.hans.mybatis.domain.User"> select *from users where userId = #{userId} </select> <insert id="insertUser" parameterType="cn.hans.mybatis.domain.User"> insert into users (userName,userPassword,userBal) values (#{userName},#{userPassword},#{userBal}) </insert> <update id="updateUser" parameterType="cn.hans.mybatis.domain.User"> update users set userName=#{userName},userPassword=#{userPassword},userBal=#{userBal} where userId=#{userId} </update> <delete id="deleteUser" parameterType="Integer"> delete from users where UserId=#{userId} </delete></mapper>

7、在项目根目录创建数据库配置文件db.propertiesjdbc.driver=com.microsoft.sqlserver.枣娣空郅jdbc.SQLServerDriverjdbc.url=jdbc:sqlserver://localhost:1433;databaseName=mybatisjdbc.username=adminjdbc.password=adminmybatis配置文件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> <properties resource="db.properties"/> <environments default="development"> <environment id="development"> <transactionManager type="JDBC"/> <dataSource type="POOLED"> <property name="driver" value="${jdbc.driver}"/> <property name="url" value="${jdbc.url}"/> <property name="username" value="${jdbc.username}"/> <property name="password" value="${jdbc.password}"/> </dataSource> </environment> </environments> <mappers> <mapper resource="cn/hans/mybatis/mapper/UserMapper.xml" /></mappers> </configuration>

8、在cn.hans.mybatis.test下创建类MybatisTestpackage cn.hans.mybatis.test;import java.io.IOException;import org.apache.ibatis.io.Resources;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;import cn.hans.mybatis.domain.User;import cn.hans.mybatis.mapper.UserMapper;public class MybatisTest { public static void main(String[] args) throws IOException{ SqlSessionFactory ssf=new SqlSessionFactoryBuilder() .build(Resources.getResourceAsReader("Configuration.xml")); SqlSession session=ssf.openSession(); UserMapper userMapper=session.getMapper(UserMapper.class); User user=new User(); user.setUserName("test001"); user.setUserPassword("12345678123456781234567812345678"); user.setUserBal(50); userMapper.insertUser(user); session.commit(); session.close(); }}

9、运行MybatisTest，打开SQL Server 2008，查询mybatis数据库下数据表users。如果现实如下，则配置成功。