Mybatis步驟分解實(shí)現(xiàn)一個(gè)增刪改查程序
1.idea新建Maven項(xiàng)目Mybatis-study 將項(xiàng)目里的src文件夾刪掉 依次將此項(xiàng)目作為父項(xiàng)目
2.在Mybatis-study中新建模塊mybatis-01
在mybatis的pom文件中可以看到其父項(xiàng)目為ybatis-study
<parent>
<artifactId>MyBatis-study</artifactId>
<groupId>org.example</groupId>
<version>1.0-SNAPSHOT</version>
</parent>
3. 在Mybatis-study的pom.xml中引入如下jar包
<dependencies> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.11</version> <scope>test</scope> </dependency> <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis --> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.5.9</version> </dependency> <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java --> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.29</version> </dependency> </dependencies>
4.將IDEA和MySQL數(shù)據(jù)庫(kù)建立連接:
根據(jù)實(shí)際情況填寫user和password 填寫之后點(diǎn)擊Test Connection
測(cè)試成功之后點(diǎn)擊Schemas選擇你要鏈接的數(shù)據(jù)庫(kù)
5.新建mybatis-config.xml配置文件 引入數(shù)據(jù)庫(kù)資源
<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"> <configuration> <environments default="development"> <environment id="development"> <transactionManager type="JDBC"/> <dataSource type="POOLED"> <property name="driver" value="com.mysql.cj.jdbc.Driver"/> <property name="url" value="jdbc:mysql://localhost:3306/smbms?useSSL=true&characterEncoding=UTF-8"/> <property name="username" value="root"/> <property name="password" value="root"/> </dataSource> </environment> </environments> <mappers> <mapper resource="com/kero/dao/UserMapper.xml" /> </mappers> </configuration>
6.創(chuàng)建實(shí)體類User 注意:實(shí)體類中成員變量名要和數(shù)據(jù)庫(kù)表中字段名完全一致
package com.kero.pojo; public class User { private int id; private String name; private String password; public User() { } public User(int id, String name, String password) { this.id = id; this.name = name; this.password = password; } public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getpassword() { return password; } public void setpassword(String pwd) { this.password = pwd; } @Override public String toString() { return "User{" + "id=" + id + ", name='" + name + '\'' + ", pwd='" + password + '\'' + '}'; } }
7.編寫工具類Utils
package com.kero.utils; import org.apache.ibatis.io.Resources; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import org.apache.ibatis.session.SqlSessionFactoryBuilder; import java.io.IOException; import java.io.InputStream; //sqlSessionFactory public class MyBatisUtils { private static SqlSessionFactory sqlSessionFactory; static { try { //使用Mybatis第一步 獲取sqlSessionFactory對(duì)象 String resource = "mybatis-config.xml"; InputStream inputStream = Resources.getResourceAsStream(resource); sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream); } catch (IOException e) { throw new RuntimeException(e); } } /* 既然有了 SqlSessionFactory,顧名思義,我們可以從中獲得 SqlSession 的實(shí)例。SqlSession 提供了在數(shù)據(jù)庫(kù)執(zhí)行 SQL 命令所需的所有方法。你可以通過(guò) SqlSession 實(shí)例來(lái)直接執(zhí)行已映射的 SQL 語(yǔ)句。例如: */ public static SqlSession getSqlSession(){ return sqlSessionFactory.openSession(); } }
8.定義接口
package com.kero.dao; import com.kero.pojo.User; import java.util.List; public interface UserMapper { //查詢?nèi)坑脩? List<User> getUserList(); //根據(jù)ID查詢用戶 User getUserByID(int id); //insert一個(gè)用戶 int addUser(User user); //修改一個(gè)用戶 int updateUser(User user); //刪除一個(gè)用戶 int deleteUser(int id); }
9.定義Mapper文件 這里的Mapper文件相當(dāng)于原來(lái)傳統(tǒng)方式中接口的實(shí)現(xiàn)類
<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <!--namespace會(huì)綁定一個(gè)對(duì)應(yīng)的Mapper接口--> <mapper namespace="com.kero.dao.UserMapper"> <select id="getUserList" resultType="com.kero.pojo.User"> select * from smbms.user </select> <select id="getUserByID" parameterType="int" resultType="com.kero.pojo.User"> select * from smbms.user where id = #{id} </select> <insert id="addUser" parameterType="com.kero.pojo.User"> insert into smbms.user (id, name, password) VALUES (#{id},#{name},#{password}) </insert> <update id="updateUser" parameterType="com.kero.pojo.User"> update smbms.user set name=#{name},password=#{password} where id = #{id} </update> <delete id="deleteUser" parameterType="int"> delete from smbms.user where id = #{id} </delete> </mapper>
10.編寫測(cè)試類
import com.kero.dao.UserMapper; import com.kero.pojo.User; import com.kero.utils.MyBatisUtils; import org.apache.ibatis.session.SqlSession; import org.junit.Test; import java.util.List; public class test { @Test public void test(){ SqlSession session = MyBatisUtils.getSqlSession(); UserMapper mapper = session.getMapper(UserMapper.class); List<User> userList = mapper.getUserList(); for (User l:userList) { System.out.println(l.toString()); } session.close(); } @Test public void testgetUserByID(){ SqlSession session = MyBatisUtils.getSqlSession(); UserMapper mapper = session.getMapper(UserMapper.class); User userByID = mapper.getUserByID(1); System.out.println(userByID); session.close(); } //增刪改需要提交事務(wù) @Test public void testaddUser(){ SqlSession session = MyBatisUtils.getSqlSession(); UserMapper mapper = session.getMapper(UserMapper.class); int zhhgf = mapper.addUser(new User(10, "zhhgf", "1k23jbjk")); System.out.println(zhhgf); session.commit(); //提交事務(wù) session.close(); } @Test public void testupdateUser(){ SqlSession session = MyBatisUtils.getSqlSession(); UserMapper mapper = session.getMapper(UserMapper.class); int i = mapper.updateUser(new User(8,"asdfsdf","234sdfs")); session.commit(); //提交事務(wù) session.close(); } @Test public void testdeleteUser(){ SqlSession session = MyBatisUtils.getSqlSession(); UserMapper mapper = session.getMapper(UserMapper.class); int i = mapper.deleteUser(8); session.commit(); //提交事務(wù) session.close(); } }
11.測(cè)試查詢功能 : 輸出結(jié)果與數(shù)據(jù)庫(kù)表中數(shù)據(jù)
User{id=1, name='Sugawara Ryota', pwd='8X8Jq7HVNs'}
User{id=2, name='Shawn Mills', pwd='R78IHGDSXr'}
User{id=3, name='Matsuda Hina', pwd='mUi3CVA7mc'}
User{id=4, name='Cynthia Hawkins', pwd='NO1EwWbOs9'}
User{id=5, name='Rachel Bennett', pwd='YefuPVxzb9'}
tips:
如果一切配置正常但出現(xiàn)java.lang.ExceptionInInitializerError
Caused by org.apache.ibatis.execeptions.PersistenceExecepyion錯(cuò)誤
是因?yàn)?maven由于它的約定大于配置 我們寫的配置文件可能會(huì)出現(xiàn)無(wú)法被導(dǎo)出或者生效的問(wèn)題解決方案 在pom.xml文件中添加如下代碼
<build> <resources> <resource> <directory>src/main/resources</directory> <includes> <include>**/*.properties</include> <include>**/*.xml</include> </includes> <filtering>true</filtering> </resource> <resource> <directory>src/main/java</directory> <includes> <include>**/*.properties</include> <include>**/*.xml</include> </includes> <filtering>true</filtering> </resource> </resources> </build>
到此這篇關(guān)于Mybatis步驟分解實(shí)現(xiàn)一個(gè)增刪改查程序的文章就介紹到這了,更多相關(guān)Mybatis增刪改查內(nèi)容請(qǐng)搜索腳本之家以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持腳本之家!
- Mybatis注解增刪改查的實(shí)例代碼
- Oracle + mybatis實(shí)現(xiàn)對(duì)數(shù)據(jù)的簡(jiǎn)單增刪改查實(shí)例代碼
- Spring boot + mybatis + Vue.js + ElementUI 實(shí)現(xiàn)數(shù)據(jù)的增刪改查實(shí)例代碼(二)
- Spring boot + mybatis + Vue.js + ElementUI 實(shí)現(xiàn)數(shù)據(jù)的增刪改查實(shí)例代碼(一)
- Mybatis實(shí)現(xiàn)數(shù)據(jù)的增刪改查實(shí)例(CRUD)
- 簡(jiǎn)述Mybatis增刪改查實(shí)例代碼
- Mybatis實(shí)現(xiàn)增刪改查(CRUD)實(shí)例代碼
- SpringBoot整合MybatisPlus實(shí)現(xiàn)增刪改查功能
- Mybatis實(shí)現(xiàn)增刪改查
相關(guān)文章
Spring和MyBatis整合自動(dòng)生成代碼里面text類型遇到的坑
Spring和MyBatis整合以后,使用自動(dòng)生成代碼工具生成dao和mapper配置文件。下面通過(guò)本文給大家介紹Spring和MyBatis整合自動(dòng)生成代碼里面text類型遇到的坑,需要的朋友參考下吧2018-01-01Spring Cloud Alibaba 使用 Feign+Sentinel 完成熔斷的示例
這篇文章主要介紹了Spring Cloud Alibaba 使用 Feign+Sentinel 完成熔斷的示例,幫助大家更好的理解和學(xué)習(xí)使用Spring Cloud,感興趣的朋友可以了解下2021-03-03Java圖形化界面設(shè)計(jì)之布局管理器之BorderLayout案例詳解
這篇文章主要介紹了Java圖形化界面設(shè)計(jì)之布局管理器之BorderLayout案例詳解,本篇文章通過(guò)簡(jiǎn)要的案例,講解了該項(xiàng)技術(shù)的了解與使用,以下就是詳細(xì)內(nèi)容,需要的朋友可以參考下2021-08-08Java中的RASP機(jī)制實(shí)現(xiàn)詳解
這篇文章主要介紹了Java中的RASP實(shí)現(xiàn)詳解,文中通過(guò)示例代碼介紹的非常詳細(xì),對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值,需要的朋友可以參考下2019-08-08SpringBoot后端數(shù)據(jù)校驗(yàn)實(shí)戰(zhàn)操作指南
在項(xiàng)?開(kāi)發(fā)中,對(duì)于前端提交的表單,后臺(tái)接?接收到表單數(shù)據(jù)后,為了保證程序的嚴(yán)謹(jǐn)性,通常后端會(huì)加?業(yè)務(wù)參數(shù)的合法校驗(yàn)操作來(lái)避免程序的?技術(shù)性?bug,這篇文章主要給大家介紹了關(guān)于SpringBoot后端數(shù)據(jù)校驗(yàn)的相關(guān)資料,需要的朋友可以參考下2022-07-07@ConfigurationProperties綁定配置信息至Array、List、Map、Bean的實(shí)現(xiàn)
這篇文章主要介紹了@ConfigurationProperties綁定配置信息至Array、List、Map、Bean的實(shí)現(xiàn),文中通過(guò)示例代碼介紹的非常詳細(xì),對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值,需要的朋友們下面隨著小編來(lái)一起學(xué)習(xí)學(xué)習(xí)吧2020-05-05Java服務(wù)限流算法的6種實(shí)現(xiàn)
服務(wù)限流是指通過(guò)控制請(qǐng)求的速率或次數(shù)來(lái)達(dá)到保護(hù)服務(wù)的目的,本文主要介紹了Java服務(wù)限流算法的6種實(shí)現(xiàn),具有一定的參考價(jià)值,感興趣的可以了解一下2023-05-05