绍兴网站开发,品牌设计和平面设计的区别,简单的网页代码实例,网站设计所需要的理念 mybatis整合
主要是处理dao包下的接口和xml文件#xff0c;以及service下的类和接口
第一步
在resource目录下创建mybatis-config.xml文件【注意点#xff1a;mybatis-config.xml文件下通常都是写别名、和mappers】
?xml version1.0 encodingU… mybatis整合
主要是处理dao包下的接口和xml文件以及service下的类和接口
第一步
在resource目录下创建mybatis-config.xml文件【注意点mybatis-config.xml文件下通常都是写别名、和mappers】
?xml version1.0 encodingUTF-8 ?
!DOCTYPE configurationPUBLIC -//mybatis.org//DTD Config 3.0//ENhttp://mybatis.org/dtd/mybatis-3-config.dtd
configurationtypeAliasestypeAlias typecom.pojo.Books aliasbooks//typeAliasesmappersmapper classcom.dao.BooksMapper//mappers
/configuration第二步
dao和service包下的文件
dao包
public interface BooksMapper {int add(Books books);int delete(int bookID);int update(Books books);Books selectById(int bookID);ListBooks selectAll();
}
?xml version1.0 encodingUTF-8 ?
!DOCTYPE mapperPUBLIC -//mybatis.org//DTD Config 3.0//ENhttp://mybatis.org/dtd/mybatis-3-mapper.dtd
mapper namespacecom.dao.BooksMapperinsert idadd parameterTypebooksinsert into books(bookID,bookName,bookCount,detail) values (#{bookID},#{bookName},#{bookCount},#{detail})/insertdelete iddelete parameterTypeintdelete from books where bookID#{bookID}/deleteupdate idupdate parameterTypebooksupdate books set bookName#{bookName},bookCount#{bookCount},detail#{detail} where bookID#{bookID}/updateselect idselectById resultTypebooksselect * from books where bookID#{bookID};/selectselect idselectAll resultTypebooksselect * from books/select
/mapperservice包
public interface BooksService {int add(Books books);int delete(int bookID);int update(Books books);Books selectById(int bookID);ListBooks selectAll();
}
public class BooksServiceImpl implements BooksService {private BooksMapper booksMapper;public void setBooksMapper(BooksMapper booksMapper) {this.booksMapper booksMapper;}public int add(Books books) {return booksMapper.add(books);}public int delete(int bookID) {return booksMapper.delete(bookID);}public int update(Books books) {return booksMapper.update(books);}public Books selectById(int bookID) {return booksMapper.selectById(bookID);}public ListBooks selectAll() {return booksMapper.selectAll();}
}【注意点这里的serviceImpl别忘了给它set注入】
第三步
最后需要在总的spring.xml文件中导入包
import resourceclasspath:spring-dao.xml/spring整合
第一步
配置整合mybatis 关联数据库文件
context:property-placeholder locationclasspath:database.properties/数据库连接池
bean iddataSource classcom.mchange.v2.c3p0.ComboPooledDataSource!-- 配置连接池属性 --property namedriverClass value${jdbc.driver}/property namejdbcUrl value${jdbc.url}/property nameuser value${jdbc.username}/property namepassword value${jdbc.password}/!-- c3p0连接池的私有属性 --property namemaxPoolSize value30/property nameminPoolSize value10/!-- 关闭连接后不自动commit --property nameautoCommitOnClose valuefalse/!-- 获取连接超时时间 --property namecheckoutTimeout value10000/!-- 当获取连接失败重试次数 --property nameacquireRetryAttempts value2//bean配置SqlSessionFactory对象
bean idsqlSessionFactory classorg.mybatis.spring.SqlSessionFactoryBean
注入数据库连接池
property namedataSource refdataSource/配置MyBaties全局配置文件:mybatis-config.xml
property nameconfigLocation valueclasspath:mybatis-config.xml/
!-- 3.配置SqlSessionFactory对象 --bean idsqlSessionFactory classorg.mybatis.spring.SqlSessionFactoryBean!-- 注入数据库连接池 --property namedataSource refdataSource/!-- 配置MyBaties全局配置文件:mybatis-config.xml --property nameconfigLocation valueclasspath:mybatis-config.xml//bean配置扫描Dao接口包动态实现Dao接口注入到spring容器中
bean classorg.mybatis.spring.mapper.MapperScannerConfigurer!-- 注入sqlSessionFactory --property namesqlSessionFactoryBeanName valuesqlSessionFactory/!-- 给出需要扫描Dao接口包 --property namebasePackage valuecom.dao//bean
?xml version1.0 encodingUTF-8?
web-app xmlnshttp://xmlns.jcp.org/xml/ns/javaeexmlns:xsihttp://www.w3.org/2001/XMLSchema-instancexsi:schemaLocationhttp://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsdversion4.0!--DispatcherServlet--servletservlet-nameDispatcherServlet/servlet-nameservlet-classorg.springframework.web.servlet.DispatcherServlet/servlet-classinit-paramparam-namecontextConfigLocation/param-nameparam-valueclasspath:applicationContext.xml/param-value/init-paramload-on-startup1/load-on-startup/servletservlet-mappingservlet-nameDispatcherServlet/servlet-nameurl-pattern//url-pattern/servlet-mapping!--encodingFilter--filterfilter-nameencodingFilter/filter-namefilter-classorg.springframework.web.filter.CharacterEncodingFilter/filter-classinit-paramparam-nameencoding/param-nameparam-valueutf-8/param-value/init-param/filterfilter-mappingfilter-nameencodingFilter/filter-nameurl-pattern/*/url-pattern/filter-mapping!--Session过期时间--session-configsession-timeout15/session-timeout/session-config/web-appspring-mvc.xml
?xml version1.0 encodingUTF-8?
beans xmlnshttp://www.springframework.org/schema/beansxmlns:xsihttp://www.w3.org/2001/XMLSchema-instancexmlns:contexthttp://www.springframework.org/schema/contextxmlns:mvchttp://www.springframework.org/schema/mvcxsi:schemaLocationhttp://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans.xsdhttp://www.springframework.org/schema/contexthttp://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/mvc https://www.springframework.org/schema/mvc/spring-mvc.xsd!-- 配置SpringMVC --!-- 1.开启SpringMVC注解驱动 --mvc:annotation-driven/!-- 2.静态资源默认servlet配置--mvc:default-servlet-handler/!-- 3.配置jsp 显示ViewResolver视图解析器 --bean classorg.springframework.web.servlet.view.InternalResourceViewResolverproperty nameviewClass valueorg.springframework.web.servlet.view.JstlView/property nameprefix value/WEB-INF/jsp//property namesuffix value.jsp//bean!-- 4.扫描web相关的bean --context:component-scan base-packagecom.controller /
/beans
