spring 事务

最新推荐文章于 2025-09-07 20:32:33 发布

转载最新推荐文章于 2025-09-07 20:32:33 发布 · 46 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/xiaoyu1997/p/6672148.html

文章标签：

#java

首先建两个实体类：

Account 持股票

Stock 股票

实现这两个接口

public class StockImpl extends JdbcDaoSupport implements StockDao {
    public int addstock(Stock stock) {
        String sql="insert into stock(sname,counts) values(?,?)";
        int stouccount = getJdbcTemplate().update(sql, stock.getStockname(), stock.getStockmoney());
        return stouccount;
    }

    public int updatestock(int sid, int stockmoney, boolean isMoreOrLess) {
       String sql="";
       if(isMoreOrLess){
           //ture   销售股票
          sql="update stock set counts=counts-? where sid=?";
       }else {

           sql="update stock set counts=counts+? where sid=?";
       }
        int count = getJdbcTemplate().update(sql,stockmoney,sid);
        return count;
    }
    public void setJdbcTemplate2(JdbcTemplate jdbcTemplate) {
        super.setJdbcTemplate(jdbcTemplate);
    }
}

public class AccountImpl extends JdbcDaoSupport implements AccountDao {
    public int Addcount(Account account) {
       String sql="insert into account(aname,balance) values(?,?)";
        int count = getJdbcTemplate().update(sql, account.getAccountname(), account.getAccountyu());
        return count;
    }
    public int updateAccount(int add, int accountyu, boolean isMoreOrLess) {
     String sql="";
     if(isMoreOrLess){
         //余额增加    销售股票
         sql="update account set balance=balance+? where aid=?";

     }else{
         sql="update account set balance=balance-? where aid=?";
     }
     int count=getJdbcTemplate().update(sql,accountyu,add);
        return count;
    }
    public void setJdbcTemplate2(JdbcTemplate jdbcTemplate) {
        super.setJdbcTemplate(jdbcTemplate);
    }

}

service接口

public interface IAccountService {
    public int Addcount(Account account);

    public int addstock(Stock stock);

    public int update(int aid,int money,int sid,int stockmoney);
}

实现service

public class StockImpl extends JdbcDaoSupport implements StockDao {
    public int addstock(Stock stock) {
        String sql="insert into stock(sname,counts) values(?,?)";
        int stouccount = getJdbcTemplate().update(sql, stock.getStockname(), stock.getStockmoney());
        return stouccount;
    }

    public int updatestock(int sid, int stockmoney, boolean isMoreOrLess) {
       String sql="";
       if(isMoreOrLess){
           //ture   销售股票
          sql="update stock set counts=counts-? where sid=?";
       }else {

           sql="update stock set counts=counts+? where sid=?";
       }
        int count = getJdbcTemplate().update(sql,stockmoney,sid);
        return count;
    }
    public void setJdbcTemplate2(JdbcTemplate jdbcTemplate) {
        super.setJdbcTemplate(jdbcTemplate);
    }
}

public class AccountImpl extends JdbcDaoSupport implements AccountDao {
    public int Addcount(Account account) {
       String sql="insert into account(aname,balance) values(?,?)";
        int count = getJdbcTemplate().update(sql, account.getAccountname(), account.getAccountyu());
        return count;
    }

    public int updateAccount(int add, int accountyu, boolean isMoreOrLess) {
     String sql="";
     if(isMoreOrLess){
         //余额增加    销售股票
         sql="update account set balance=balance+? where aid=?";

     }else{
         sql="update account set balance=balance-? where aid=?";
     }
     int count=getJdbcTemplate().update(sql,accountyu,add);
        return count;
    }
    public void setJdbcTemplate2(JdbcTemplate jdbcTemplate) {
        super.setJdbcTemplate(jdbcTemplate);
    }

}

转载于:https://www.cnblogs.com/xiaoyu1997/p/6672148.html