springmvc+spring+jdbc综合练习

最新推荐文章于 2024-07-18 13:50:38 发布

qq_39095899

最新推荐文章于 2024-07-18 13:50:38 发布

阅读量177

点赞数 1

分类专栏： mybaits+spring+springmvc 文章标签： spring ss+jdbc整合

本文链接：https://blog.csdn.net/qq_39095899/article/details/106760345

版权

mybaits+spring+springmvc 专栏收录该内容

19 篇文章 0 订阅

订阅专栏

springmvc+spring+jdbc

项目整合
要求：

查询所有账户余额
查询某个账户余额
充值给指定账户充值
提现从指定账户提现
转账

创建项目添加依赖jar包

1 导jar包
pom.xml中的jar引入

<dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-webmvc</artifactId>
      <version>5.1.14.RELEASE</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/javax.servlet/javax.servlet-api -->
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>javax.servlet-api</artifactId>
      <version>4.0.1</version>
      <scope>provided</scope>
    </dependency>
    <!-- https://mvnrepository.com/artifact/com.alibaba/fastjson -->
    <dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>fastjson</artifactId>
      <version>1.2.62</version>
    </dependency>

    <!-- https://mvnrepository.com/artifact/commons-fileupload/commons-fileupload -->
    <dependency>
      <groupId>commons-fileupload</groupId>
      <artifactId>commons-fileupload</artifactId>
      <version>1.3.3</version>
    </dependency>
    
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-context-support</artifactId>
      <version>5.1.14.RELEASE</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-test</artifactId>
      <version>5.1.14.RELEASE</version>
    </dependency>

    <!-- https://mvnrepository.com/artifact/commons-logging/commons-logging -->
    <dependency>
      <groupId>commons-logging</groupId>
      <artifactId>commons-logging</artifactId>
      <version>1.2</version>
    </dependency>

    <!--aop 面向切面编程需要的jar包-->
    <!--aop-->
    <!--aspects-->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-aspects</artifactId>
      <version>5.1.14.RELEASE</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/aopalliance/aopalliance -->
    <dependency>
      <groupId>aopalliance</groupId>
      <artifactId>aopalliance</artifactId>
      <version>1.0</version>
    </dependency>
    
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-tx</artifactId>
      <version>5.1.14.RELEASE</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-jdbc</artifactId>
      <version>5.1.14.RELEASE</version>
    </dependency>

    <!-- https://mvnrepository.com/artifact/com.mchange/c3p0 -->
    <dependency>
      <groupId>com.mchange</groupId>
      <artifactId>c3p0</artifactId>
      <version>0.9.5.2</version>
    </dependency>
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.47</version>
    </dependency>

创建对应配置文件

创建db.properties

jdbc.jdbcUrl = jdbc:mysql://localhost:3306/mybaits
jdbc.driverClass = com.mysql.jdbc.Driver
jdbc.user = root
jdbc.password = 123456

spring中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"
       xmlns:aop="http://www.springframework.org/schema/aop" xmlns:p="http://www.springframework.org/schema/p"
       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 http://www.springframework.org/schema/aop https://www.springframework.org/schema/aop/spring-aop.xsd">
    <context:component-scan base-package="com.lanou.pojo,com.lanou.dao,com.lanou.service,com.lanou.interceptor,com.lanou.utils"></context:component-scan>
    <!--开启aop注解-->
    <aop:aspectj-autoproxy></aop:aspectj-autoproxy>
    <context:property-placeholder location="classpath:db.properties"></context:property-placeholder>
    <bean name="dataSource"
          class="com.mchange.v2.c3p0.ComboPooledDataSource"
          p:jdbcUrl="${jdbc.jdbcUrl}"
          p:driverClass="${jdbc.driverClass}"
          p:user="${jdbc.user}"
          p:password="${jdbc.password}">
    </bean>
    <!-- bean jdbcTemplate -->
    <bean name="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
        <property name="dataSource" ref="dataSource"/>
    </bean>
    <!--平台事务管理器-->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"></property>
    </bean>
    

</beans>

