dbmaster.java

基于java的图文报表系统的设计与实现,报表的生成一直是企业级应用系统开发时专案人员所面临的严峻课题.同时也是信息化系统中重要的一环。优秀的报表工具以实现将数据转化为信息.为决策提供良好的依据.为信息

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;
	}
}