DButils

 

配置db.propertis文件

 这里需要填写自己的数据库地址，名字密码等等，顺序和参数名最好不要改变

 

 

————————————————配置类 JDBCutil类————————————————

package com.JDBCutil;

import java.io.FileInputStream;

import org.apache.tomcat.dbcp.dbcp2.BasicDataSource;
import org.apache.tomcat.dbcp.dbcp2.BasicDataSourceFactory;

import java.util.Properties;

/**
 * 
 * 加载配置文件
 * @return BasicDataSource类对象
 */
public class JDBCutil {
	
	private static BasicDataSource bs = null;
	static {
		
		try {
			//加载配置文件
			Properties ps = new Properties();
			FileInputStream fileInputStream = new FileInputStream("db.propertis");
			
			ps.load(fileInputStream);
			bs = BasicDataSourceFactory.createDataSource(ps);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}
	
	public static BasicDataSource getBasicDataSource() {
		return bs;
	}
	
}

 

 

————————————Dao层 mydao类——————————

package dao;

import java.sql.SQLException;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;

import com.JDBCutil.JDBCutil;

import javaBean.Admin;
import javaBean.Goods;

public class MyDao {

	public void insert(Admin ad) throws SQLException {
		
		String sql = "insert into Admin(name , password) values (? , ?)";
		QueryRunner qr = new QueryRunner(JDBCutil.getBasicDataSource());
		
		qr.update(sql , ad.getName() , ad.getPassword());
		
		
	}

	public void select(int id) throws SQLException {
		String sql = "select * from Goods where id = ?";
		QueryRunner qr = new QueryRunner(JDBCutil.getBasicDataSource());
		
		Goods query = qr.query(sql , new BeanHandler<Goods>(Goods.class) , id);
		System.out.println(query);
	}
	
	
  }
	 

 ————————Juint4测试————————

	@Test
	public void insert() throws SQLException {
		Admin ad = new Admin("lalal" , "qweqwe");
		new MyDao().insert(ad);
	}
	
	@Test
	public void select() throws Exception{
		new MyDao().select(17);
	}