mydb.java

含有图形化界面

package com.zsf.manager;

import java.sql.*;

public class MyDB {
	private static final String database = "mydb";
	private static final String user = "root";
	private static final String password = "123456";
	
	private Connection connection;
	private Statement statement;
	
	public void openConnection() throws SQLException {
		try {
			Class.forName("com.mysql.jdbc.Driver");
			String url = "jdbc:mysql://localhost/" + database;
			connection = DriverManager.getConnection(url, user, password);
			statement = connection.createStatement();
		} catch (ClassNotFoundException e) {
			throw new SQLException(e.getMessage());
		}
	}
	
	public void closeConnection() {
		try {
			if (statement != null) statement.close();
			if (connection != null) connection.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	public int executeUpdate(String sql) throws SQLException {
		return statement.executeUpdate(sql);
	}
	
	public ResultSet executeQuery(String sql) throws SQLException {
		return statement.executeQuery(sql);
	}
	
}