【www.bbyears.com--php常用代码】
config.xml的配置
代码如下
"http://mybatis.org/dtd/mybatis-3-config.dtd">
使用xml需要再配置一个mappen.xml
代码如下
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
select * from user
insert into user values (null,#{name},#{password},#{age})
使用注解则用接口
publicinterfaceUserImpl {
//更新用户,更新用@update,查询用@select,插入用@insert,删除使用@delete这些注解
@Update("update user set name=#{name} where id=#{id}")
publicvoidupdateUser(User user);
}
demo测试代码
publicclassDemo {
staticInputStream in =null;
staticSqlSessionFactory ssf =null;
static{
in = Demo.class.getClassLoader().getResourceAsStream("config.xml");
ssf =newSqlSessionFactoryBuilder().build(in);
}
publicstaticvoidmain(String[] args) {
//selectAll();
//insertUser();
updateUser();
}
//查询全部
publicstaticvoidselectAll(){
SqlSession session = ssf.openSession();
List
System.out.println(list);
session.close();
}
//增加用户
publicstaticvoidinsertUser(){
SqlSession session = ssf.openSession();
User user =newUser();
user.setName("小霸王");
user.setPassword("aaaaa");
user.setAge(25);
intnum = session.insert("com.leige.entity.UserMappen.insertUser",user);
session.commit();
System.out.println(num);
session.close();
}
//修改用户信息
publicstaticvoidupdateUser(){
SqlSession session = ssf.openSession();
UserImpl userImpl = session.getMapper(UserImpl.class);
User user =newUser();
user.setName("我是大头鬼");
user.setPassword("aaaaa");
user.setAge(25);
user.setId(79);
userImpl.updateUser(user);
session.commit();
session.close();
}
}