创建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">
如您对本文有疑问或者有任何想说的,请点击进行留言回复,万千网友为您解惑!