mysql动态sql标签_动态SQL各个标签作用以及注意事项详解

创建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">