Spring jdbcTemplete datasource

2014-11-24 10:41:04 · 作者: · 浏览: 0

1,applicationContext.xml配置bean


class="org.apache.commons.dbcp.BasicDataSource">
mysql.Driver"/>










2,UserDaoImpl.java

package com.dao;
import org.springframework.jdbc.core.JdbcTemplate;
public class UserDaoImpl extends UserDao{
private JdbcTemplate jdbcTemplete;
public void setJdbcTemplete(JdbcTemplate jdbcTemplete) {
this.jdbcTemplete = jdbcTemplete;
}
public void addData(){
String sql = "insert into m_s(id,name)values(\"6\",\"@-H\")";
jdbcTemplete.update(sql);
}
public int delete(int id){
String sql = "delete from m_s where id = ";
return jdbcTemplete.update(sql, new Object[]{id});
}
}

获取bean工具类;GetBeanUtil.java

package util;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

public class GetBeanUtil {

public static ApplicationContext ac = new ClassPathXmlApplicationContext("applicationContext.xml");

public static Object getBean(String name){
return ac.getBean(name);
}
}

测试

UserDaoImpl userdao = (UserDaoImpl) ac.getBean("useDao");
userdao.addData();
userdao.delete(6);