怎么如何配置mybatis开发环境

MyEclipse

mybatis，sql的jar包

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

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

打开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

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

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

在cn.hans.mybatis.mapper包下创建接口UserMapperpackage cn.hans.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           select *from users where userId = #{userId}                insert into users (userName,userPassword,userBal) values (#{userName},#{userPassword},#{userBal})                update users set userName=#{userName},userPassword=#{userPassword},userBal=#{userBal} where userId=#{userId}                delete from users where UserId=#{userId}   

在项目根目录创建数据库配置文件db.propertiesjdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriverjdbc.url=jdbc:sqlserver://localhost:1433;databaseName=mybatisjdbc.username=adminjdbc.password=adminmybatis配置文件Configuration.xml                                           

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