<?xml version="1.0" encoding="UTF-8"?>

<?xml version="1.0" encoding="UTF-8"?>





select * from user



insert into user values (null,#{name},#{password},#{age})


使用注解则用接口
public interface UserImpl {
//更新用户，更新用@update，查询用@select，插入用@insert，删除使用@delete这些注解
@Update("update user set name=#{name} where id=#{id}")
public void updateUser(User user);
}
demo测试代码
public class Demo {
static InputStream in = null;
static SqlSessionFactory ssf = null;
static{
in = Demo.class.getClassLoader().getResourceAsStream("config.xml");
ssf = new SqlSessionFactoryBuilder().build(in);
}
public static void main(String[] args) {
//selectAll();
//insertUser();
updateUser();
}
//查询全部
public static void selectAll(){
SqlSession session = ssf.openSession();
List list = session.selectList("com.leige.entity.UserMappen.selectAll");
System.out.println(list);
session.close();
}
//增加用户
public static void insertUser(){
SqlSession session = ssf.openSession();
User user = new User();
user.setName("小霸王");
user.setPassword("aaaaa");
user.setAge(25);
int num = session.insert("com.leige.entity.UserMappen.insertUser",user);
session.commit();
System.out.println(num);
session.close();
}
//修改用户信息
public static void updateUser(){
SqlSession session = ssf.openSession();
UserImpl userImpl = session.getMapper(UserImpl.class);
User user = new User();
user.setName("我是大头鬼");
user.setPassword("aaaaa");
user.setAge(25);
user.setId(79);
userImpl.updateUser(user);
session.commit();
session.close();
}
}