dbmaster.java

来自「基于java的图文报表系统的设计与实现,报表的生成一直是企业级应用系统开发时专案」· Java 代码 · 共 81 行

package dbmaster;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class DbMaster {
	static String DBDriver = "com.mysql.jdbc.Driver";

	static String Url = "jdbc:mysql://localhost:3306/jsbgglxt";

	static String User = "root";

	static String Password = "";

	static Connection con = null;

	ResultSet rs = null;

	static String myexception = null;

	public String getMyexception() {
		return myexception;
	}

	public DbMaster() {
		try {
			Class.forName(DBDriver);
		} catch (java.lang.ClassNotFoundException e) {
			System.err.println("Opendb (): " + e.getMessage());
		}
	}

	public static Connection createConn() throws ClassNotFoundException {
		try {
			Class.forName(DBDriver);
			con = DriverManager.getConnection(Url, User, Password);

		} catch (SQLException e) {
			System.err.println("executeUpdate:" + e.getMessage());
			setMyexception(e.getMessage());
		}
		return con;
	}

	public ResultSet executeQuery(String sql) {
		rs = null;
		try {
			con = DriverManager.getConnection(Url, User, Password);
			Statement stmt = con.createStatement();
			rs = stmt.executeQuery(sql);
		} catch (SQLException e) {
			System.err.println("executeQuery:" + e.getMessage());
			setMyexception(e.getMessage());
		}
		return rs;
	}

	public void executeUpdate(String sql) {
		rs = null;
		try {
			con = DriverManager.getConnection(Url, User, Password);
			Statement stmt = con.createStatement();
			stmt.executeUpdate(sql);
		} catch (SQLException e) {
			System.err.println("executeUpdate:" + e.getMessage());
			setMyexception(e.getMessage());
		}
	}

	public Connection getCon() {
		return con;
	}

	public static void setMyexception(String myexception) {
		DbMaster.myexception = myexception;
	}
}