mybatis SQL 增删改查代码实现

我不是女神ヾ 2021-10-30 04:26 422阅读 0赞

mybatis MySQL 增删改查代码实现

## ①：添加依赖 ##

<table style="width:311px;"> 
 <tbody> 
 <tr> 
 <td> 
 <table> 
 <tbody> 
 <tr> 
 <td> &lt;!--导入依赖--&gt; &lt;dependencies&gt; &lt;!--mybatis依赖--&gt; &lt;dependency&gt; &lt;groupId&gt;org.mybatis&lt;/groupId&gt; &lt;artifactId&gt;mybatis&lt;/artifactId&gt; &lt;version&gt;3.4.5&lt;/version&gt; &lt;/dependency&gt; &lt;!--mysql驱动--&gt; &lt;dependency&gt; &lt;groupId&gt;mysql&lt;/groupId&gt; &lt;artifactId&gt;mysql-connector-java&lt;/artifactId&gt; &lt;version&gt;5.1.6&lt;/version&gt; &lt;/dependency&gt; &lt;!--单元测试--&gt; &lt;dependency&gt; &lt;groupId&gt;junit&lt;/groupId&gt; &lt;artifactId&gt;junit&lt;/artifactId&gt; &lt;version&gt;4.12&lt;/version&gt; &lt;/dependency&gt; &lt;!--log4j--&gt; &lt;dependency&gt; &lt;groupId&gt;log4j&lt;/groupId&gt; &lt;artifactId&gt;log4j&lt;/artifactId&gt; &lt;version&gt;1.2.17&lt;/version&gt; &lt;/dependency&gt; &nbsp; &lt;/dependencies&gt; </td> 
 </tr> 
 </tbody> 
 </table></td> 
 </tr> 
 </tbody> 
</table>

②：编写pojo对象

<table style="width:585px;"> 
 <tbody> 
 <tr> 
 <td> public class Domen { private Integer uid; private String username; private String pwd; private String sex; private String address; @Override public String toString() { return "Domen{" + "uid=" + uid + ", username='" + username + '\'' + ", pwd='" + pwd + '\'' + ", sex='" + sex + '\'' + ", address='" + address + '\'' + '}'; } public Integer getUid() { return uid; } public void setUid(Integer uid) { this.uid = uid; } public String getUsername() { return username; } public void setUsername(String username) { this.username = username; } public String getPwd() { return pwd; } public void setPwd(String pwd) { this.pwd = pwd; } public String getSex() { return sex; } public void setSex(String sex) { this.sex = sex; } public String getAddress() { return address; } public void setAddress(String address) { this.address = address; } } </td> 
 <td>&nbsp;</td> 
 </tr> 
 <tr> 
 <td>&nbsp;</td> 
 <td>&nbsp;</td> 
 </tr> 
 </tbody> 
</table>

## ③: 编写映射 ##

<table style="width:584px;"> 
 <tbody> 
 <tr> 
 <td style="text-align:left;"> &lt;?xml version="1.0" encoding="utf-8" ?&gt; &lt;!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"&gt; &lt;mapper namespace="djs"&gt; &lt;!--遍历全部--&gt; &lt;select id="findAll" resultType="cn.mph.Domen"&gt; select * from userpwd &lt;/select&gt; &lt;!--模糊查詢--&gt; &lt;select id="findByUsername" parameterType="java.lang.String" resultType="cn.mph.Domen"&gt; select * from userpwd where username like "%"#{username}"%" &lt;/select&gt; &lt;!--修改--&gt; &lt;update id="update" parameterType="cn.mph.Domen"&gt; UPDATE userpwd set username=#{username},pwd=#{pwd},sex=#{sex},address=#{address} where uid=#{uid}; &lt;/update&gt; &lt;!--//删除--&gt; &lt;delete id="delete" parameterType="java.lang.Integer" &gt; delete from userpwd where uid=#{uid} &lt;/delete&gt; &lt;!--添加数据--&gt; &lt;insert id="insert" parameterType="cn.mph.Domen"&gt; INSERT INTO userpwd values (null,#{username},#{pwd},#{sex},#{address}) &lt;/insert&gt; &lt;/mapper&gt; &nbsp; &nbsp; &nbsp; </td> 
 <td>&nbsp;</td> 
 </tr> 
 <tr> 
 <td>&nbsp;</td> 
 <td>&nbsp;</td> 
 </tr> 
 </tbody> 
