java连接MySql数据库

import java.sql.*;


public class openDB {
	
	private Connection conn;
	private String url;
	private String username;
	private String password;
	private Statement stmt;
	private String driver;
	private String message;
	
	 public openDB() {
	           
            driver="com.mysql.jdbc.Driver";
            url ="jdbc:mysql://localhost:3306/xscj";
            conn=null;
            username="root";
            password="5817513";
            message="";
            //String sql="select * from xs";
            //ResultSet rs=stmt.executeQuery(sql);


            //while(rs.next()) {
              //  System.out.print(rs.getString("姓名")+"\t");
                //System.out.println(rs.getString("课程名"));
            //}


            
            //rs.close();
            //stmt.close();
            //conn.close();        	
	}
	 
	 public openDB(String url,String username,String pwd){
		 this.url=url;
		 this.username=username;
		 this.password=pwd;
		 this.message="";
	 }
	 
	 public void connect(){
		 try{
			 Class.forName(driver);
	         conn= DriverManager.getConnection(url,username,password);
	         stmt=conn.createStatement();
	       }
		 catch(ClassNotFoundException e)
		 {
			 this.message="connection:"+e;
			 e.printStackTrace();
		 }
		 catch(SQLException E)
		 {
			 this.message="executeQuery:"+E;
		 }
	 }
	 
	 public void closeConnection(){
		 try{
			 conn.close();
		 }
		 catch(SQLException E)
		 {
			 this.message="executeQuery:"+E;
		 }
	 }
	 
	 public void executeUpdate(String SQLcommad){
		 try{
			 this.stmt.executeUpdate(SQLcommad);
		 }
		 catch(SQLException E)
		 {
			 this.message="executeQuery:"+E;
		 }
	 }
	 
	 public ResultSet executeQuery(String SQLcommad){
		 
		 ResultSet resultset=null;
		 try{
			 resultset=this.stmt.executeQuery(SQLcommad);
		 }
		 catch(SQLException E)
		 {
			 this.message="executeQuery:"+E;
		 }
		 return resultset;
	 }
}