创建springmvc中的配置文件springmvc-servlet.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:mvc="http://www.springframework.org/schema/mvc"
       xmlns:p="http://www.springframework.org/schema/p"
       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
       http://www.springframework.org/schema/mvc
       https://www.springframework.org/schema/mvc/spring-mvc.xsd
       ">
    <!--定义注解扫描的包-->
    <context:component-scan base-package="com.lanou.controller"></context:component-scan>
    <!--内部视图资源解析器-->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/jsp/"></property>
        <property name="suffix" value=".jsp"></property>
    </bean>
    <!--解决返回json数据乱码问题-->
    <mvc:annotation-driven>
        <mvc:message-converters register-defaults="true">
            <bean class="org.springframework.http.converter.StringHttpMessageConverter">
                <property name="supportedMediaTypes">
                    <list>
                        <value>text/html;charset=utf-8</value>
                        <value>application/json;charset=utf-8</value>
                        <value>text/plain;charset=utf-8</value>
                        <value>application/xml;charset=utf-8</value>
                    </list>
                </property>
            </bean>
        </mvc:message-converters>
    </mvc:annotation-driven>
    <!--springmvc配置静态资源处理-->
    <mvc:resources mapping="/static/**" location="/static/"></mvc:resources>
</beans>

3 创建好对应的包结构
在pojo包中创建与数据库表对应的ArAccount.java

public class ArAccount {
    private Integer id;
    private String username;
    private Double money;
    //...
}

在static 下创建js包引入jquey-xx-xx.js
创建一个静态页面

比如第一个功能查询所有账户信息

控制层(controller)


import com.alibaba.fastjson.JSON;
import com.lanou.pojo.ArAccount;
import com.lanou.service.ArAccountService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import java.util.List;

@Controller
@RequestMapping("/arAccount")
public class ArAcountController {
    @Autowired
    private ArAccountService arAccountService;
    @RequestMapping("/findAll")
    @ResponseBody
    public String fincdAll(){
        List<ArAccount> list = arAccountService.findAll();
        return JSON.toJSONString(list);
    }
 }

service层

ArAccountService 接口



public interface ArAccountService {
    //查询所有账户余额
    List<ArAccount> findAll();
}

实现类

@Service
public class ArAccountServiceImpl implements ArAccountService {
    @Autowired
    private ArAccountDao dao;
    @Override
    public List<ArAccount> findAll() {
        return dao.findAll();
    }

dao层

ArAccountDao接口

public interface ArAccountDao {
    //查询所有账户余额
    List<ArAccount> findAll();
}

ArAccountDaoImpl实现类



@Repository
public class ArAccountDaoImpl implements ArAccountDao {
    @Autowired
    private JdbcTemplate jdbcTemplate;
    @Override
    public List<ArAccount> findAll() {
        String sql = "select * from ar_account";
        List<ArAccount> list = jdbcTemplate.query(sql, new RowMapper<ArAccount>() {
            @Override
            public ArAccount mapRow(ResultSet resultSet, int i) throws SQLException {
                ArAccount arAccount = new ArAccount();
                arAccount.setId(resultSet.getInt("id"));
                arAccount.setUsername(resultSet.getString("username"));
                arAccount.setMoney(resultSet.getDouble("money"));
                return arAccount;
            }
        });
        return list;
    }

前端页面显示

<script type="text/javascript" src="/static/js/jquery-3.4.1.js"></script>
    <script type="text/javascript">

        $(function () {
            $.get("/arAccount/findAll",function (data) {
                for (var s=0; s< data.length;s++){
                   $("tbody").append("<tr><td>"+data[s].id+"</td><td>"+data[s].username+"</td><td>"+data[s].money+"</td></tr>")
                 }

            },"json");
        });
</script>

前端页面

<table>
        <thead>
        <tr>
            <td>id</td>
            <td>账户名</td>
            <td>资金</td>
        </tr>
        </thead>
        <tbody>
        </tbody>
    </table>

在这里插入图片描述

qq_39095899

关注

1
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
springmvc+spring+jdbc综合练习

springmvc+spring+jdbc项目整合要求：查询所有账户余额查询某个账户余额充值给指定账户充值提现从指定账户提现转账创建项目添加依赖jar包1 导jar包pom.xml中的jar引入<dependency> <groupId>org.springframework</groupId> <artifactId>spring-webmvc</artifactId> &l
复制链接

扫一扫