- 2023-03-23 18:18:52
- 9147 热度
- 0 评论
首先是安装插件,我这里用的是MyBatis_Generator_1.3.1。
获取相应数据库的驱动Jar包,这里是MySQL。
编写要自动生成的数据库表
CREATE TABLE `test` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `birthday` datetime DEFAULT NULL, `money` float DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
编写对应数据库的配置文件,一般一个数据库对应一个配置文件即可。
<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN" "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd" > <generatorConfiguration > <classPathEntry location="D:\JAD\mysql-connector-java-5.1.26.jar" /> <context id="context1" > <commentGenerator> <property name="suppressAllComments" value="true" /> </commentGenerator> <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3306/test" userId="root" password="root" /> <javaModelGenerator targetPackage="com.codelog.entity" targetProject="mybatis" /> <sqlMapGenerator targetPackage="com.codelog.dao" targetProject="mybatis" /> <javaClientGenerator targetPackage="com.codelog.dao" targetProject="mybatis" type="XMLMAPPER" /> <table schema="" tableName="test" enableCountByExample="true" enableDeleteByExample="true" selectByExampleQueryId = "true" enableDeleteByPrimaryKey = "true"> </table> </context> </generatorConfiguration>
在Eclipse右键,生成相应的代码
实用示例
package com.codelog.test; import java.util.Date; import java.util.List; import com.codelog.dao.TestMapper; import com.codelog.entity.Test; import com.codelog.entity.TestExample; import com.codelog.entity.TestExample.Criteria; public class TestCase { private static TestMapper mp = null; public static void main(String[] args) { Test record = new Test(); record.setName("java無名"); record.setBirthday(new Date()); record.setMoney(new Float("12.12")); mp.insert(record); // 新增 mp.deleteByPrimaryKey(1); // 根据ID删除 TestExample example = new TestExample(); Criteria criteria = example.createCriteria(); criteria.andBirthdayLessThan(new Date()); // 加一个参数 mp.deleteByExample(example); // 根据条件删除 record = mp.selectByPrimaryKey(1); // 根据ID查询 record.setBirthday(new Date()); mp.updateByPrimaryKeySelective(record); // 根据ID更新 mp.updateByExample(record, example); // 根据条件更新,注意record为null的列不操作 example.setOrderByClause("id desc"); // 增加排序 List<Test> list = mp.selectByExample(example); System.out.println(list.size()); } }
注意,查询没有分页参数,这里只是简单示例,后续再说分页的问题。
最后工程目录
插件文件下载,联系站长。注意在工程增加mybatis-3.2.8.jar这个Jar包。
0 评论
留下评论
热门标签
- Spring(403)
- Boot(208)
- Spring Boot(187)
- Spring Cloud(82)
- Java(82)
- Cloud(82)
- Security(60)
- Spring Security(54)
- Boot2(51)
- Spring Boot2(51)
- Redis(31)
- SQL(29)
- Mysql(25)
- Dalston(24)
- IDE(24)
- mongoDB(22)
- MVC(22)
- JDBC(22)
- IDEA(22)
- Web(21)
- CLI(20)
- Alibaba(19)
- SpringMVC(19)
- Docker(17)
- SpringBoot(17)
- Git(16)
- Eclipse(16)
- Vue(16)
- JPA(15)
- Apache(15)
- ORA(15)
- Tomcat(14)
- Linux(14)
- HTTP(14)
- Mybatis(14)
- Oracle(14)
- jdk(14)
- OAuth(13)
- Nacos(13)
- Pro(13)
- XML(13)
- JdbcTemplate(13)
- JSON(12)
- OAuth2(12)
- Data(12)
- int(11)
- Myeclipse(11)
- stream(11)
- not(10)
- Bug(10)
- Hystrix(9)
- ast(9)
- maven(9)
- Map(9)
- Swagger(8)
- APP(8)
- Bit(8)
- API(8)
- session(8)
- Window(8)
- windows(7)
- too(7)
- HTML(7)
- Github(7)
- JavaMail(7)
- Cache(7)
- File(7)
- IntelliJ(7)
- mail(7)
- Server(6)
- nginx(6)
- jar(6)
- ueditor(6)
- ehcache(6)
- UDP(6)
- RabbitMQ(6)
- and(6)
- star(6)
- Excel(6)
- Log4J(6)
- pushlet(6)
- apt(6)
- Freemarker(6)
- read(6)
- WebFlux(6)
- JSP(6)
- Bean(6)
- error(6)
- are(5)
- SVN(5)
- for(5)
- DOM(5)
- Sentinel(5)
- the(5)
- JWT(5)
- rdquo(5)
- PHP(5)
- Struts(5)
- string(5)
- script(5)