spring JdbcTemplate数据库

DAO

package DAO;

import org.springframework.jdbc.core.JdbcTemplate;

public class OrderDao {

    private JdbcTemplate jdbcTemplate;

    public JdbcTemplate getJdbcTemplate() {

        return jdbcTemplate;

    }

    public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {

        this.jdbcTemplate = jdbcTemplate;

    }

    public  int  addOrder(String outTradeNo,String subject,String totalAmount,String authcode){

        String sql ="insert into orders(outTradeNo,subject,totalAmount,authcode) values(?,?,?,?)";

        int ret = jdbcTemplate.update(sql, new String[]{outTradeNo,subject,totalAmount,authcode});

        return ret;

    }

}

POJO

 private String outTradeNo;

    private String subject;

    private String totalAmount;

    private String authCode;

SET/GET

service

package service;

import DAO.OrderDao;

public class OrderService {

    private OrderDao orderDao;

    public void setOrderDao(OrderDao orderDao) {

        this.orderDao = orderDao;

    }

    public boolean order(String outTradeNo,String subject,String totalAmount,String authCode){

        int ret = orderDao.addOrder(outTradeNo,subject,totalAmount,authCode);

        if(ret>0) return true;

        return false;

    }

}

applicationContex.xml



    <!--配置数据库信息-->

    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">

        <property name="driverClassName" value="com.mysql.jdbc.Driver"/>

        <property name="url" value="jdbc:mysql://localhost:3306/paydb"/>

        <property name="username" value="root"/>

        <property name="password" value="root"/>

    </bean>

    <!--定义spring数据库模板-->

    <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">

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

    </bean>

    <!--注册DAO组件 使用依赖注入jdbcTemplate-->

    <bean id="OrderDao" class="DAO.OrderDao">

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

    </bean>

巴特西

spring JdbcTemplate数据库

最新文章

热门文章