</table>

## ④：编写核心文件配置 ##

<table style="width:624px;"> 
 <tbody> 
 <tr> 
 <td> &nbsp; &lt;?xml version="1.0" encoding="UTF-8" ?&gt; &lt;!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"&gt; &lt;configuration&gt; &lt;environments default="development"&gt; &lt;environment id="development"&gt; &lt;transactionManager type="JDBC"/&gt; &lt;dataSource type="POOLED"&gt; &lt;property name="driver" value="com.mysql.jdbc.Driver"/&gt; &lt;property name="url" //下面是对数据库的连接：127.0.0.1:3306这个本机数据库端口号，wed0000 表名 &nbsp; value="jdbc:mysql://127.0.0.1:3306/wed0000"/&gt; &lt;property name="username" value="root"/&gt; &lt;property name="password" //密码 value="123456"/&gt; &lt;/dataSource&gt; &lt;/environment&gt; &lt;/environments&gt; &lt;!--关联映射文件--&gt; &lt;mappers&gt; &lt;mapper resource="UserMapper.xml"/&gt; &lt;/mappers&gt; &lt;/configuration&gt; </td> 
 </tr> 
 </tbody> 
</table>

## ⑤：测试框架 ##

<table style="width:688px;"> 
 <tbody> 
 <tr> 
 <td> package cn.mph; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import org.apache.ibatis.session.SqlSessionFactoryBuilder; import org.junit.Test; import java.io.InputStream; import java.util.List; public class TextCustomerFram { @Test //查询全部 遍历 public void text(){ //获取核心文件输入对象 InputStream stream = this.getClass().getClassLoader().getResourceAsStream("SalMapConfig.xml"); //创建SqlSessionFactoryBuilder对象 SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder(); //创建SqlSessionFactory对象 SqlSessionFactory build = builder.build(stream); //创建SqlSession对象 （SqlSessionFactory对象值.openSession()） SqlSession openSession = build.openSession(); //集合接收方便遍历 List&lt;Object&gt; list = openSession.selectList("djshd.findAll"); for (Object o:list) { System.out.println(o); } openSession.close(); } @Test //条件查询 public void textFindByUsername(){ InputStream stream = this.getClass().getClassLoader().getResourceAsStream("SalMapConfig.xml"); SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder(); SqlSessionFactory build = builder.build(stream); SqlSession session = build.openSession(); // List&lt;Domen&gt; list = session.selectList("djshd.findByUsername", "P"); for (Domen o:list) { System.out.println(o); } session.close(); } @Test //修改 public void textUpdate(){ InputStream stream = this.getClass().getClassLoader().getResourceAsStream("SalMapConfig.xml"); SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder(); SqlSessionFactory build = builder.build(stream); SqlSession session = build.openSession(); Domen domen = new Domen(); domen.setUid(3); domen.setUsername("武二"); domen.setPwd("250"); domen.setSex("男"); domen.setAddress("井冈山"); session.update("djs.update",domen); session.commit(); session.close(); } @Test // 删除 public void textDelete(){ InputStream stream = this.getClass().getClassLoader().getResourceAsStream("SalMapConfig.xml"); SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder(); SqlSessionFactory build = builder.build(stream); SqlSession session = build.openSession(); session.delete("djs.delete",3); session.commit(); session.close(); } @Test // 添加 public void textInsert(){ InputStream stream = this.getClass().getClassLoader().getResourceAsStream("SalMapConfig.xml"); SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder(); SqlSessionFactory build = builder.build(stream); SqlSession session = build.openSession(); Domen domen = new Domen(); domen.setUsername("阿郎"); domen.setPwd("123"); domen.setSex("男"); domen.setAddress("N港"); session.insert("djs.insert",domen); session.commit(); session.close(); } } &nbsp; </td> 
 </tr> 
 </tbody> 
</table>

转载于:https://www.cnblogs.com/mpenghao/p/11306823.html