jdbc连mysql数据库

package cn.com.sohocat.util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
import java.util.Random;

public class DButil {
	private String driver;
	private String url;
	private String username;
	private String password;
	
	private Connection connection;
	private Statement statement;
	private ResultSet rs;
	
	
	private void init() {
		this.driver="com.mysql.jdbc.Driver";
		this.url = "jdbc:mysql://10.0.0.58:3306/HereOnLine";
		this.username = "root";
		this.password = "soho2010here";
	}
	private Connection getConnect() {
		try {
			Class.forName(this.driver);
			try {
				this.connection = DriverManager.getConnection(this.url, this.username, this.password);
			} catch (SQLException e) {
				e.printStackTrace();
			}
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
		return this.connection;
	}
	public DButil(){
		this.init();
		this.getConnect();
	}
	public int updateSQl(String SQL) {
		try {
			this.statement = this.connection.createStatement();
			return this.statement.executeUpdate(SQL);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return -1;
	}
	public ResultSet querySQL(String SQL) {
		try {
			this.statement = this.connection.createStatement();
			this.rs = this.statement.executeQuery(SQL);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return this.rs;
	}
	public void close() {
		try {
			if(this.rs!=null){
				this.rs.close();
			}
			if(this.statement!=null){
				this.statement.close();
			}
			if(this.connection!=null){
				this.connection.close();
			}
		}catch (SQLException e) {
				e.printStackTrace();
			}
		
		
		}
	public static void main(String[] args) {
		DButil butil = new DButil();
		ResultSet rs = butil.querySQL("select * from HO_User");
		try {
			while(rs.next()) {
				System.out.println("-------------->" + rs.getString("UserName"));
			}
			
//			System.out.println("***************************************");
//			Date date = new Date();
//			Random random = new Random();
//			System.out.println("random.nextInt()"+random.nextInt());
//			System.out.println("random.nextLong()"+random.nextLong());
			
		} catch (SQLException e) {
			e.printStackTrace();
		}
		finally{
			butil.close();
		}
	}
		
}