Mybatis实验二(增删查改)

Mybatis实验二(实现增删查改)

目录结构

1.引入jar包
2.创建数据库users表

3.创建user实体类

package com.sxau.rjxy.mybatis_test1;

public class User {
	@Override
	public String toString() {
		return "User [id=" + id + ", name=" + name + ", age=" + age + "]";
	}
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public int getAge() {
		return age;
	}
	public void setAge(int age) {
		this.age = age;
	}
	private int id;
	private String name;
	private int age;
    //get,set方法

	public User(int id, String name, int age) {
		this.id = id;
		this.name = name;
		this.age = age;
	}
	public User() {
		
	}
}

4.创建conf.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/test" />
                <property name="username" value="root" />
                <property name="password" value="123456" />
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="com/sxau/rjxy/mybatis_test1/userMapper.xml"/>
    </mappers>
  </configuration>

5.创建userMapper.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.sxau.rjxy.mybatis_test1.userMapper"><!-- 唯一标识就行 -->
 
<insert id="insertUser" parameterType="com.sxau.rjxy.mybatis_test1.User">
insert into users(name,age) values (#{name},#{age});
</insert>
 
<delete id="deleteUser" parameterType="int">delete from users where id=#{id}</delete>
 
<update id="updateUser" parameterType="com.sxau.rjxy.mybatis_test1.User">update users set name=#{name},age=#{age} where id=#{id}</update>
 
 
<select id="selectUser" parameterType="int" resultType="com.sxau.rjxy.mybatis_test1.User">
select * from users where id=#{id}
</select>
<select id="selextAllUsers" resultType="com.sxau.rjxy.mybatis_test1.User">select * from users</select>
</mapper>

6.在conf.xml里面注册
7.测试类

package com.sxau.rjxy.mybatis_test1;

import java.util.List;

import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.junit.Test;

import db.utils.MybatisUtils;

public class JunitTest {
@Test
public void testAdd() {
	SqlSessionFactory factory = MybatisUtils.getFactory();
	SqlSession session = factory.openSession(true);//参数自动提交到数据库
	String statement = "com.sxau.rjxy.mybatis_test1.userMapper.insertUser";
///-1无意义
	/*User user=new User();
	user.setAge();
	user.setName(name);*/
	
	int insert = session.insert(statement, new User(-1, "zj", 23));
	// session.commit();自动提交到数据库
	System.out.println("insert:" + insert);
}

@Test
public void testDelete() {
	SqlSessionFactory factory = MybatisUtils.getFactory();
	SqlSession session = factory.openSession(true);//参数自动提交到数据库
	String statement = "com.sxau.rjxy.mybatis_test1.userMapper.deleteUser";
///-1无意义
	int del = session.delete(statement,6);
	// session.commit();自动提交到数据库
	System.out.println("del:" + del);
}
@Test
public void testUpdate() {
	SqlSessionFactory factory = MybatisUtils.getFactory();
	SqlSession session = factory.openSession(true);//参数自动提交到数据库
	String statement = "com.sxau.rjxy.mybatis_test1.userMapper.deleteUser";
///-1无意义
	int upd = session.update(statement,new User(6,"change",22));
	// session.commit();自动提交到数据库
	System.out.println("upd:" + upd);
}

@Test
public void testSelect() {
	SqlSessionFactory factory = MybatisUtils.getFactory();
	SqlSession session = factory.openSession(true);//参数自动提交到数据库
	String statement = "com.sxau.rjxy.mybatis_test1.userMapper.selectUser";
///-1无意义
	User user = session.selectOne(statement, 1);
	// session.commit();自动提交到数据库
	System.out.println("one::" + user);
}

@Test
public void testSelectAll() {
	SqlSessionFactory factory = MybatisUtils.getFactory();
	SqlSession session = factory.openSession(true);//参数自动提交到数据库
	String statement = "com.sxau.rjxy.mybatis_test1.userMapper.selextAllUsers";
///-1无意义
	List<User> user =session.selectList(statement);
	// session.commit();自动提交到数据库
	System.out.println("all:" + user);
}
}
8.Tset.java

```java
package com.sxau.rjxy.mybatis_test1;

import java.io.InputStream;
import java.io.Reader;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

public class Test {
	public static void main(String[] args) {
		String resource = "conf.xml"; 
		
		InputStream is = Test.class.getClassLoader().getResourceAsStream(resource); 
		//构建sqlSession的工厂
        SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(is);
	}
}


```java

9.MybatisUtils.java``

package db.utils;

import java.io.InputStream;

import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import com.sxau.rjxy.mybatis_test1.Test;

public class MybatisUtils {

public static SqlSessionFactory getFactory() {
	// TODO Auto-generated method stub
	String resource="conf.xml";
	InputStream reader=Test.class.getClassLoader().getResourceAsStream(resource);
	SqlSessionFactory sessionFactory=new SqlSessionFactoryBuilder().build(reader);
	return sessionFactory;
}

}

8.结果