GWT+MySQL Best Practice

Migrating from GWT-EXT to native GWT has never been an easy task as I expect it would. I took me some moths to really absorb the fundamentals of its Java code, structure and pattern.

The price for taking this challenge was undoubtedly more gratifying especially on performance and size. I had lesser reboot due to memory leak and I had better handling on syntax especially on database due to its strict use of its object.

Here are some improvements on my code:

DatabaseServiceImpl.java

String url = "jdbc:mysql://localhost:3306/";
String db = "mydb";
String driver = "com.mysql.jdbc.Driver";
String user = "myuser";
String password = "mypassword";


public String connectDatabase() {
String resultString;

try{

Class.forName(driver).newInstance();
conn = DriverManager.getConnection(url+db, user, password);
//conn = DriverManager.getConnection(url, user, password);

resultString="Connected";
}
catch(Exception e){
System.err.println("Unable to connect");
e.printStackTrace();
//System.exit(1);
resultString="failed";
}
return resultString;
}


public ArrayList querryReturnListofProducts(){
ArrayList info = new ArrayList();

if (connectDatabase().equals("Connected")){
try {
select=conn.prepareStatement("SELECT * FROM productsmain");

result=select.executeQuery();

while (result.next()){
DatabaseDTO dbaseDTO=new DatabaseDTO();
dbaseDTO.setproductName(result.getString("name"));
dbaseDTO.setproductImagelocation(result.getString("imagelocation"));
dbaseDTO.setproductLinklocation(result.getString("linklocation"));
dbaseDTO.setSQLRemarks("Access Granted");

info.add(dbaseDTO);

}


select.close();
conn.close();


}catch (SQLException e) {
e.printStackTrace();

}


}
return info;
}

In simpler term you must assign a value to your Arraylist function. In my case its a "DatabaseDTO"

Which contains the following code.

DatabaseDTO.java

public class DatabaseDTO implements IsSerializable{
private String productName;
private String productImagelocation;
private String productLinklocation;
private String sqlremarks;

public void setSQLRemarks(String sqlremarks) {
this.sqlremarks = sqlremarks;

}

public String getSQLRemarks() {
return this.sqlremarks;
}

public void setproductName(String productName) {
this.productName = productName;

}

public String getproductName() {
return this.productName;
}

public void setproductImagelocation(String productImagelocation) {
this.productImagelocation = productImagelocation;

}

public String getproductImagelocation() {
return this.productImagelocation;
}

public void setproductLinklocation(String productLinklocation) {
this.productLinklocation = productLinklocation;

}

public String getproductLinklocation() {
return this.productLinklocation;
}
}

To retrieve your data from the database use this code:

final DatabaseServiceAsync databaseSVC=DatabaseService.Util.getInstance();
databaseSVC.querryReturnListofProducts(new AsyncCallback

To download the source code please visit this link http://groups.google.com/group/gtug-ph-davao/browse_thread/thread/ff7576daa39f1654