mybaties的增删改查

conf.xml的配置

<?xml version="1.0" encoding="UTF-8"?> **UserMapping的配置** <?xml version="1.0" encoding="UTF-8" ?> select * from users where id=#{id} delete from users where id=#{id} insert into users(name,age) values(#{name},#{age}) update users set name=#{name},age=#{age} where id=#{id} ****Test类**** package test;

import java.io.IOException;
import java.io.InputStream;

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

import me.gacl.domain.User;

public class Test1 {
public static void main(String[] args) throws IOException {
//mybatis的配置文件
String resource = “test/conf.xml”;
//使用类加载器加载mybatis的配置文件（它也加载关联的映射文件）
InputStream is = Test1.class.getClassLoader().getResourceAsStream(resource);
//构建sqlSession的工厂
SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(is);
//使用MyBatis提供的Resources类加载mybatis的配置文件（它也加载关联的映射文件）
//Reader reader = Resources.getResourceAsReader(resource);
//构建sqlSession的工厂
//SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);
//创建能执行映射文件中sql的sqlSession
SqlSession session = sessionFactory.openSession();
/**
* 映射sql的标识字符串，
* me.gacl.mapping.userMapper是userMapper.xml文件中mapper标签的namespace属性的值，
* getUser是select标签的id属性值，通过select标签的id属性值就可以找到要执行的SQL
*/
String statement = “me.gacl.mapping.userMapper.getUser”;//映射sql的标识字符串
String otherstatment=“me.gacl.mapping.userMapper.deleteuser”;
String add=“me.gacl.mapping.userMapper.addUser”;
String update=“me.gacl.mapping.userMapper.updateUser”;
//执行查询返回一个唯一user对象的sql
//查詢一條數據
//User user = session.selectOne(statement, 1);
User user = new User();
user.setName(“用户孤傲苍狼”);
user.setAge(90);
user.setId(4);
//刪除一條數據
session.delete(otherstatment,1);
//添加一條數據
session.insert(add,user);
//更新一條數據
session.update(update,user);
session.commit();
session.close();
System.out.println(user.getAge());
}
}
jar包的使用

User对应的属性
package me.gacl.domain;

public class User {
private int id;
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 String name;
private int age;
}

注意的问题：
1.一定要加上session.commit();提交这行代码，不然对数据库不起作用
2.配置文件一定要放置在src下面，并且这样才能正常访问
3.