dbutil.java

网上考试系统文件版

/*
 * Created on 2006-4-6
 *
 * To change the template for this generated file go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
package todb;
import java.sql.*;

/**
 * @author admin
 *
 * To change the template for this generated type comment go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
public class DbUtil {
	static String driverName = "org.gjt.mm.mysql.Driver";
	static String dbUrl = "jdbc:mysql://";
	static String mysqlUser = "root"; //数据库用户名
	static String mysqlPsw = "webexam"; //数据库密码

	public DbUtil() {
	}

	public static java.sql.Connection connectToDb(
		String hostName,
		String databaseName)
		throws Exception {
		Connection connection = null;
		String connName =
			dbUrl
				+ hostName
				+ ":3306"
				+ "/"
				+ databaseName
				+ "?user="
				+ mysqlUser
				+ "&password="
				+ mysqlPsw;
		Class.forName(driverName).newInstance();
		connection = DriverManager.getConnection(connName);
		return connection;
	}

	public static java.sql.Connection connectToDb(String databaseName)
		throws Exception {
		return (connectToDb("localhost", databaseName));
	}

	public static java.sql.Connection connectToDb() throws Exception {
		return (connectToDb("localhost", "onlineexam"));
	}

}