创建com.mybatis包,包含:UserMapper.xml和mybatis-config.xml
UserMapper.xml代码:
/p>
PUBLIC"-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
select* from user where 1=1
and uname like concat('%',#{uname},'%')
and usex=#{usex}
select* from user where 1=1
and uname like concat('%',#{uname},'%')
and usex=#{usex}
and uid>= 10
select*from user
and uname like concat('%',#{uname},'%')
and usex=#{usex}
update user
uname=#{uname},
usex=#{sex}
where uid=#{uid}
select*from user where uid in
#{item}
mybatis-config.xml代码:
/p>
PUBLIC"-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
创建com.dao包,包含:UserDao.java代码:
packagecom.dao;importjava.util.List;importorg.apache.ibatis.annotations.Mapper;importorg.springframework.stereotype.Repository;importcom.po.MyUser;
@Repository("userDao")
@Mapperpublic interfaceUserDao {publicMyUser selectUserById(Integer uid);public ListselectAllUser();public intaddUser(MyUser user);public intupdateUser(MyUser user);public intdeleteUser(Integer uid);
}
创建com.po包,包括:MyUser.java代码:
packagecom.po;public classMyUser {privateInteger uid;privateString uname;privateString usex;publicInteger getUid() {returnuid;
}public voidsetUid(Integer uid) {this.uid =uid;
}publicString getUname() {returnuname;
}public voidsetUname(String uname) {this.uname =uname;
}publicString getUsex() {returnusex;
}public voidsetUsex(String usex) {this.usex =usex;
}publicString toString() {return "User[uid="+ uid +",uname="+uname+",usex"+usex+"]";
}
}
创建com.controller包,包括:TestController.java和UserController.java
UserController.java代码:
packagecom.controller;importjava.util.List;importorg.springframework.beans.factory.annotation.Autowired;importorg.springframework.stereotype.Controller;importcom.dao.UserDao;importcom.po.MyUser;
@Controller("userController")public classUserController {
@AutowiredprivateUserDao userDao;public voidtest() {
MyUser auser= userDao.selectUserById(1);
System.out.println(auser);
System.out.println("====================");
MyUser addmu= newMyUser();
addmu.setUid(1);
addmu.setUname("陈恒");
addmu.setUsex("男");int add=userDao.addUser(addmu);
System.out.println("=====================");
MyUser updatemu= newMyUser();
updatemu.setUid(1);
updatemu.setUname("张三");
updatemu.setUsex("女");int up =userDao.updateUser(updatemu);
System.out.println("修改了"+up+"条记录");
System.out.println("=====================");int dl = userDao.deleteUser(9);
System.out.println("删除了"+dl+"条记录");
System.out.println("=====================");
Listlist =userDao.selectAllUser();for(MyUser myUser: list) {
System.out.println(myUser);
}
}
}
TestController.java代码:
packagecom.controller;importorg.springframework.context.ApplicationContext;importorg.springframework.context.support.ClassPathXmlApplicationContext;public classTestController {public static voidmain(String[] args) {
ApplicationContext appCon= new ClassPathXmlApplicationContext("applicationContext.xml");
UserController ct= (UserController)appCon.getBean("userController");
ct.test();
}
}
在src下直接创建applicationContext.xml,代码:
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">