Access to JDBC class from another class and run it with main class???
Kære venner, jeg vil gerne dele min nedstående class i 3. MainClass, JDBCClass og SlcClass(henter data from database). Er det muligt at gør det sådan og hvordan gør man det?på forhånd tak. :)
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class ShowRecords {
public static void main(String args[]) {
String url = "jdbc:mysql://localhost:3306/";
String db = "mads";
Connection con = null;
try {
String driver = "com.mysql.jdbc.Driver";
Class.forName(driver).newInstance();
} catch (Exception e) {
System.out.println("Failed to load mSQL driver.");
return;
}
try {
con = DriverManager.getConnection(url+db, "******", "******");
Statement select = con.createStatement();
ResultSet result = select
.executeQuery("SELECT Employee_ID, E_navn FROM 10it0");
System.out.println("Got results:");
while (result.next()) { // process results one row at a time
int key = result.getInt(1);
String val = result.getString(2);
System.out.println("| " + "Eployee_ID = " + key +" " +"|" + " E_navn = " + val+ "|");
//System.out.println("E_navn = " + val);
}
} catch (Exception e) {
e.printStackTrace();
} finally {
if (con != null) {
try {
con.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
}
}
