LibrarySystem图书管理系统（二）

本文实例为大家分享了librarysystem图书管理系统第二篇，供大家参考，具体内容如下

第一步：添加数据库配置文件

jdbc.properties

# 数据库驱动

jdbc.driver=com.mysql.jdbc.driver

# 数据库地址

jdbc.url=jdbc:mysql://localhost:3306/library?useunicode=true&characterencoding=utf-8

# 用户名

jdbc.username=root

# 密码

jdbc.password=root

# 初始化连接

initialsize=0

# 最大连接数量

maxactive=20

# 最大空闲连接

maxidle=20

# 最小空闲连接

minidle=1

# 超时等待时间

maxwait=60000

第二步：添加mybatis配置文件

mybatis-config.xml

<?xml version="1.0" encoding="utf-8" ?>

<!doctype configuration public "-//mybatis.org//dtd config 3.0//en" "http://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>

<settings>

<setting name="usegeneratedkeys" value="true"/>

<setting name="usecolumnlabel" value="true"/>

<setting name="mapunderscoretocamelcase" value="true"/>

</settings>

</configuration>

第三步：添加spring配置文件

在resources/spring目录下新建二个文件：

│ └── spring
│ ├── spring-mybatis.xml
│ ├── spring-service.xml
│ └── spring-mvc.xml

spring-mvc.xml

<?xml version="1.0" encoding="utf-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" xmlns:p="http://www.springframework.org/schema/p"

xmlns:context="http://www.springframework.org/schema/context"

xmlns:mvc="http://www.springframework.org/schema/mvc"

xsi:schemalocation="http://www.springframework.org/schema/beans

http://www.springframework.org/schema/beans/spring-beans-4.0.xsd

http://www.springframework.org/schema/context

http://www.springframework.org/schema/context/spring-context-4.0.xsd

http://www.springframework.org/schema/mvc

http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">

<context:component-scan base-package="com.ray.controller"/>

<mvc:default-servlet-handler/>

<mvc:annotation-driven>

<mvc:message-converters>

<bean class="org.springframework.http.converter.stringhttpmessageconverter">

<property name="supportedmediatypes">

<list>

<value>text/plain;charset=utf-8</value>

<value>text/html;charset=utf-8</value>

<value>application/json;charset=utf-8</value>

</list>

</property>

</bean>

</mvc:message-converters>

</mvc:annotation-driven>

<bean class="org.springframework.web.servlet.view.internalresourceviewresolver">

<property name="prefix" value="/web-inf/views/"/>

<property name="suffix" value=".jsp"/>

</bean>

</beans>

spring-mybatis.xml

<?xml version="1.0" encoding="utf-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

xmlns:xsi="http://www.w3.org/2001/xmlschema-instance"

xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx"

xsi:schemalocation="http://www.springframework.org/schema/beans

http://www.springframework.org/schema/beans/spring-beans-3.1.xsd

http://www.springframework.org/schema/context

http://www.springframework.org/schema/context/spring-context-3.1.xsd

http://www.springframework.org/schema/tx

http://www.springframework.org/schema/tx/spring-tx.xsd">

<context:property-placeholder location="classpath:jdbc.properties"/>

<bean id="datasource" class="com.alibaba.druid.pool.druiddatasource" init-method="init" destroy-method="close">

<property name="driverclassname" value="${jdbc.driver}"/>

<property name="url" value="${jdbc.url}"/>

<property name="username" value="${jdbc.username}"/>

<property name="password" value="${jdbc.password}"/>

<property name="initialsize" value="1"/>

<property name="minidle" value="1"/>

<property name="maxactive" value="10"/>

<property name="maxwait" value="10000"/>

<property name="timebetweenevictionrunsmillis" value="60000"/>

<property name="minevictableidletimemillis" value="300000"/>

<property name="validationquery" value="select 1" />

<property name="testwhileidle" value="true"/>

