Mybatis学习（1）

1.首先去网站下载包下载相关Mybatis包和Mysql包，我已经整合好了 。可以到这里下载点击打开链接

2新建一个java项目，首先导入相关包。

3首先在src文件下新建一个mybatis-config.xml文件（可以修改）里面的内容可以参照官网里面 http://www.mybatis.org/mybatis-3/zh/getting-started.html 中做修改。里面的envirments中是配置环境，里面的envirment是其中只一个环境，连接一个数据库，里面有相关的数据库，url，用户，密码。

<?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"></properties>
  <environments default="development">
    <environment id="users">
      <transactionManager type="JDBC"/>
      <dataSource type="POOLED">
        <property name="driver" value="${db.driver}"/>
        <property name="url" value="${db.url}"/>
        <property name="username" value="${db.username}"/>
        <property name="password" value="${db.password}"/>
      </dataSource>
    </environment>
  </environments>
  <mappers>
    <mapper resource="javastudy/userMapper.xml"/>
  </mappers>
</configuration>

可以新建一个文件db.properties中存取这些信息。

db.driver=com.mysql.jdbc.Driver
db.url=jdbc:mysql://localhost/user?useUnicode=true&characterEncoding=utf8
db.username=admin
db.password=123456

4.增加实体类

package javastudy;

public class User {
  private int id;
  private String userName;
  private String userPwd;
public int getId() {
	return id;
}
public void setId(int id) {
	this.id = id;
}
public String getUserName() {
	return userName;
}
public void setUserName(String userName) {
	this.userName = userName;
}
public String getUserPwd() {
	return userPwd;
}
public void setUserPwd(String userPwd) {
	this.userPwd = userPwd;
}
@Override
public String toString() {
	return "User [id=" + id + ", userName=" + userName + ", userPwd=" + userPwd + "]";
}
 
}

5.注意下面那个mappers里面对应的映射关系。这个也可以在官网上找到，稍作修改。

<?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="javastudy.UserMapper">
  <select id="selectUser" resultType="javastudy.User">
    select * from User where id = #{id}
  </select>
   <select id="selectAll" resultType="javastudy.User">
    select * from User 
  </select>
  <insert id="addUser" parameterType="javastudy.User">
  insert into user(userName,userPwd) values (#{userName},#{userPwd})
  </insert>
  <update id="updateUser" parameterType="javastudy.User">
  
   update user set userName=#{userName},userPwd=#{userPwd} where id=#{id}
  </update>
  <delete id= "deleteUser" parameterType="int" >
  delete from user where id=#{id}
  </delete>
</mapper>

简单的增删改查代码都有了。

6 写个工具和测试类。

工具类

public class MybatisUtils {
 public static SqlSession openSession() throws IOException {
	String rescourse="mybatis-cfg.xml";
	InputStream in=Resources.getResourceAsStream(rescourse);
	SqlSessionFactory sessionFactory= new SqlSessionFactoryBuilder().build(in, "users");
    return sessionFactory.openSession();
 }
}

测试类

class MyTest {
	@Test
	void testSelect() throws IOException {
		SqlSession session=MybatisUtils.openSession();
		String statement="javastudy.UserMapper.selectUser";
		 User user=session.selectOne(statement,1);
		 System.out.println(user);
		 session.close();
	}
	@Test
	void testSelectAll() throws IOException {
		SqlSession session=MybatisUtils.openSession();
		String statement="javastudy.UserMapper.selectAll";
		 List<User> list=session.selectList(statement);
		 System.out.println(list);
		 session.close();
	}
	@Test
	void testInsert() throws IOException {
		SqlSession session=MybatisUtils.openSession();
		String statement="javastudy.UserMapper.addUser";
		User user= new User();
		user.setUserName("qwe");
		user.setUserPwd("12345678");
		session.insert(statement,user);
		session.commit();
		 session.close();
	}
	@Test
	void testUpdate() throws IOException {
		SqlSession session=MybatisUtils.openSession();
		String statement="javastudy.UserMapper.updateUser";
		User user= new User();
		user.setId(4);
		user.setUserName("周润发");		user.setUserPwd("1597524");
		session.update(statement,user);
		session.commit();
		 session.close();
	}
	@Test
	void testDelete() throws IOException {
		SqlSession session=MybatisUtils.openSession();
		String statement="javastudy.UserMapper.deleteUser";
		session.delete(statement,1);
		session.commit();
		 session.close();
	}
}

session.commit(),提交事务，session.close(),关闭事务。

ok，完成。