How to use : Java GUI Example Database Class (Easy use)

CREATE TABLE `member` (
  `UserID` int(4) unsigned zerofill NOT NULL auto_increment,
  `Username` varchar(20) NOT NULL,
  `Password` varchar(20) NOT NULL,
  `Email` varchar(150) NOT NULL,
  `Name` varchar(250) NOT NULL,
  PRIMARY KEY  (`UserID`),
  UNIQUE KEY `User` (`Username`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

-- 
-- dump ตาราง `member`
-- 

INSERT INTO `member` VALUES (0001, 'weerachai', 'weerachai@1', '[email protected]', 'Weerachai Nukitram');
INSERT INTO `member` VALUES (0002, 'surachai', 'surachai@2', '[email protected]', 'Surachai Sirisart');
INSERT INTO `member` VALUES (0003, 'adisorn', 'adisorn@3', '[email protected]', 'Adisorn Bonsong');

package com.java.myapp;

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

public class DatabaseConnect {
	
	private static Connection connect = null;
	private static Statement s = null;
	
	public DatabaseConnect()
	{
		try {
			Class.forName("com.mysql.jdbc.Driver");
			connect =   DriverManager.getConnection("jdbc:mysql://localhost/mydatabase" +
					"?user=root&password=root");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public ResultSet getResultSet(String strSQL)
	{
		try {
			s = connect.createStatement();
			return s.executeQuery(strSQL);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return null;
	}
	
	public Boolean executeQuery(String strSQL)
	{
		try {
			s = connect.createStatement();
			s.execute(strSQL);
			return true;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			return false;
		}
	}
	
	public void closeConnect()
	{
		try {
			if (s != null) {
				s.close();
				connect.close();
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			System.out.println(e.getMessage());
			e.printStackTrace();
		}
	}
    
}

/*** Connect Database ***/
DatabaseConnect connect = new DatabaseConnect();

/*** Select Query ****/
String sql = "SELECT * FROM  customer " +
		"ORDER BY CustomerID ASC";

ResultSet rec = connect.getResultSet(sql);
try {
	while ((rec != null) && (rec.next())) {
		
		System.out.println(rec.getString("CustomerID"));
		System.out.println(rec.getString("Name"));
		System.out.println(rec.getString("Email"));
		System.out.println(rec.getString("CountryCode"));
		System.out.println(rec.getString("Budget"));
		System.out.println(rec.getString("Used"));
	}
} catch (SQLException e) {
	// TODO Auto-generated catch block
	e.printStackTrace();
}


/*** Close Database ****/
connect.closeConnect();

/*** Connect Database ***/
DatabaseConnect connect = new DatabaseConnect();

/*** Insert Query ****/
String sql = "INSERT INTO customer " +
		"(CustomerID,Name,Email,CountryCode,Budget,Used) " + 
		"VALUES ('C005','Chai Surachai','[email protected]'" +
		",'TH','1000000','0') ";
Boolean status = connect.executeQuery(sql);

if(status) {
	System.out.print("Record Inserted Successfully");
} else {
	System.out.print("Error Cannot Insert Data!");
}

/*** Close Database ****/
connect.closeConnect();

/*** Connect Database ***/
DatabaseConnect connect = new DatabaseConnect();

/*** Update Query ****/
String sql = "UPDATE customer " +
		"SET Budget = '5000000' " +
		" WHERE CustomerID = 'C005' ";
Boolean status = connect.executeQuery(sql);

if(status) {
	System.out.print("Record Update Successfully");
} else {
	System.out.print("Error Cannot Update Data!");
}

/*** Close Database ****/
connect.closeConnect();

/*** Connect Database ***/
DatabaseConnect connect = new DatabaseConnect();

/*** Delete Query ****/
String sql = "DELETE FROM customer " +
		" WHERE CustomerID = 'C005' ";
Boolean status = connect.executeQuery(sql);

if(status) {
	System.out.print("Record Delete Successfully");
} else {
	System.out.print("Error Cannot Delete Data!");
}

/*** Close Database ****/
connect.closeConnect();