pls wok

package project;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

public class Diary {
	private static Connection connect = null;
	  private static String host="localhost:3307";
	  private static String database="ia188";
	  private static String username="ia188";
	  private static String password="iw5fah3A";

	  public static Connection getConnection(){
			if(connect ==null){
				try{
				 Class.forName("com.mysql.jdbc.Driver");
			      String conn_string="jdbc:mysql://"+host+"/"+database;
			      Connection connect = DriverManager.getConnection(conn_string,username,password);
			      return connect;
				}catch(Exception ex){
					ex.printStackTrace();
					 return null;
				}
			}else{
				return connect;
			}
		}



	  ArrayList<String[]> entries = new ArrayList<String[]>();

public ArrayList<String[]> getEntries() {
		return entries;
	}

public Diary (String Username){

	//  String sql="SELECT * from Member WHERE Username=?;";
    String sql= "SELECT * from Diary WHERE Username=?";
  	try( Connection connect = getConnection();
	    	 PreparedStatement pstmt = connect.prepareStatement(sql);
  		){
	    	 pstmt.setString(1,Username);

	    	 System.out.println(pstmt);


	    	 try (ResultSet rs = pstmt.executeQuery();){
	    	   while(rs.next()){
	    		  String user = rs.getString("Username");
		    	  String date = rs.getString("Date");
		    	  String text = rs.getString("Text");
		    	  String[] entry = {date, text};
		    	  entries.add(entry);
		    	  break;

		      }
	    	 }
  	}catch(SQLException ex){
  		System.out.println(ex);
  		ex.printStackTrace();
  	}
}


}