Java Programmers

[Darkbyte]

---

Any Java Programmers out there?

Need help in making an enrollment system using Java GUI and SQL as Database.

I need tips though I know how to go with the programming.

[ferma2]

What kind of tips are you particularly after?!?

[stealthghost]

I'm using Netbeans. Pwede sad ni gamitun sa Eclipse IDE. or even through command prompt pag compile..

Main.java

Spoiler! 

package mysqlsample;

import mysqlsample.Connect.connectMySQL;

public class Main {

public static void main(String[] args) {
try{
connectMySQL.connect();
connectMySQL.getData();
}catch(Exception e){
e.printStackTrace();
}
}
}

Constants/Constants.java

Spoiler! 

package mysqlsample.Constants;

import java.sql.Connection;
import java.sql.Statement;

public class Constants{

public static String dbdriver = "com.mysql.jdbc.Driver";
public static Connection connection;
public static Statement statement;
public static String schema = "schema";
public static String dbUsername = "netlite";
public static String dbPassword = "asdf1234";
public static String dbDomain = "192.168.1.106";
public static String dbPort="3306";
}

Connect/connectMySQL.java

Spoiler! 

package mysqlsample.Connect;

import java.sql.DriverManager;
import java.sql.ResultSet;
import mysqlsample.Constants.Constants;

public class connectMySQL{

public static void connect() throws Exception{
Class.forName(Constants.dbdriver);
Constants.connection = DriverManager.getConnection("jdbc:mysql://"+Constants.dbDomain+":"+Constants.dbPort+"/"+Constants.schema,
Constants.dbUsername, Constants.dbPassword);
Constants.connection.clearWarnings();
Constants.statement = Constants.connection.createStatement();
}

public static void getData() throws Exception{
ResultSet rs = Constants.statement.executeQuery("SELECT * FROM MyTable");
System.out.println("INTEGER - STRING");
while(rs.next()){
System.out.println(rs.getInt("id")+" - "+rs.getString("columnName"));
}
}
}

That's my template and method in connecting through SQL.
You need to download a JDBC Connector. I forgot where to nako nakit.an..

Now for GUI, research jud mo ana.. Daghan tutorial sa internet..

try Javaranch or Roseindia or Even Java site..

[iamk]

i have a simple program that will generate java codes for windows applications. it's called java GUI builder. its the easiest IDE for beginners. its free. if you want a copy just pm me.