mysql的trim动态标签_动态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">

parametertype="com.po.myuser">

select * from user where 1=1

and uname like concat('%',#{uname},'%')

and usex=#{usex}

parametertype="com.po.myuser">

select * from user where 1=1

and uname like concat('%',#{uname},'%')

and usex=#{usex}

and uid >= 10

parametertype="com.po.myuser">

select * from user

and uname like concat('%',#{uname},'%')

and usex=#{usex}

update user

uname=#{uname},

usex=#{sex}

where uid=#{uid}

parametertype="list">

select * from user where uid in

open="(" separator="," close=")">

#{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代码：

package com.dao;

import java.util.list;

import org.apache.ibatis.annotations.mapper;

import org.springframework.stereotype.repository;

import com.po.myuser;

@repository("userdao")

@mapper

public interface userdao {

public myuser selectuserbyid(integer uid);

public list selectalluser();

public int adduser(myuser user);

public int updateuser(myuser user);

public int deleteuser(integer uid);

}

创建com.po包，包括：myuser.java代码：

package com.po;

public class myuser {

private integer uid;

private string uname;

private string usex;

public integer getuid() {

return uid;

}

public void setuid(integer uid) {

this.uid = uid;

}

public string getuname() {

return uname;

}

public void setuname(string uname) {

this.uname = uname;

}

public string getusex() {

return usex;

}

public void setusex(string usex) {

this.usex = usex;

}

public string tostring() {

return "user[uid="+ uid +",uname="+uname+",usex"+usex+"]";

}

}

创建com.controller包，包括：testcontroller.java和usercontroller.java

usercontroller.java代码：

package com.controller;

import java.util.list;

import org.springframework.beans.factory.annotation.autowired;

import org.springframework.stereotype.controller;

import com.dao.userdao;

import com.po.myuser;

@controller("usercontroller")

public class usercontroller {

@autowired

private userdao userdao;

public void test() {

myuser auser = userdao.selectuserbyid(1);

system.out.println(auser);

system.out.println("====================");

myuser addmu = new myuser();

addmu.setuid(1);

addmu.setuname("陈恒");

addmu.setusex("男");

int add=userdao.adduser(addmu);

system.out.println("=====================");

myuser updatemu = new myuser();

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代码：

package com.controller;

import org.springframework.context.applicationcontext;

import org.springframework.context.support.classpathxmlapplicationcontext;

public class testcontroller {

public static void main(string[] args) {

applicationcontext appcon = new classpathxmlapplicationcontext("applicationcontext.xml");

usercontroller ct = (usercontroller)appcon.getbean("usercontroller");

ct.test();

}

}

在src下直接创建applicationcontext.xml，代码：

xmlns:xsi="http://www.w3.org/2001/xmlschema-instance"

xmlns:tx="http://www.springframework.org/schema/tx"

xmlns:context="http://www.springframework.org/schema/context"

xsi:schemalocation="http://www.springframework.org/schema/beans

http://www.springframework.org/schema/beans/spring-beans.xsd

http://www.springframework.org/schema/context

http://www.springframework.org/schema/context/spring-context.xsd

http://www.springframework.org/schema/tx

http://www.springframework.org/schema/tx/spring-tx.xsd">

class="org.springframework.jdbc.datasource.datasourcetransactionmanager">

如您对本文有疑问或者有任何想说的，请点击进行留言回复，万千网友为您解惑！