SSM框架之Spring层--》业务层框架

SSM框架之Spring层–》业务层框架

环境:jdk 1.8 mysql 8.0.20 maven 3.6.3 mybatis 3.5.2

  1. 创建数据库

    create table User_msg(
    	User_id int not null primary key,  
      User_name varchar(40),  
    	User_sex varchar(10),
    	User_email varchar(40),
    	User_number varchar(40)
    	
    )
    
    insert into User_msg(User_id,User_name,User_sex,User_email,User_number) values  
    (1,'小明','男','1767471@qq.com','12345611'),
    (2,'花花','男','1762427@qq.com','12345632'),
    (3,'亮亮','男','176743@qq.com','12345612'),
    (4,'小光','男','1767447@qq.com','12345634'),
    (5,'小妹','男','1767457@qq.com','12345654'),
    (6,'莹莹','男','1767467@qq.com','12345655'),
    (7,'喜喜','男','1767467@qq.com','11234421')
    
  2. 打开idea新建一个maven项目

    [外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-xp4sH9EF-1605800063189)(D:\桌面\笔记\书城项目\mybatis层.assets\image-20201031020053386.png)]

  3. 导入项目依赖

      <!--Junit-->
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>4.12</version>
            </dependency>
            <!--数据库驱动-->
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.47</version>
            </dependency>
            <!-- 数据库连接池 -->
            <dependency>
                <groupId>com.mchange</groupId>
                <artifactId>c3p0</artifactId>
                <version>0.9.5.2</version>
            </dependency>
    
            <!--Servlet - JSP -->
            <dependency>
                <groupId>javax.servlet</groupId>
                <artifactId>servlet-api</artifactId>
                <version>2.5</version>
            </dependency>
            <dependency>
                <groupId>javax.servlet.jsp</groupId>
                <artifactId>jsp-api</artifactId>
                <version>2.2</version>
            </dependency>
            <dependency>
                <groupId>javax.servlet</groupId>
                <artifactId>jstl</artifactId>
                <version>1.2</version>
            </dependency>
    
            <!--Mybatis-->
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis</artifactId>
                <version>3.5.2</version>
            </dependency>
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis-spring</artifactId>
                <version>2.0.2</version>
            </dependency>
    
            <!--Spring-->
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-webmvc</artifactId>
                <version>5.1.9.RELEASE</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-jdbc</artifactId>
                <version>5.1.9.RELEASE</version>
            </dependency>
            <dependency>
                <groupId>org.projectlombok</groupId>
                <artifactId>lombok</artifactId>
                <version>1.16.10</version>
            </dependency>
    
  4. 配置资源过滤器

     <!--配置资源过滤器-->
        <build>
            <resources>
                <resource>
                    <directory>src/main/java</directory>
                    <includes>
                        <include>**/*.properties</include>
                        <include>**/*.xml</include>
                    </includes>
                    <filtering>false</filtering>
                </resource>
                <resource>
                    <directory>src/main/resources</directory>
                    <includes>
                        <include>**/*.properties</include>
                        <include>**/*.xml</include>
                    </includes>
                    <filtering>false</filtering>
                </resource>
            </resources>
        </build>
    
    

    com.liang.dao

    • UserMapper
    package com.liang.dao;
    
    
    import com.liang.pojo.UserMessage;
    
    import java.util.List;
    
    public interface UserMapper {
    
        UserMessage queryUserById(int id);
    
    
        List<UserMessage> queryAllUser();
    }
    
    
    • UserMapper.xml
    <?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE mapper
            PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
            "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    <mapper namespace="com.liang.dao.UserMapper">
    
        <!--根据id查询,返回一个Book-->
        <select id="queryUserById" resultType="UserMessage">
          select * from bookstore.user_msg
          where User_id = #{User_id}
       </select>
    
        <!--查询全部Book-->
        <select id="queryAllUser" resultType="UserMessage">
          SELECT * from bookstore.user_msg
       </select>
    
    </mapper>
    

com.liang.pojo

  • UserMessage
package com.liang.pojo;

public class UserMessage {
    private int User_id;
    private String User_name;
    private String User_sex;
    private String User_email;
    private String User_number;

    public UserMessage() {
    }

    public UserMessage(int user_id, String user_name, String user_sex, String user_email, String user_number) {
        User_id = user_id;
        User_name = user_name;
        User_sex = user_sex;
        User_email = user_email;
        User_number = user_number;
    }

    public int getUser_id() {
        return User_id;
    }

    public void setUser_id(int user_id) {
        User_id = user_id;
    }

    public String getUser_name() {
        return User_name;
    }

