package?db;

import?java.sql.*;

public?class?Database?{
	private?String?dbDriver?=?“com.mysql.jdbc.Driver“;
	private?String?sConnStr?=?“jdbc:mysql://localhost:3306/upload?useUnicode=true&characterEncoding=UTF-8“;
	//mysql數(shù)據(jù)庫密碼
	private?String?MysplPassword?=?“1234“?;
	public?Connection?connect?=?null;
	public?ResultSet?rs?=?null;
	public?Database（）?{
		try?{
			Class.forName（dbDriver）.newInstance（）;
			connect?=?DriverManager.getConnection（sConnStr?“root“?MysplPassword）;
		}?catch?（Exception?ex）?{
			System.out.println（“連接異常“）;
		}
	}

	public?ResultSet?executeQuery（String?sql）?{
		try?{
			connect?=?DriverManager.getConnection（sConnStr?“root“?MysplPassword）;
			Statement?stmt?=?connect.createStatement（）;
			rs?=?stmt.executeQuery（sql）;
		}?catch?（SQLException?ex）?{
			System.err.println（ex.getMessage（））;
		}
		return?rs;
	}

	public?void?executeUpdate（String?sql）?{
		Statement?stmt?=?null;
		rs?=?null;
		try?{
			connect?=?DriverManager.getConnection（sConnStr?“root“?MysplPassword）;
			stmt?=?connect.createStatement（）;
			stmt.executeUpdate（sql）;
			stmt.close（）;
			connect.close（）;
		}?catch?（SQLException?ex）?{
			System.err.println（ex.getMessage（））;
		}
	}
}