mybatis之增删改查

添加数据：

UseDao.java

public class UserDao {
public int add(User user) throws IOException {
		SqlSession session=MyBatisUtil.getSession();
		int result=session.insert("cn.sxt.entity.UserMapper.addUser",user);
		session.commit();
		session.close();
		return result;
	}
}

User.java

public class User {
	private int id;
	private String name;
	private String pwd;
	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 String getPwd() {
		return pwd;
	}
	public void setPwd(String pwd) {
		this.pwd = pwd;
	}
	@Override
	public String toString() {
		return "User [id=" + id + ", name=" + name + ", pwd=" + pwd + "]";
	}
}

user.mapper.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="cn.sxt.entity.UserMapper">  
 <select id="selectUser" resultType="cn.sxt.entity.User">    
 	select * from user where id = #{id}  
 	</select>
 	<select id="selectAll" resultType="cn.sxt.entity.User">
 		select * from user
 	</select>
 	<insert id="addUser" parameterType="cn.sxt.entity.User" useGeneratedKeys="true">
 	 insert into user(name,pwd) values(#{name},#{pwd})
 	</insert> 
 	<update id="updateUser" parameterType="cn.sxt.entity.User">
 		update user set name=#{name},pwd=#{pwd} where id=#{id}
 	</update>
 	<delete id="deleteUser">
 		delete from user where id=#{id}
 	</delete>
 		</mapper>

Test.java

public class Test {
	public static void main(String args[]) throws IOException {
		UserDao userDao=new UserDao();
		User user=new User();
		user.setName("smile");
		user.setPwd("11115");
		System.out.println(userDao.add(user));
	}	
}

mybatis.cfg.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/db2"/>        
 <property name="username" value="root"/>        
 <property name="password" value="root"/>      
 			</dataSource>    
 		</environment>  
	 </environments>  
	<mappers>    
 <mapper resource="cn/sxt/entity/user.mapper.xml"/>  
 </mappers>
 </configuration>

修改数据：

（配置文件和User.java不需要更改）
UserDao.java

public class UserDao {
//先查询
public User getById(int id) throws IOException {
		SqlSession session=MyBatisUtil.getSession();
		User user=session.selectOne("cn.sxt.entity.UserMapper.selectUser",id);
		System.out.println("id="+user.getId()+",name="+user.getName()+",pwd="+user.getPwd());
		session.close();
		return user;
	}
	//之后更改
	public int update(User user) throws IOException {
		SqlSession session=MyBatisUtil.getSession();
		int result=session.update("cn.sxt.entity.UserMapper.updateUser",user);
		session.commit();
		session.close();
		return result;
	}
}

Test.java

public class Test {
	public static void main(String args[]) throws IOException {
		UserDao userDao=new UserDao();
		User user=userDao.getById(1);
		user.setPwd("33333");
		System.out.println(userDao.update(user));
	}	
}

查询数据：

（配置文件和User.java不需要更改）

查询指定数据

UserDao.java

public class UserDao {
public User getById(int id) throws IOException {
		SqlSession session=MyBatisUtil.getSession();
		User user=session.selectOne("cn.sxt.entity.UserMapper.selectUser",id);
		System.out.println("id="+user.getId()+",name="+user.getName()+",pwd="+user.getPwd());
		session.close();
		return user;
	}
}

Test.java

public class Test {
	public static void main(String args[]) throws IOException {
	System.out.println(userDao.getById(3));
	}
	}

查询所有数据：

UserDao.java

public class UserDao {
	public List<User> getAll() throws IOException{
		SqlSession session=MyBatisUtil.getSession();
		List<User> list=session.selectList("cn.sxt.entity.UserMapper.selectAll");
		session.close();
		return list;
	}
	}

Test.java

public class Test {
	public static void main(String args[]) throws IOException {
		UserDao userDao=new UserDao();
		List<User> list=userDao.getAll();
		for(User u:list)
		System.out.println(u);
		}
		}

删除数据：

（配置文件和User.java不需要更改）
UserDao.java

public class UserDao {
public int delete(int id) throws IOException {
		SqlSession session=MyBatisUtil.getSession();
		int result=session.delete("cn.sxt.entity.UserMapper.deleteUser",id);
		session.commit();
		session.close();
		return result;
	}
}

Test.java

public class Test {
	public static void main(String args[]) throws IOException {
		UserDao userDao=new UserDao();
		System.out.println(userDao.delete(1));
		}
		}