简单实现DButil工具类

DButil工具类的定义

定义一个工具类，类中实现连接方法，释放资源方法，查询方法，修改方法。

interface IRowMapper{
   
	void rowMapper(ResultSet rs);
}
public class DButil {
   
	static Connection con =null;
	static Statement sta =null;
	static String sql =null;
	static ResultSet result = null;
	public static Connection getConnection() {
   ...}
	
	public static boolean upDate(String sql) {
   ...}

	public static void sel(IRowMapper rowMapper,String sql) {
   ...}
	
	private static void close(Statement statement,Connection connection) {
   ...}

	private static void close(ResultSet result,Statement statement,Connection connection) {
   ...}
}

1、连接方法

public static Connection getConnection() {
   
		try {
   
			Class.forName("com.mysql.jdbc.Driver");
			return DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test", "root", "");	
		} catch (Exception e) {
   
			e.printStackTrace();
		}
		return null;
	}

此方法返回一个Connection型数据使用时可以直接Connection con = DButil.getConnection();来获取连接 。
2、释放资源

private static void close(Statement statement,Connection connection) {
   
		try {
   
			if (statement!=null) {
   
				statement.close();
			}
		} catch (SQLException e) {
   
			e.printStackTrace();
		}
		try {
   
			if (connection!=null) {
   
				connection.close();
			}
		} catch (SQLException e) {
   
			e.printStackTrace();
		}
	}
	private static void close(ResultSet result,Statement statement,Connection connection) {
   
		try {
   
			if (result!=null)