• SpringJdbc之最强版本，附带十个开源案例！！！！

    导入依赖

    1. <?xml version="1.0" encoding="UTF-8"?>
    2.  
    3. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    4.          xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    5.     <modelVersion>4.0.0</modelVersion>
    6.  
    7.     <groupId>com.xxx</groupId>
    8.     <artifactId>SpringJdbc</artifactId>
    9.     <version>1.0-SNAPSHOT</version>
    10.  
    11.     <name>SpringJdbc</name>
    12.     <!-- FIXME change it to the project's website -->
    13.     <url>http://www.example.com</url>
    14.  
    15.     <properties>
    16.         <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    17.         <maven.compiler.source>1.8</maven.compiler.source>
    18.         <maven.compiler.target>1.8</maven.compiler.target>
    19.     </properties>
    20.  
    21.     <dependencies>
    22.         <dependency>
    23.             <groupId>junit</groupId>
    24.             <artifactId>junit</artifactId>
    25.             <version>4.12</version>
    26.             <scope>test</scope>
    27.         </dependency>
    28.  
    29.         <!--    //引入jdbc的包-->
    30.         <dependency>
    31.             <groupId>org.springframework</groupId>
    32.             <artifactId>spring-jdbc</artifactId>
    33.             <version>5.2.4.RELEASE</version>
    34.         </dependency>
    35.         <!--    //引入mysql数据库驱动包-->
    36.         <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
    37.         <dependency>
    38.             <groupId>mysql</groupId>
    39.             <artifactId>mysql-connector-java</artifactId>
    40.             <version>8.0.19</version>
    41.         </dependency>
    42.  
    43.         <dependency>
    44.             <groupId>org.springframework</groupId>
    45.             <artifactId>spring-context</artifactId>
    46.             <version>5.2.4.RELEASE</version>
    47.         </dependency>
    48.         <!-- https://mvnrepository.com/artifact/org.springframework/spring-test -->
    49.         <dependency>
    50.             <groupId>org.springframework</groupId>
    51.             <artifactId>spring-test</artifactId>
    52.             <version>5.2.4.RELEASE</version>
    53.             <scope>test</scope>
    54.         </dependency>
    55.         <!-- https://mvnrepository.com/artifact/org.aspectj/aspectjweaver -->
    56.         <dependency>
    57.             <groupId>org.aspectj</groupId>
    58.             <artifactId>aspectjweaver</artifactId>
    59.             <version>1.8.9</version>
    60.             <scope>runtime</scope>
    61.         </dependency>
    62.         <!-- https://mvnrepository.com/artifact/org.springframework/spring-tx -->
    63.         <dependency>
    64.             <groupId>org.springframework</groupId>
    65.             <artifactId>spring-tx</artifactId>
    66.             <version>5.3.21</version>
    67.         </dependency>
    68.         <dependency>
    69.             <groupId>com.mchange</groupId>
    70.             <artifactId>c3p0</artifactId>
    71.             <version>0.9.5.2</version>
    72.         </dependency>
    73.         <dependency>
    74.             <groupId>commons-lang</groupId>
    75.             <artifactId>commons-lang</artifactId>
    76.             <version>2.6</version>
    77.         </dependency>
    78.     </dependencies>
    79.  
    80.     <build>
    81.  
    82.     </build>
    83. </project>

    实体类

    1. package com.xxx.po;
    2.  
    3. import java.util.Date;
    4.  
    5. /**
    6.  * @Author 陈平安
    7.  * @Date 2022/6/20 16:58
    8.  * @PackageName:com.xxx.po
    9.  * @ClassName: Account
    10.  * @Description: TODO
    11.  * @Version 1.0
    12.  */
    13. public class Account {
    14.     Integer accountid;//账户id
    15.     String AccountName;//账户名称
    16.     String accountType;//账户 类别
    17.     Double money;//
    18.     Date createDate;//
    19.     Date updateDate;//
    20.     Integer userID;//
    21.  
    22.     public Account() {
    23.     }
    24.  
    25.     public Account(String accountName, String accountType, Double money, Integer userID) {
    26.         AccountName = accountName;
    27.         this.accountType = accountType;
    28.         this.money = money;
    29.         this.userID = userID;
    30.     }
    31.  
    32.     @Override
    33.     public String toString() {
    34.         return "Account{" +
    35.                 "accountid=" + accountid +
    36.                 ", AccountName='" + AccountName + '\'' +
    37.                 ", accountType='" + accountType + '\'' +
    38.                 ", money=" + money +
    39.                 ", createDate=" + createDate +
    40.                 ", updateDate=" + updateDate +
    41.                 ", userID=" + userID +
    42.                 '}';
    43.     }
    44.  
    45.     public Integer getAccountid() {
    46.         return accountid;
    47.     }
    48.  
    49.     public void setAccountid(Integer accountid) {
    50.         this.accountid = accountid;
    51.     }
    52.  
    53.     public String getAccountName() {
    54.         return AccountName;
    55.     }
    56.  
    57.     public void setAccountName(String accountName) {
    58.         AccountName = accountName;
    59.     }
    60.  
    61.     public String getAccountType() {
    62.         return accountType;
    63.     }
    64.  
    65.     public void setAccountType(String accountType) {
    66.         this.accountType = accountType;
    67.     }
    68.  
    69.     public Double getMoney() {
    70.         return money;
    71.     }
    72.  
    73.     public void setMoney(Double money) {
    74.         this.money = money;
    75.     }
    76.  
    77.     public Date getCreateDate() {
    78.         return createDate;
    79.     }
    80.  
    81.     public void setCreateDate(Date createDate) {
    82.         this.createDate = createDate;
    83.     }
    84.  
    85.     public Date getUpdateDate() {
    86.         return updateDate;
    87.     }
    88.  
    89.     public void setUpdateDate(Date updateDate) {
    90.         this.updateDate = updateDate;
    91.     }
    92.  
    93.     public Integer getUserID() {
    94.         return userID;
    95.     }
    96.  
    97.     public void setUserID(Integer userID) {
    98.         this.userID = userID;
    99.     }
    100. }

    db.properties

    1. jdbc.driver=com.mysql.cj.jdbc.Driver
    2. jdbc.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8&userSSL=false&serverTimezone=GMT%2B8
    3. jdbc.user=root
    4. jdbc.password=cjd

    xml配置信息

    1. <?xml version="1.0" encoding="UTF-8"?>
    2. <beans xmlns="http://www.springframework.org/schema/beans"
    3.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"
    4.        xmlns:context="http://www.springframework.org/schema/context"
    5.        xmlns:aop="http://www.springframework.org/schema/aop"
    6.        xmlns:tx="http://www.springframework.org/schema/tx"
    7.        xmlns:task="http://www.springframework.org/schema/task"
    8.        xsi:schemaLocation="http://www.springframework.org/schema/beans
    9.                         http://www.springframework.org/schema/beans/spring-beans-3.1.xsd
    10.                         http://www.springframework.org/schema/context
    11.                         http://www.springframework.org/schema/context/spring-context-3.1.xsd
    12.                         http://www.springframework.org/schema/task
    13.                         http://www.springframework.org/schema/tx
    14.                         http://www.springframework.org/schema/aop
    15.                         http://www.springframework.org/schema/aop/spring-aop.xsd
    16.                         http://www.springframework.org/schema/tx/spring-tx.xsd
    17.                         http://www.springframework.org/schema/task/spring-task-4.1.xsd">
    18. <!--                         http://www.springframework.org/schema/tx-->
    19.  
    20.         <context:component-scan base-package="com.xxx"></context:component-scan>
    21.     <!--    <task:annotation-driven></task:annotation-driven>-->
    22.  
    23.     <context:property-placeholder location="jdbc.properties"></context:property-placeholder>
    24.  
    25.     <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
    26.         <property name="driverClass" value="${jdbc.driver}"></property>
    27.         <property name="jdbcUrl" value="${jdbc.url}"></property>
    28.         <property name="user" value="${jdbc.user}"></property>
    29.         <property name="password" value="${jdbc.password}"></property>
    30.     </bean>
    31.  
    32.     <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
    33.         <property name="dataSource" ref="dataSource"></property>
    34.     </bean>
    35.  
    36. <aop:aspectj-autoproxy></aop:aspectj-autoproxy>
    37.     <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    38.         <!--注入数据源-->
    39.         <property name="dataSource" ref="dataSource"></property>
    40.     </bean>
    41. <tx:annotation-driven transaction-manager="transactionManager"></tx:annotation-driven>
    42.     <tx:advice id="txAdvice" transaction-manager="transactionManager">
    43.         <tx:attributes>
    44.             <tx:method name="add" propagation="REQUIRED"/>
    45.             <tx:method name="update" propagation="REQUIRED"/>
    46.             <tx:method name="delete" propagation="REQUIRED"/>
    47.             <tx:method name="query" read-only="true"/>
    48.         </tx:attributes>
    49.     </tx:advice>
    50. <aop:config>
    51.     <aop:pointcut id="cut" expression="execution(* com.xxx.service..*.*(..))"/>
    52. </aop:config>
    53. </beans>

    10个方法接口：

    1. package com.xxx.Dao;
    2.  
    3. import com.xxx.po.Account;
    4.  
    5. import java.util.List;
    6.  
    7. /**
    8.  * @Author 陈平安
    9.  * @Date 2022/6/20 17:02
    10.  * @PackageName:com.xxx.Dao
    11.  * @ClassName: IAaccount
    12.  * @Description: TODO
    13.  * @Version 1.0
    14.  */
    15.  
    16. public interface IAaccount {
    17.     public int addAccount(Account account);
    18.  
    19.     public int addAccountHasKey(Account account);
    20.  
    21.     public int addAccountBath(List<Account> accounts);
    22.  
    23.     public int queryAccount(int userID);
    24.  
    25.     public Account queryAccountID(int accountid);
    26.  
    27.     public List<Account> queryAccountParmy(Integer userID, String accountName, String
    28.             accountType);
    29.  
    30.     public int UpdateAccount(Account account);
    31.  
    32.  
    33.     public int updateAccountBath(List<Account> accounts);
    34.  
    35.     public int deleteAccount(int accountid);
    36.  
    37.     public int deleteAccountBatch(Integer[] ids);
    38.  
    39.     public int outAccount(Integer accountId, Double money);
    40.  
    41.     public int inAccount(Integer accountId, Double money);
    42. }
    1. package com.xxx.Dao.impl;
    2.  
    3. import com.xxx.Dao.IAaccount;
    4. import com.xxx.po.Account;
    5. import org.apache.commons.lang.StringUtils;
    6. import org.springframework.jdbc.core.BatchPreparedStatementSetter;
    7. import org.springframework.jdbc.core.JdbcTemplate;
    8. import org.springframework.jdbc.core.PreparedStatementCreator;
    9. import org.springframework.jdbc.support.GeneratedKeyHolder;
    10. import org.springframework.jdbc.support.KeyHolder;
    11. import org.springframework.stereotype.Repository;
    12.  
    13. import javax.annotation.Resource;
    14. import java.sql.*;
    15. import java.util.ArrayList;
    16. import java.util.List;
    17.  
    18. /**
    19.  * @Author 陈平安
    20.  * @Date 2022/6/20 17:24
    21.  * @PackageName:com.xxx.impl
    22.  * @ClassName: ImpleAccount
    23.  * @Description: TODO
    24.  * @Version 1.0
    25.  */
    26. @Repository
    27. public class ImpleAccount implements IAaccount {
    28.     @Resource
    29.     private JdbcTemplate jdbcTemplate;
    30.  
    31.     @Override
    32.     public int addAccount(Account account) {
    33.         String sql = "insert into tb_account (account_name,account_type,money,user_id) values (?,?,?,?)";
    34.         Object[] objects = {account.getAccountName(), account.getAccountType(),
    35.                 account.getMoney(), account.getUserID()};
    36.         int nows = jdbcTemplate.update(sql, objects);
    37.         return nows;
    38.     }
    39.  
    40.     @Override
    41.     public int addAccountHasKey(Account account) {
    42.         String sql = "insert into tb_account (account_name,account_type,money,user_id) values (?,?,?,?)";
    43.  
    44.         KeyHolder keyHolder = new GeneratedKeyHolder();
    45.         jdbcTemplate.update(connection -> {
    46.             PreparedStatement ps = connection.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
    47.             ps.setString(1, account.getAccountName());
    48.             ps.setString(2, account.getAccountType());
    49.             ps.setDouble(3, account.getMoney());
    50.             ps.setInt(4, account.getUserID());
    51.             return ps;
    52.  
    53.         }, keyHolder);
    54.  
    55.         int key = keyHolder.getKey().intValue();
    56.         return key;
    57.     }
    58.  
    59.     @Override
    60.     public int addAccountBath(List<Account> accounts) {
    61.         String sql = "insert into tb_account (account_name,account_type,money,user_id) values (?,?,?,?)";
    62.         int rows = jdbcTemplate.batchUpdate(sql, new BatchPreparedStatementSetter() {
    63.             @Override
    64.             public void setValues(PreparedStatement ps, int i) throws SQLException {
    65.                 Account account = accounts.get(i);
    66.                 ps.setString(1, account.getAccountName());
    67.                 ps.setString(2, account.getAccountType());
    68.                 ps.setDouble(3, account.getMoney());
    69.                 ps.setInt(4, account.getUserID());
    70.  
    71.             }
    72.  
    73.             @Override
    74.             public int getBatchSize() {
    75.                 return accounts.size();
    76.             }
    77.         }).length;
    78.         return rows;
    79.     }
    80.  
    81.     @Override
    82.     public int queryAccount(int userID) {
    83.         String sql = "select count(1) from tb_account where user_id = ?";
    84.         int count = jdbcTemplate.queryForObject(sql, Integer.class, userID);
    85.         return count;
    86.     }
    87.  
    88.     @Override
    89.     public Account queryAccountID(int accountid) {
    90.         String sql = "select * from tb_account where account_id =?";
    91.         Account account = jdbcTemplate.queryForObject(sql, (resultSet, i) -> {
    92.             Account account1 = new Account();
    93.             account1.setAccountid(accountid);
    94.             account1.setAccountName(resultSet.getString("account_name"));
    95.             account1.setAccountType(resultSet.getString("account_type"));
    96.             account1.setMoney(resultSet.getDouble("money"));
    97.             account1.setUserID(resultSet.getInt("user_id"));
    98.             return account1;
    99.         }, accountid);
    100.  
    101.  
    102.         return account;
    103.     }
    104.  
    105.     @Override
    106.     public List<Account> queryAccountParmy(Integer userID, String accountName,
    107.                                            String accountType) {
    108.  
    109.         String sql = "select * from tb_account where user_id = ?";
    110.         List<Object> list = new ArrayList<>();
    111.         list.add(userID);
    112.         if (StringUtils.isNotBlank(accountName)) {
    113.             sql += " and account_name like concat('%',?,'%')";
    114.             list.add(accountName);
    115.         }
    116.  
    117.         if (StringUtils.isNotBlank(accountType)) {
    118.             sql += " and account_type = ?";
    119.             list.add(accountType);
    120.         }
    121.  
    122.  
    123.         Object[] objects = list.toArray();
    124.         List<Account> accountList = jdbcTemplate.query(sql, objects, (ResultSet resultSet, int i) -> {
    125.             Account account1 = new Account();
    126.             account1.setAccountid(resultSet.getInt("user_id"));
    127.             account1.setAccountName(resultSet.getString("account_name"));
    128.             account1.setAccountType(resultSet.getString("account_type"));
    129.             account1.setMoney(resultSet.getDouble("money"));
    130.             account1.setUserID(resultSet.getInt("user_id"));
    131.             return account1;
    132.         });
    133.  
    134.  
    135.         return accountList;
    136.     }
    137.  
    138.     @Override
    139.     public int UpdateAccount(Account account) {
    140.         String sql = "update tb_account set account_name = ? ,account_type = ?,money = ? ";
    141.         Object[] objects = {account.getAccountName(), account.getAccountType(), account.getMoney()};
    142.  
    143.         int rows = jdbcTemplate.update(sql, objects);
    144.  
    145.  
    146.         return rows;
    147.     }
    148.  
    149.     /**
    150.      * @param accounts
    151.      * @return
    152.      */
    153.     @Override
    154.     public int updateAccountBath(List<Account> accounts) {
    155.         String sql = "update tb_account set account_name = ? ,account_type = ?,money = ? ";
    156.         int rows = jdbcTemplate.batchUpdate(sql, new BatchPreparedStatementSetter() {
    157.             @Override
    158.             public void setValues(PreparedStatement ps, int i) throws SQLException {
    159.                 Account account = accounts.get(i);
    160.                 ps.setString(1, account.getAccountName());
    161.                 ps.setString(2, account.getAccountType());
    162.                 ps.setDouble(3, account.getMoney());
    163.  
    164.  
    165.             }
    166.  
    167.             @Override
    168.             public int getBatchSize() {
    169.                 return accounts.size();
    170.             }
    171.         }).length;
    172.  
    173.  
    174.         return rows;
    175.     }
    176.  
    177.     @Override
    178.     public int deleteAccount(int accountid) {
    179.         String sql = "delete from tb_account where account_id = ?";
    180.  
    181.         int row = jdbcTemplate.update(sql, accountid);
    182.  
    183.         return row;
    184.     }
    185.  
    186.     @Override
    187.     public int deleteAccountBatch(Integer[] ids) {
    188.         String sql = "delete from tb_account where account_id = ?";
    189.         int rows = jdbcTemplate.batchUpdate(sql, new BatchPreparedStatementSetter() {
    190.             @Override
    191.             public void setValues(PreparedStatement ps, int i) throws SQLException {
    192.                 ps.setInt(1, ids[i]);
    193.             }
    194.  
    195.             @Override
    196.             public int getBatchSize() {
    197.                 return ids.length;
    198.             }
    199.         }).length;
    200.  
    201.         return rows;
    202.     }
    203.  
    204.     @Override
    205.     public int outAccount(Integer accountId, Double money) {
    206.         String sql = "update tb_account set money = money - ? where account_id = ?";
    207.         Object[] objects = {money,accountId};
    208.         return jdbcTemplate.update(sql,objects);
    209.     }
    210.  
    211.     @Override
    212.     public int inAccount(Integer accountId, Double money) {
    213.         String sql = "update tb_account set money = money + ? where account_id = ?";
    214.         Object[] objects = {money,accountId};
    215.         return jdbcTemplate.update(sql,objects);
    216.     }
    217. }

    测试：

    1. package com.xxx.Test;
    2.  
    3. import org.junit.Test;
    4. import org.springframework.context.ApplicationContext;
    5. import org.springframework.context.support.ClassPathXmlApplicationContext;
    6. import org.springframework.jdbc.core.JdbcTemplate;
    7.  
    8. /**
    9.  * @Author 陈平安
    10.  * @Date 2022/6/20 16:46
    11.  * @PackageName:com.xxx.Test
    12.  * @ClassName: test01
    13.  * @Description: TODO
    14.  * @Version 1.0
    15.  */
    16. public class test01 {
    17.     @Test
    18.     public void testjdbc(){
    19.         ApplicationContext ac =new ClassPathXmlApplicationContext("spring.xml");
    20.         JdbcTemplate jdbcTemplate = (JdbcTemplate) ac.getBean("jdbcTemplate");
    21.         String sql = "select count(1) from tb_account";
    22.         Integer integer = jdbcTemplate.queryForObject(sql,Integer.class);
    23.         System.out.println(integer);
    24.     }
    25. }

    结果： 

     测试案例的进一步封装：

    1. package com.xxx.Test;
    2.  
    3. import org.junit.Before;
    4. import org.junit.Test;
    5. import org.springframework.context.ApplicationContext;
    6. import org.springframework.context.support.ClassPathXmlApplicationContext;
    7. import org.springframework.jdbc.core.JdbcTemplate;
    8.  
    9. /**
    10.  * @Author 陈平安
    11.  * @Date 2022/6/20 16:46
    12.  * @PackageName:com.xxx.Test
    13.  * @ClassName: test01
    14.  * @Description: TODO
    15.  * @Version 1.0
    16.  */
    17. public class test02 {
    18.     private JdbcTemplate jdbcTemplate;
    19.  
    20.     @Before
    21.     public void init() {
    22.         ApplicationContext ac = new ClassPathXmlApplicationContext("spring.xml");
    23.         jdbcTemplate = (JdbcTemplate) ac.getBean("jdbcTemplate");
    24.     }
    25.  
    26.  
    27.     @Test
    28.     public void testjdbc() {
    29.  
    30.         String sql = "select count(1) from tb_account";
    31.         Integer integer = jdbcTemplate.queryForObject(sql, Integer.class);
    32.         System.out.println(integer);
    33.     }
    34. }

    测试案例的再一步封装：

    1. package com.xxx.Test;
    2.  
    3. import com.xxx.Dao.IAaccount;
    4. import com.xxx.po.Account;
    5. import org.junit.Before;
    6. import org.junit.Test;
    7. import org.junit.runner.RunWith;
    8. import org.springframework.context.ApplicationContext;
    9. import org.springframework.context.support.ClassPathXmlApplicationContext;
    10. import org.springframework.jdbc.core.JdbcTemplate;
    11. import org.springframework.test.context.ContextConfiguration;
    12. import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
    13.  
    14. import javax.annotation.Resource;
    15.  
    16. /**
    17.  * @Author 陈平安
    18.  * @Date 2022/6/20 16:46
    19.  * @PackageName:com.xxx.Test
    20.  * @ClassName: test01
    21.  * @Description: TODO
    22.  * @Version 1.0
    23.  */
    24.  
    25. public class test03 extends BaseTest{
    26.     @Resource
    27.     private JdbcTemplate jdbcTemplate;
    28.     @Resource
    29.     private IAaccount iAaccount;
    30.     @Before
    31.     public void init() {
    32.         ApplicationContext ac = new ClassPathXmlApplicationContext("spring.xml");
    33.         jdbcTemplate = (JdbcTemplate) ac.getBean("jdbcTemplate");
    34.     }
    35.  
    36.  
    37.     @Test
    38.     public void testjdbc() {
    39.  
    40.         String sql = "select count(1) from tb_account";
    41.         Integer integer = jdbcTemplate.queryForObject(sql, Integer.class);
    42.         System.out.println(integer);
    43.     }
    44.  
    45.     @Test
    46.     public void test() {
    47.         Account account = new Account("account03", "jianhang03", 3000.0, 3);
    48.         int row = iAaccount.addAccount(account);
    49.         System.out.println(row);
    50.     }
    51. }
    1. package com.xxx.Test;
    2.  
    3. import org.junit.runner.RunWith;
    4. import org.springframework.test.context.ContextConfiguration;
    5. import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
    6.  
    7. /**
    8.  * @Author 陈平安
    9.  * @Date 2022/6/20 16:55
    10.  * @PackageName:com.xxx.Test
    11.  * @ClassName: BaseTest
    12.  * @Description: TODO
    13.  * @Version 1.0
    14.  */
    15. @RunWith(SpringJUnit4ClassRunner.class)
    16. @ContextConfiguration(locations = {"classpath:spring.xml"})
    17. public class BaseTest {
    18.  
    19. }

     运行结果：

     

    以下是10个方法的测试案例：

    1. package com.xxx.Test;
    2.  
    3. import com.xxx.Dao.IAaccount;
    4. import com.xxx.po.Account;
    5. import com.xxx.service.AccountService;
    6. import org.junit.Test;
    7.  
    8. import javax.annotation.Resource;
    9. import java.util.ArrayList;
    10. import java.util.List;
    11.  
    12. /**
    13.  * @Author 陈平安
    14.  * @Date 2022/6/21 10:36
    15.  * @PackageName:com.xxx.Test
    16.  * @ClassName: AddTest01
    17.  * @Description: TODO
    18.  * @Version 1.0
    19.  */
    20. public class AddTest01 extends BaseTest {
    21.  
    22.     @Resource
    23.     private IAaccount iAaccount;
    24.  
    25.     @Test
    26.     public void test() {
    27.         Account account = new Account("account03", "jianhang03", 3000.0, 3);
    28.         int row = iAaccount.addAccount(account);
    29.         System.out.println(row);
    30.     }
    31.  
    32.     @Test
    33.     public void test01() {
    34.         Account account = new Account("account05", "jianhang04", 30001.0, 4);
    35.         int key = iAaccount.addAccountHasKey(account);
    36.         System.out.println(key);
    37.     }
    38.  
    39.     @Test
    40.     public void test02() {
    41.         Account account = new Account("account05", "jianhang04", 30001.0, 4);
    42.         Account account2 = new Account("account06", "jianhang06", 30006.0, 6);
    43.         Account account3 = new Account("account07", "jianhang07", 30007.0, 7);
    44.         List<Account> list = new ArrayList<>();
    45.         list.add(account);
    46.         list.add(account2);
    47.         list.add(account3);
    48.  
    49.         int key = iAaccount.addAccountBath(list);
    50.         System.out.println("数值======" + key);
    51.     }
    52.  
    53.     @Test
    54.     public void test03() {
    55.         // Account account = new Account("account05", "jianhang04", 30001.0, 4);
    56.         int key = iAaccount.queryAccount(0);
    57.         System.out.println("数值1======" + key);
    58.     }
    59.  
    60.     @Test
    61.     public void test04() {
    62.         Account account = iAaccount.queryAccountID(1);
    63.  
    64.         // int key = iAaccount.queryAccount(0);
    65.         System.out.println("数值1======" + account.toString());
    66.     }
    67.  
    68.     @Test
    69.     public void test05() {
    70.         List<Account> accountList = iAaccount.queryAccountParmy(1, "account01", null);
    71.         System.out.println(accountList.toString());
    72.  
    73.         // int key = iAaccount.queryAccount(0);
    74.         //System.out.println("数值1======"+account.toString());
    75.     }
    76.  
    77.     @Test
    78.     public void test06() {
    79.         Account account = new Account("account05000", "jianhang04", 30001.0, 4);
    80.         account.setAccountid(1);
    81.  
    82.         int key = iAaccount.UpdateAccount(account);
    83.         System.out.println("数值1======" + key);
    84.     }
    85.  
    86.     @Test
    87.     public void test07() {
    88.  
    89.         Account account = new Account("account05", "jianhang04", 30001.0, 4);
    90.         account.setAccountid(1);
    91.         Account account2 = new Account("account06", "jianhang06", 30006.0, 6);
    92.         account.setAccountid(2);
    93.         Account account3 = new Account("account07", "jianhang07", 30007.0, 7);
    94.         account.setAccountid(3);
    95.         List<Account> list = new ArrayList<>();
    96.         list.add(account);
    97.         list.add(account2);
    98.         list.add(account3);
    99.  
    100.         int key = iAaccount.updateAccountBath(list);
    101.         System.out.println("数值1======" + key);
    102.     }
    103.  
    104.     @Test
    105.     public void test08() {
    106.  
    107.         Integer[] id = {2, 3, 4};
    108.  
    109.         int key = iAaccount.deleteAccountBatch(id);
    110.         System.out.println("数值1======" + key);
    111.     }
    112.  
    113.     @Resource
    114.     private AccountService accountService;
    115.  
    116.     @Test
    117.     public void test09() {
    118.         int code = accountService.updateAccontByTranfer(10, 11, 100.0);
    119. if (code == 1){
    120.     System.out.println("success");
    121. }else {
    122.     System.out.println("fail");
    123. }
    124.     }
    125.  
    126. }

    ！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！

    在此更正一i下配置文件xml文件

    1. <?xml version="1.0" encoding="UTF-8"?>
    2. <beans xmlns="http://www.springframework.org/schema/beans"
    3.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"
    4.        xmlns:context="http://www.springframework.org/schema/context"
    5.        xmlns:aop="http://www.springframework.org/schema/aop"
    6.        xmlns:tx="http://www.springframework.org/schema/tx"
    7.        xmlns:task="http://www.springframework.org/schema/task"
    8.        xsi:schemaLocation="http://www.springframework.org/schema/beans
    9.                         http://www.springframework.org/schema/beans/spring-beans-3.1.xsd
    10.                         http://www.springframework.org/schema/context
    11.                         http://www.springframework.org/schema/context/spring-context-3.1.xsd
    12.                         http://www.springframework.org/schema/task
    13.                         http://www.springframework.org/schema/tx
    14.                         http://www.springframework.org/schema/aop
    15.                         http://www.springframework.org/schema/aop/spring-aop.xsd
    16.                         http://www.springframework.org/schema/tx/spring-tx.xsd
    17.                         http://www.springframework.org/schema/task/spring-task-4.1.xsd">
    18. <!--                         http://www.springframework.org/schema/tx-->
    19.  
    20.         <context:component-scan base-package="com.xxx"></context:component-scan>
    21.     <!--    <task:annotation-driven></task:annotation-driven>-->
    22.  
    23.     <context:property-placeholder location="jdbc.properties"></context:property-placeholder>
    24.  
    25.     <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
    26.         <property name="driverClass" value="${jdbc.driver}"></property>
    27.         <property name="jdbcUrl" value="${jdbc.url}"></property>
    28.         <property name="user" value="${jdbc.user}"></property>
    29.         <property name="password" value="${jdbc.password}"></property>
    30.     </bean>
    31.  
    32.     <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
    33.         <property name="dataSource" ref="dataSource"></property>
    34.     </bean>
    35.  
    36. <aop:aspectj-autoproxy></aop:aspectj-autoproxy>
    37.     <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    38.         <!--注入数据源-->
    39.         <property name="dataSource" ref="dataSource"></property>
    40.     </bean>
    41. <!--<tx:annotation-driven transaction-manager="transactionManager"></tx:annotation-driven>-->
    42. <!--    <tx:advice id="txAdvice" transaction-manager="transactionManager">-->
    43. <!--        <tx:attributes>-->
    44. <!--            <tx:method name="add" propagation="REQUIRED"/>-->
    45. <!--            <tx:method name="update" propagation="REQUIRED"/>-->
    46. <!--            <tx:method name="delete" propagation="REQUIRED"/>-->
    47. <!--            <tx:method name="query" read-only="true"/>-->
    48. <!--        </tx:attributes>-->
    49. <!--    </tx:advice>-->
    50. <aop:config>
    51.     <aop:pointcut id="cut" expression="execution(* com.xxx.service..*.*(..))"/>
    52. </aop:config>
    53. </beans>

    数据库表：

     

     

  • 相关阅读:
    （最优化理论与方法）第二章最优化所需基础知识-第八节：次梯度
    Linux操作系统——进程控制【一】
    Linux代码初试__进度条
    DHCP服务初探
    pytest+allure 详细版
    qt+ffmpeg视频播放器实现音视频倍速功能
    线程的深度剖析
    ITSS认证现场的评估过程基本步骤
    【仿真】carsim、prescan、simulink联合仿真教程、笔记、操作
    助推科技强国高质量发展《科创超级训练营》系列活动正式拉开帷幕
  • 原文地址：https://blog.csdn.net/qq_63772260/article/details/125439997