初始了解mybatis

2014-01-05

初步了解mybatis初步了解MyBatis需要导入 mybatis-x.x.x.jar连接数据库为mysql导入对应数据库的 mysql-co

初步了解mybatis

初步了解MyBatis

需要导入 mybatis-x.x.x.jar;
连接数据库为mysql   导入对应数据库的 mysql-connector-java-5.1.18-bin.jar

数据库表 t_user 里面字段：id（主键、自增） name   passwod age qq
Model层里面对应的类：User
package nie.wei.qing.model;

public class User {

private int age;
private int id;
private String name;
private String password;
private String qq;
//补充getter and setter
}
Dao层，一个对数据操作的接口： UserDao
package nie.wei.qing.dao;

import java.util.List;

import nie.wei.qing.model.User;

public interface UserDao {

public User selectById(int id);   //按id查找用户
public List<User> findAll();    //查找所有用户
public void update(User user); //更新用户
public void insert(User user); //插入新的用户
public void deleteById(int id); //按照id来删除对应的用户
}

配置文件 mybatis-congig.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://localhost:3306/nie" />
<property name="username" value="root" />
<property name="password" value="root" />
</dataSource>
</environment>
</environments>
<mappers>
       
<mapper resource="MybatisUserDao.xml" />
</mappers>
</configuration>

对MySql操作的配置 MyBaitsUserDao.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="nie.wei.qing.dao.UserDao">

<select id="selectById" parameterType="int" resultType="nie.wei.qing.model.User"> 
select * from t_user where id=#{id}
</select>

<select id="findAll" resultType="nie.wei.qing.model.User"> 
select * from t_user
</select>

<update id="update" parameterType="nie.wei.qing.model.User">     
update t_user set
name=#{name},password=#{password},age=#{age},qq=#{qq} where id=#{id}
</update>

<insert id="insert" parameterType="nie.wei.qing.model.User">    
insert into t_user(name,password,age,qq)
values(#{name},#{password},#{age},#{qq})
</insert>

<delete id="deleteById" parameterType="int">    
delete from t_user where id=#{id}
</delete>
</mapper>
   Junit测试代码：
String resource = "mybatis-config.xml";    //mybatis配置文件的路径
        Reader reader = Resources.getResourceAsReader(resource);
        SqlSessionFactoryBuilder builfer = new SqlSessionFactoryBuilder();
        SqlSessionFactory factory = builfer.build(reader);
        SqlSession session = factory.openSession();
        //前面的操作是得到对应的session 有点像hibernate的操作；
        //根据配置文件得到UserDao的一个实例
        UserDao userDao = session.getMapper(UserDao.class);
        //查找对应的id来得到一个user
        User user=userDao.selectById(1);
        System.out.println(user.getName());
        //得到所有的用户
        List<User> users=userDao.findAll();
        for(int i=0;i<users.size();i++){
        System.out.println("id号是："+users.get(i).getId()+" name is :"+users.get(i).getName());
        }
        user.setPassword("99999");
        userDao.update(user);//更新相应的User
        User u=new User();
        u.setName("h");
        u.setPassword("d");
        u.setAge(23);
        u.setQq("1111");
        userDao.insert(u);//插入新用户
        userDao.deleteById(4);//根据id删除对应的用户
        session.commit();
        session.close();

热点排行

Web前端

初始了解mybatis