i am student doing this project for my final year,but i managed to design a graphical user interface ,the main problem i am having is to make my GUI interface interact/talk to the database(MySQL).
i would love if any body could advice me what to do.

Thank you so much.

from Jean

Have you writen the code to create a connection to the Database? I guess I don't really understand what you mean by your GUI needing to communicate with the Database. Has there been any code writen to interact with the Database or is that what you are looking for?

Dream.In.Code has a policy by which we prefer to see a good faith effort on your part before providing source code for homework assignments. Please post the code you have written in an effort to resolve the problem, and our members would be happy to provide some guidance. Be sure to include a description of any errors you are encountering as well.

Post your code like this:

Thanks.

[quote name='jpete7683' date='22 May, 2009 - 08:32 PM' post='650730']
Have you writen the code to create a connection to the Database?
i havent written code yet becouse i dont know how to go about it?
how do you connect to database and selection,insert,delete to be enter in textArea
and result from database to be displayed below the typed textarea

[quote name='Gashayija' date='14 Jun, 2009 - 01:24 PM' post='673856']
[quote name='jpete7683' date='22 May, 2009 - 08:32 PM' post='650730']
Have you writen the code to create a connection to the Database?
i havent written code yet becouse i dont know how to go about it?
how do you connect to database and selection,insert,delete to be enter in textArea
and result from database to be displayed below the typed textarea
[/quote]

here is my attechment of what i have done


import java.sql.*;

public class AllTableName{
public static void main(String[] args) {
System.out.println("Listing all table name in Database!");
Connection con = null;
String url = "jdbc:mysql://localhost:3306/";
String db = "mydatabase";
String driver = "com.mysql.jdbc.Driver";
String user = "root";
String pass = "najah2";
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db, user, pass);
try{
DatabaseMetaData dbm = con.getMetaData();
String[] types = {"TABLE"};
ResultSet rs = dbm.getTables(null,null,"%",types);
System.out.println("Table name:");
while (rs.next()){
String table = rs.getString("TABLE_NAME");
System.out.println(table);
con.close();
}
}
catch (SQLException s){
System.out.println("No any table in the database");
}
}
catch (Exception e){
e.printStackTrace();
}
}
}