to display table data from jdbc

[Adeelnawaz]

here is code

import java.io.*;
import javax.swing.*;
package student;
import java.sql.*;

public class Main {
private static Object driverManager;

/**
* @param args the command line arguments
*/
public static void main(String[] args) {
try{
load driverClass.forName("sun.jdbc.odbc.JdbcOdbcDriver" );
String url = "jdbc:odbc:studentDSN";
Connection con = driverManager.getConnection(url);
Statement st = con.createStatement();
String sql = "SELECT * FROM Student";
ResultSet rs = st.executeQuery(sql);
while(rs.next())
{
String name = rs.getString(“name”);String add = rs.getString(“address”);
String pNum = rs.getString(“phoneNum”);
System.out.println(name + “ ” + add + ” ” + pNum);
con.close();
}
catch(Exception sqlEx)
{
System.out.println(sqlEx);
}
}

private static void forName(String string) {
throw new UnsupportedOperationException("Not yet implemented");
}
// TODO code application logic here
}

}


pls tell how i can correct mistake

[DarrylBurke]

Moved from Suggestions & Feedback.

Please go through Guide For New Members and BB Code List - Java Programming Forum and edit your post accordingly.

db

[Tolls]

And when you've sorted out the format (that is, added [code] tags [/code] to your code so it's easier to read), you might want to actually say what mistake you've made.