oracle的封装

oracle的封装

1，先在根目录下创建一个配置文件 src->properties

2，封装工具类 util->JDBCUtil

package util;

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

public class JDBCUtil {
   
	private static String driver;
	private static String url;
	private static String username;
	private static String password;

	static {
   
		// 创建properties对象获取文件
		Properties ps = new Properties();
		// 获取流对象
		InputStream is = JDBCUtil.class.getResourceAsStream("/properties");
		try {
   
			// 加载文件
			ps.load(is);
			driver = ps.getProperty("driver");
			url = ps.getProperty("url");
			username = ps.getProperty("username");
			password = ps.getProperty("password");
			// 加载驱动
			Class.forName(driver);
		} catch (IOException e) {
   
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
   
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	/**
	 * 获取链接对象
	 *
	 * @return conn
	 */
	public static Connection getConnection() {
   
		Connection conn = null;
		try {
   
			conn = DriverManager.getConnection(url, username, password);
		} catch (SQLException e) {
   
			e.printStackTrace();
		}
		return conn;
	}

	/**
	 * 创建链接对象
	 *
	 * @param conn
	 * @param sql
	 * @return ps
	 */
	public static PreparedStatement getPreparedStatement(Connection conn,
			String sql) {
   
		PreparedStatement ps = null;
		try {
   
			ps = conn.prepareStatement(sql);
		} catch (SQLException e) {
   
			e.printStackTrace();
		}
		return ps;

	}

	/**
	 * 增刪改通用语句
	 *
	 * @param sql
	 * @param objs
	 * @return i
	 */
	public static int executeDML(String sql, Object... objs) {
   </