上海市住房和城乡建设部网站,网站正在建设中模板单页,珠海关键词优化软件,wordpress 加入代码MyBatis开发入门搭建MyBatis框架开发环境在自己建的的项目建立个lib文件然后导入包3.两个jar包部署到项目中和为项目添加测试类库4.配置数据库mybatis-config.xml里面的配置#xff1a;?xml version1.0 encodingUTF-8?
!DOCTYPE config…MyBatis开发入门搭建MyBatis框架开发环境在自己建的的项目建立个lib文件然后导入包3.两个jar包部署到项目中和为项目添加测试类库4.配置数据库mybatis-config.xml里面的配置?xml version1.0 encodingUTF-8?
!DOCTYPE configuration
PUBLIC -//mybatis.org//DTD Config 3.0//EN
http://mybatis.org/dtd/mybatis-3-config.dtd
configuration!-- 配置内容在这里 --
/configuration!-- 注configuration是根节点后面所有的配置都要放在configuration节点下 --!-- 配置内容在这里 --连接数据库?xml version1.0 encodingUTF-8?
!DOCTYPE configuration
PUBLIC -//mybatis.org//DTD Config 3.0//EN
http://mybatis.org/dtd/mybatis-3-config.dtd
configuration!-- 配置内容在这里 --environments defaultdevelopmentenvironment iddevelopmenttransactionManager typeJDBC /dataSource typePOOLEDproperty namedriver valuecom.mysql.cj.jdbc.Driver /property nameurl valuejdbc:mysql://localhost:3306/frame_db /property nameusername valueroot /property namepassword value123456 //dataSource/environment
/environments !-- SQL语句映射文件地址配置 --
mappersmapper resource /
/mappers/configuration数据库另外一种动态配置条件查询如何只查询出供应商编码为“HB GYS001”的供应商信息?环境配置好了就建立在src中建立一个包 entitysrcentity建立供应商的实体package entity;public class Provider {private String procode;private String proname;private String prodesc;private String procontact;private String prophone;private String proaddress;private String profax;private int createdby;private String creationdate;public String getProcode() {return procode;}public void setProcode(String procode) {this.procode procode;}public String getProname() {return proname;}public void setProname(String proname) {this.proname proname;}public String getProdesc() {return prodesc;}public void setProdesc(String prodesc) {this.prodesc prodesc;}public String getProcontact() {return procontact;}public void setProcontact(String procontact) {this.procontact procontact;}public String getProphone() {return prophone;}public void setProphone(String prophone) {this.prophone prophone;}public String getProaddress() {return proaddress;}public void setProaddress(String proaddress) {this.proaddress proaddress;}public String getProfax() {return profax;}public void setProfax(String profax) {this.profax profax;}public int getCreatedby() {return createdby;}public void setCreatedby(int createdby) {this.createdby createdby;}public String getCreationdate() {return creationdate;}public void setCreationdate(String creationdate) {this.creationdate creationdate;}
}
注意是在包mapper下建立ProviderMapper.xml这是固定的?xml version1.0 encodingUTF-8?
!DOCTYPE mapper
PUBLIC -//mybatis.org//DTD Mapper 3.0//EN
http://mybatis.org/dtd/mybatis-3-mapper.dtd
mapper namespaceProviderMapper!-- SQL映射写在这里 --/mapperresourcesmapperProviderMapper.xml?xml version1.0 encodingUTF-8?
!DOCTYPE mapper
PUBLIC -//mybatis.org//DTD Mapper 3.0//EN
http://mybatis.org/dtd/mybatis-3-mapper.dtd
mapper namespaceProviderMapper!-- SQL映射写在这里 --select idfindAllProvider resultTypeentity.Provider parameterTypeString!-- (1查询供应商编码 proCode为“HB_GYS001”的供应商名称、联系人和联系电话等信息 --select * from smbms_provider where proCode#{proCode}/select
/mapper
然后要在mybatis-config.xml?xml version1.0 encodingUTF-8?
!DOCTYPE configuration
PUBLIC -//mybatis.org//DTD Config 3.0//EN
http://mybatis.org/dtd/mybatis-3-config.dtd
configuration!-- 配置内容在这里 --environments defaultdevelopmentenvironment iddevelopmenttransactionManager typeJDBC /dataSource typePOOLEDproperty namedriver valuecom.mysql.cj.jdbc.Driver /property nameurl valuejdbc:mysql://localhost:3306/frame_db /property nameusername valueroot /property namepassword value123456 //dataSource/environment
/environments !-- SQL语句映射文件地址配置 --
mappersmapper resourcemapper/ProviderMapper.xml / 这里写这个
/mappers/configurationtestProviderMapperTest:import java.io.IOException;
import java.io.InputStream;
import java.util.List;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 org.junit.Test;import entity.Provider;public class ProviderMapperTest {Testpublic void testFindAllUser() throws IOException{//1.加载mybatis核心配置文件InputStream inputStream Resources.getResourceAsStream(mybatis-config.xml);//2.获取SqlSessionFactory对象SqlSessionFactory sqlSessionFactory new SqlSessionFactoryBuilder().build(inputStream);//3.得到执行sql的对象SqlSession SqlSession sqlSession sqlSessionFactory.openSession();//4.执行sql语句ListProvider list sqlSession.selectList(ProviderMapper.findAllProvider,HB_GYS001);//5.处理结果for (Provider smbms_provider: list) {System.out.println(编号smbms_provider.getProcode()供应商名smbms_provider.getProname()主要产品smbms_provider.getProdesc()姓名smbms_provider.getProcontact()电话smbms_provider.getProphone()地址smbms_provider.getProaddress()Fax:smbms_provider.getProfax()By:smbms_provider.getCreatedby()时间smbms_provider.getCreationdate());}//6.关闭数据库会话sqlSession.close();}}
查询( proName)“乐摆日用品厂”的联系电话和地址。srcentityresourcesmappertestProviderMapperTest查询供应商地址 proAddress在北京的供应商名称信息srcentityresourcesmappertestProviderMapperTest
