wordpress 创建网站,网站建设实训建议,微信小程序如何做,邢台移动网站建设报价一、场景模拟
基于自定义Mybatis框架和已有的Mysql数据库Mybatis#xff0c;查询所有用户信息。
二、创建工程并引入自定义Mybatis框架的坐标 ?xml version1.0 encodingUTF-8?
project xmlnshttp://maven.apache.org/POM/4.0.0…一、场景模拟
基于自定义Mybatis框架和已有的Mysql数据库Mybatis查询所有用户信息。
二、创建工程并引入自定义Mybatis框架的坐标 ?xml version1.0 encodingUTF-8?
project xmlnshttp://maven.apache.org/POM/4.0.0xmlns:xsihttp://www.w3.org/2001/XMLSchema-instancexsi:schemaLocationhttp://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsdmodelVersion4.0.0/modelVersiongroupIdcom.william/groupIdartifactIdTestDIYMybatisFramework/artifactIdversion1.0-SNAPSHOT/versionpropertiesmaven.compiler.source1.8/maven.compiler.sourcemaven.compiler.target1.8/maven.compiler.target/propertiesdependencies!--引入自定义的mybatis--dependencygroupIdcom.william/groupIdartifactIdDIYMybatisFramework/artifactIdversion1.0-SNAPSHOT/version/dependency!--mysql的依赖--dependencygroupIdmysql/groupIdartifactIdmysql-connector-java/artifactIdversion5.1.6/version/dependencydependencygroupIdjunit/groupIdartifactIdjunit/artifactIdversion4.12/version/dependency/dependencies
/project三、创建domain
package com.william.domain;import Framework.domain.Mapper;import java.util.HashMap;
import java.util.Map;/*** author lijunxuan* date Created in 2019/7/9 16:54* description * version: 1.0*/
public class User {private Integer id;private String username;private String password;private String sex;Overridepublic String toString() {return User{ id id , username username \ , password password \ , sex sex \ };}public Integer getId() {return id;}public void setId(Integer id) {this.id id;}public String getUsername() {return username;}public void setUsername(String username) {this.username username;}public String getPassword() {return password;}public void setPassword(String password) {this.password password;}public String getSex() {return sex;}public void setSex(String sex) {this.sex sex;}
}
四、创建Sql文件UserMapper.xml
?xml version1.0 encodingutf-8 ?
mapper namespacecom.william.dao.UserDaoselect idfindAll resultTypecom.william.domain.Userselect * from user/select
/mapper五、3.1.5 创建核心配置文件SqlMapConfig.xml
?xml version1.0 encodingUTF-8 ?
configurationenvironments defaultdevelopmentenvironment iddevelopmenttransactionManager typeJDBC /dataSource typePOOLEDproperty namedriver valuecom.mysql.jdbc.Driver /property nameurl valuejdbc:mysql://127.0.0.1:3306/web02?characterEncodingutf8 /property nameusername valueroot /property namepassword valueroot //dataSource/environment/environmentsmappersmapper resourcecom/william/mapper/UserMapper.xml/mapper/mappers
/configuration 六、3.1.6 测试
1.测试程序
package com.william;
import Framework.dao.SqlSession;
import Framework.factory.SqlSessionFactory;
import Framework.factory.SqlSessionFactoryBuilder;
import org.junit.Test;
import java.io.InputStream;
import java.util.List;/*** author lijunxuan* date Created in 2019/7/9 17:05* description * version: 1.0*/
public class TestFramework {Testpublic void test(){//获取核心配置文件的流对象InputStream inputStream TestFramework.class.getClassLoader().getResourceAsStream(SqlMapConfig.xml);//构建sqlSessionFactory对象SqlSessionFactory sqlSessionFactory new SqlSessionFactoryBuilder().build(inputStream);//生产SqlSession对象SqlSession sqlSession sqlSessionFactory.openSession();//调用selectList方法List list sqlSession.selectList(com.william.dao.UserDao . findAll);for (Object o : list) {System.out.println(o);}//释放资源sqlSession.close();}
}
2.测试效果