    public void setUser_name(String user_name) {
        User_name = user_name;
    }

    public String getUser_sex() {
        return User_sex;
    }

    public void setUser_sex(String user_sex) {
        User_sex = user_sex;
    }

    public String getUser_email() {
        return User_email;
    }

    public void setUser_email(String user_email) {
        User_email = user_email;
    }

    public String getUser_number() {
        return User_number;
    }

    public void setUser_number(String user_number) {
        User_number = user_number;
    }

    @Override
    public String toString() {
        return "UserMessage{" +
                "User_id=" + User_id +
                ", User_name='" + User_name + '\'' +
                ", User_sex='" + User_sex + '\'' +
                ", User_email='" + User_email + '\'' +
                ", User_number='" + User_number + '\'' +
                '}';
    }
}

com.liang.service

  • UserService接口
package com.liang.service;

import com.liang.dao.UserMapper;
import com.liang.pojo.UserMessage;

import java.util.List;

public interface UserService {
    UserMessage queryUserById(int id);
    List<UserMessage> queryAllUser();

}

  • UserServiceImpl.xml
package com.liang.service;

import com.liang.dao.UserMapper;
import com.liang.pojo.UserMessage;

import java.util.List;

public class UserServiceImpl  implements UserService{
    private UserMapper userMapper;

    public void setUserMapper(UserMapper userMapper) {
        this.userMapper = userMapper;
    }

    @Override
    public UserMessage queryUserById(int id) {
        return userMapper.queryUserById(id);
    }

    @Override
    public List<UserMessage> queryAllUser() {
        return userMapper.queryAllUser();
    }
}

resources目录下

  • applicationContext.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"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
       http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd">

    <import resource="classpath:spring-dao.xml"/>
    <import resource="classpath:spring-service.xml"/>
</beans>
  • database.properties
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ssmbuild?useSSL=false&useUnicode=true&characterEncoding=utf8
jdbc.username=root
jdbc.password=1234
  • 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>

    <!--取别名-->
    <typeAliases>
        <package name="com.liang.pojo"/>
    </typeAliases>
    <mappers>
       <!-- <mapper resource="com/liang/dao/UserMapper.xml"></mapper>-->
            <mapper class="com.liang.dao.UserMapper"></mapper>
        <!--  <package name="com.liang.dao"/>-->
    </mappers>
<!--去掉了原来的数据库环境-->
</configuration>
  • spring-dao.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"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
       http://www.springframework.org/schema/beans/spring-beans.xsd
       http://www.springframework.org/schema/context
       https://www.springframework.org/schema/context/spring-context.xsd">
<!--关联一下数据库文件-->
<context:property-placeholder location="database.properties"></context:property-placeholder>

<!--数据库连接池-->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
    <property name="driverClass" value="${jdbc.driver}"/>
    <property name="jdbcUrl" value="${jdbc.url}"/>
    <property name="user" value="${jdbc.username}"/>
    <property name="password" value="${jdbc.password}"/>
    <!--私有属性-->
    <!-- c3p0连接池的私有属性 -->
    <property name="maxPoolSize" value="30"/>
    <property name="minPoolSize" value="10"/>
    <!-- 关闭连接后不自动commit -->
    <property name="autoCommitOnClose" value="false"/>
    <!-- 获取连接超时时间 -->
    <property name="checkoutTimeout" value="10000"/>
    <!-- 当获取连接失败重试次数 -->
    <property name="acquireRetryAttempts" value="2"/>
</bean>
<!--配置SqlSessionFactory对象-->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!-- 注入数据库连接池 -->
        <property name="dataSource" ref="dataSource"/>
        <!-- 配置MyBaties全局配置文件:mybatis-config.xml -->
        <property name="configLocation" value="classpath:mybatis-config.xml"/>

    </bean>
    <!-- 4.配置扫描Dao接口包,动态实现Dao接口注入到spring容器中 -->
    <!--解释 :https://www.cnblogs.com/jpfss/p/7799806.html-->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <!-- 注入sqlSessionFactory -->
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
        <!-- 给出需要扫描Dao接口包 -->
        <property name="basePackage" value="com.liang.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"
       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">
    <!--扫描service相关的bean-->
<context:component-scan base-package="com.liang.service"></context:component-scan>


        <!--UserServiceImpl注入到ioc容器中-->
        <bean id="UserServiceImpl" class="com.liang.service.UserServiceImpl">
        <property name="userMapper" ref="userMapper"></property>
        </bean>
    <!--s配置事务管理-->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"></property>
    </bean>
    </beans>
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值