database.java

本网站为学生管理网站

package students;
import java.sql.Connection;
import java.sql.DriverManager;

public class Database {

	static String driverName = "com.mysql.jdbc.Driver";

	static String dbUrl ="jdbc:mysql://";
	
	static String serverName = "localhost:3306/";

	static String databaseName = "students";

	static String userName = "root";

	static String password = "19870524";

	public Database() {
	}

	public static void setValue(String servername, String dataBaseName, String username, String pswd)
	{
		serverName = servername;
		databaseName = dataBaseName;
		userName = username;
		password = pswd;
	}

	public static java.sql.Connection connectToDb() throws Exception {
		Connection connection = null;

		String connName = dbUrl + serverName + databaseName;
		Class.forName(driverName);
		connection = DriverManager.getConnection(connName, userName, password);
		return connection;
	}
}