MyBatisDemo：MyBatis 框架知识案例

package cn.edu.MyBatisDemo.test; import cn.edu.MyBatisDemo.mapper.MyBatisGeneratorMapper; import com.github.pagehelper.Page; import com.github.pagehelper.PageHelper; import org.apache.ibatis.io.Resources; import org.apache.ibatis.session.ExecutorType; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import org.apache.ibatis.session.SqlSessionFactoryBuilder; import org.junit.Test; import org.mybatis.generator.api.MyBatisGenerator; import org.mybatis.generator.config.Configuration; import org.mybatis.generator.config.xml.ConfigurationParser; import org.mybatis.generator.exception.InvalidConfigurationException; import org.mybatis.generator.exception.XMLParserException; import org.mybatis.generator.internal.DefaultShellCallback; import java.io.File; import java.io.IOException; import java.io.InputStream; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; public class MyBatisGeneratorTest { @Test public void mbgTest() throws IOException, XMLParserException, InvalidConfigurationException, SQLException, InterruptedException { List<String> warnings = new ArrayList<String>(); boolean overwrite = true; // 只需修改 Generator 的配置文件名称即可 String path = this.getClass().getClassLoader().getResource("mybatis_generator.xml").getPath(); File configFile = new File(path); ConfigurationParser cp = new ConfigurationParser(warnings); Configuration config = cp.parseConfiguration(configFile); DefaultShellCallback callback = new DefaultShellCallback(overwrite); MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, callback, warnings); myBatisGenerator.generate(null); } @Test public void test() throws IOException { //1.根据配置文件创建数据库连接会话的工厂类 InputStream inputStream = Resources.getResourceAsStream("mybatis.xml"); //获取工厂类 SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream); //2.通过工厂类获取数据库连接的会话 SqlSession sqlSession = sqlSessionFactory.openSession(ExecutorType.BATCH); //3.通过 sqlSession 操作数据库 try { MyBatisGeneratorMapper myBatisGeneratorMapper = sqlSession.getMapper(MyBatisGeneratorMapper.class); //实体类的名字 MyBatisGenerator 与导入的 org.mybatis.generator.api.MyBatisGenerator 名字重复。故此写上 cn.edu.MyBatisDemo.model. List<cn.edu.MyBatisDemo.model.MyBatisGenerator> myBatisGenerators = myBatisGeneratorMapper.selectByStoredProcedure(20230902,20230909); System.out.println(myBatisGenerators); } finally { sqlSession.close(); } } }