كيفية عرض ناتج استعلام في Jtable

هذي طريقة اخذتها من كتاب اسمه:

JDBC: Guide Practical for Java Programmers

public void presentResultSet(ResultSet rs)
throws SQLException {
Vector dataVector = new Vector();
if (!rs.next())
JOptionPane.showMessageDialog(null,"No records for customer");
else {
do {
Vector rowVector = new Vector();
rowVector.addElement(rs.getString("Title"));
rowVector.addElement(rs.getString("Type"));
dataVector.addElement(rowVector);
} while (rs.next());
}
Vector headVector = new Vector(2);
headVector.add_Element ("Title") ;
headVector.addElement ("Type") ;
dataTable = new JTable(dataVector, headVector); // dataTable the table to display the data 
dataTableScrollPane.setViewportView(dataTable) ;
}

salemmya كتب:

هذي طريقة اخذتها من كتاب اسمه:

JDBC: Guide Practical for Java Programmers

public void presentResultSet(ResultSet rs)
throws SQLException {
Vector dataVector = new Vector();
if (!rs.next())
JOptionPane.showMessageDialog(null,"No records for customer");
else {
do {
Vector rowVector = new Vector();
rowVector.addElement(rs.getString("Title"));
rowVector.addElement(rs.getString("Type"));
dataVector.addElement(rowVector);
} while (rs.next());
}
Vector headVector = new Vector(2);
headVector.add_Element ("Title") ;
headVector.addElement ("Type") ;
dataTable = new JTable(dataVector, headVector); // dataTable the table to display the data 
dataTableScrollPane.setViewportView(dataTable) ;
}

تمام بس ResultSet rs من وين بدها تيجي بعينك الله حط الكود كامل مع جملة الاستعلام

String driverName = "com.mysql.jdbc.Driver"; // the driver
String serverName = "localhost";			 // server name
String portNumber = "3306";					 //  port
String sid = "DB_name";                          // database name
String url = "jdbc:mysql://" + serverName + ":" + portNumber + "/" + sid; // to define the URL
Connection con= DriverManager.getConnection(URL,username,password);	// to establish the connection
ResultSet r;
Statement ss = con.createStatement();
try{
 r=ss.executeQuery("select * from xxx");  //the select result will be saved in r
}catch(SQLException e){}
presentResultSet(r);  // send the ResultSet to the presentResultSet method

salemmya كتب:

String driverName = "com.mysql.jdbc.Driver"; // the driver
String serverName = "localhost";			 // server name
String portNumber = "3306";					 //  port
String sid = "DB_name";                          // database name
String url = "jdbc:mysql://" + serverName + ":" + portNumber + "/" + sid; // to define the URL
Connection con= DriverManager.getConnection(URL,username,password);	// to establish the connection
ResultSet r;
Statement ss = con.createStatement();
try{
 r=ss.executeQuery("select * from xxx");  //the select result will be saved in r
}catch(SQLException e){}
presentResultSet(r);  // send the ResultSet to the presentResultSet method

يسلم ايديك