<property name="testonborrow" value="true"/>

<property name="testonreturn" value="false"/>

<property name="poolpreparedstatements" value="true"/>

<property name="maxpoolpreparedstatementperconnectionsize" value="20"/>

<property name="defaultautocommit" value="true" />

<property name="filters" value="stat"/>

</bean>

<bean id="sqlsessionfactory" class="org.mybatis.spring.sqlsessionfactorybean">

<property name="configlocation" value="classpath:mybatis-config.xml"/>

<property name="datasource" ref="datasource"/>

<property name="mapperlocations" value="classpath:mapping/*.xml"/>

</bean>

<bean class="org.mybatis.spring.mapper.mapperscannerconfigurer">

<property name="basepackage" value="com.ray.dao"/>

</bean>

</beans>

spring-service.xml

<?xml version="1.0" encoding="utf-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

xmlns:xsi="http://www.w3.org/2001/xmlschema-instance"

xmlns:context="http://www.springframework.org/schema/context"

xmlns:tx="http://www.springframework.org/schema/tx"

xsi:schemalocation="http://www.springframework.org/schema/beans

http://www.springframework.org/schema/beans/spring-beans.xsd

http://www.springframework.org/schema/context

http://www.springframework.org/schema/context/spring-context.xsd

http://www.springframework.org/schema/tx

http://www.springframework.org/schema/tx/spring-tx.xsd">

<context:component-scan base-package="com.ray"/>

<bean id="transactionmanager" class="org.springframework.jdbc.datasource.datasourcetransactionmanager">

<property name="datasource" ref="datasource"/>

</bean>

<tx:annotation-driven transaction-manager="transactionmanager"/>

</beans>

第四步：添加logback配置文件

logback配置比log4j要简单点，功能类似

├── resources
│ ├── logback.xml

在resources文件夹下新建文件：logback.xml

<?xml version="1.0" encoding="utf-8" ?>

<configuration debug="true">

<appender name="stdout" class="ch.qos.logback.core.consoleappender">

<encoder>

<pattern>%d{hh:mm:ss.sss} [%thread] %-5level %logger{36} - %msg%n</pattern>

</encoder>

</appender>

<root level="debug">

<appender-ref ref="stdout" />

</root>

</configuration>

第五步：配置web.xml

web.xml

<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/xmlschema-instance"

xsi:schemalocation="http://xmlns.jcp.org/xml/ns/javaee

http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"

version="3.1" metadata-complete="true">

<display-name>archetype created web application</display-name>

<servlet>

<servlet-name>seckill-dispatcher</servlet-name>

<servlet-class>org.springframework.web.servlet.dispatcherservlet</servlet-class>

<!-- 配置springmvc需要加载的配置文件

spring-dao.xml,spring-service.xml,spring-web.xml

mybatis - > spring -> springmvc

-->

<init-param>

<param-name>contextconfiglocation</param-name>

<param-value>classpath:spring/spring-*.xml</param-value>

</init-param>

<load-on-startup>1</load-on-startup>

<async-supported>true</async-supported>

</servlet>

<servlet-mapping>

<servlet-name>seckill-dispatcher</servlet-name>

<url-pattern>/</url-pattern>

</servlet-mapping>

<filter>

<filter-name>characterencodingfilter</filter-name>

<filter-class>

org.springframework.web.filter.characterencodingfilter

</filter-class>

<init-param>

<param-name>encoding</param-name>

<param-value>utf-8</param-value>

</init-param>

</filter>

<filter-mapping>

<filter-name>characterencodingfilter</filter-name>

<url-pattern>/*</url-pattern>

</filter-mapping>

</web-app>

项目结构:

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持快网idc。

原文链接：https://blog.csdn.net/q343509740/article/details/80411511

LibrarySystem图书管理系统（二）

相关文章

快网idc优惠网

相关文章

微信

快网idc优惠网

QQ交流群