JDBC简单封装

1、目录结构：

2、数据库工具类

package util;

import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;



/**
 * 数据库工具类
 *
 */
public class DataSourceUtil {
	private static String driver;
	private static String url;
	private static String username;
	private static String passwd;

	static {
		init();
	}

	/**
	 * 初始化方法
	 */
	public static void init() {
		Properties params = new Properties();
		String configFile = "dataBase.properties";
		InputStream iStream = DataSourceUtil.class.getClassLoader().getResourceAsStream(configFile);
		try {
			params.load(iStream);
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		driver = params.getProperty("driver");
		url = params.getProperty("url");
		username = params.getProperty("username");
		passwd = params.getProperty("passwd");
	}

	/**
	 * 访问一个Connection
	 * @return
	 */
	public static Connection openConnection() {
		Connection conn = null;
		try {
			Class.forName(driver);
			conn = DriverManager.getConnection(url, username, passwd);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return conn;
	}

	/**
	 * 关闭Connection
	 * @param conn
	 */
	public static void closeConnection(Connection conn) {
		if (conn != null) {
			try {
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
}

3、dataBase.properties文件，上面用到了

4、BaseDao类：

package dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import util.DataSourceUtil;


public class BaseDao {
	PreparedStatement ps = null;

	/**
	 * sql查询工具
	 * @param sql sql语句
	 * @param params sql参数  
	 * @return 结果集
	 */
	public ResultSet executeQuery(String sql, Object[] params)
	{
		ResultSet res = null;
		Connection conn = DataSourceUtil.openConnection();
		try {
			ps = conn.prepareStatement(sql);
			for(int i = 0; i < params.length; i++)
			{
				ps.setObject(i+1, params[i]);
			}
			res = ps.executeQuery();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return res;
	}
	/**
	 * sql更新工具
	 * @param sql
	 * @param params
	 * @return
	 */
	public int executeUpdate(String sql, Object[] params)
	{
		int res = 0;
		Connection conn = DataSourceUtil.openConnection();
		try {
			ps = conn.prepareStatement(sql);
			for(int i = 0; i < params.length; i++)
			{
				ps.setObject(i+1, params[i]);
			}
			res = ps.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return res;
	}
}

5、使用示例：

package dao;

import java.util.List;

import entity.Student;

/**
 * 学生类接口
 * 
 *
 */
public interface StudentDao {
	public Student login(String username, String passwd);

	public Student register(String studentName, String passwd, String address, String birthday);

	public List<Student> findStudentAll();
}

package dao.Impl;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import dao.BaseDao;
import dao.StudentDao;
import entity.Student;

/**
 * 学生类接口实现类
 * 
 *
 */
public class StudentDaoImpl extends BaseDao implements StudentDao {

	@Override
	public Student login(String uname, String pwd) {
		Student stu = null;
		String sql = " select * from student where studentname = ? and passwd = ? ";
		Object[] params = new Object[] { uname, pwd };
		ResultSet rs = super.executeQuery(sql, params);
		try {
			while (rs.next()) {
				stu = new Student(rs.getString(1), rs.getString(2), rs.getString(3), rs.getString(4), rs.getString(5));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return stu;
	}

	@Override
	public Student register(String studentName, String passwd, String address, String birthday) {
		Student stu = null;
		String sql = "insert into student values(seq_stuno.nextval,?,?,?,?) ";
		Object[] params = new Object[] { studentName, passwd, address, birthday };
		int cnt = executeUpdate(sql, params);
		if (cnt > 0) {
			stu = login(studentName, passwd);
		}
		return stu;
	}

	@Override
	public List<Student> findStudentAll() {
		List<Student> list = new ArrayList<Student>();
		String sql = " select * from student ";
		Object[] params = new Object[] {};
		ResultSet rs = executeQuery(sql, params);
		try {
			while (rs.next()) {
				Student stu = new Student(rs.getString(1), rs.getString(2), rs.getString(3), rs.getString(4),
						rs.getString(5));
				list.add(stu);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return list;
	}
}