can you give me a step by step procedure, i really don't have an idea. this is my code
public void getInfo()
{
try {
PreparedStatement pre = null;
for (int ctr2 = 0; ctr2 < Search.jTable1.getColumnCount(); ctr2++) {
for (int ctr1 = 0; ctr1 < Search.jTable1.getRowCount(); ctr1++) {
Search.jTable1.setValueAt("", ctr1, ctr2);
}
}
Connection conn = dbConnection();
//kung anu ung sinelect sa combobox galing sa search.java
if (Search.jComboBox1.getSelectedItem().toString().equals("ALL")){
pre = conn.prepareStatement("select * from Info");
}
if (Search.jComboBox1.getSelectedItem().toString().equals("Last Name")){
pre = conn.prepareStatement("select * from Info where lastname like'%" + se + "%'");}
else if (Search.jComboBox1.getSelectedItem().toString().equals("First Name")){
pre = conn.prepareStatement("select * from Info where firstname like'%" + se + "%'");
}
else if (Search.jComboBox1.getSelectedItem().toString().equals("Middle Initial")){
pre = conn.prepareStatement("select * from Info where middleI like '%" + se + "%'");
}
else if (Search.jComboBox1.getSelectedItem().toString().equals("Age")){
pre = conn.prepareStatement("select * from Info where age like'%" + se + "%'");
}
else if (Search.jComboBox1.getSelectedItem().toString().equals("Address")){
pre = conn.prepareStatement("select * from Info where address like '%" + se + "%'");
}
else if (Search.jComboBox1.getSelectedItem().toString().equals("Course")){
pre = conn.prepareStatement("select * from Info where course like'%" + se + "%'");
}
else if (Search.jComboBox1.getSelectedItem().toString().equals("Contact No")){
pre = conn.prepareStatement("select * from Info where contactno like '%" + se + "%'");
}
else if (Search.jComboBox1.getSelectedItem().toString().equals("Position")){
pre = conn.prepareStatement("select * from Info where position like '%" + se + "%'");
}
else if (Search.jComboBox1.getSelectedItem().toString().equals("Remarks")){
pre = conn.prepareStatement("select * from Info where remarks like'%" + se + "%'");
}
ResultSet result = pre.executeQuery();
//display result sa search.java based sa tinype sa textbox
int rowctr = 0;
while (result.next()) {
Search.jTable1.setValueAt(result.getString("lastname"), rowctr, 0);
Search.jTable1.setValueAt(result.getString("firstname"), rowctr, 1);
Search.jTable1.setValueAt(result.getString("middleI"), rowctr, 2);
Search.jTable1.setValueAt(result.getString("age"), rowctr, 3);
Search.jTable1.setValueAt(result.getString("address"), rowctr, 4);
Search.jTable1.setValueAt(result.getString("course"), rowctr, 5);
Search.jTable1.setValueAt(result.getString("contactno"), rowctr, 6);
Search.jTable1.setValueAt(result.getString("position"), rowctr, 7);
Search.jTable1.setValueAt(result.getString("remarks"), rowctr, 8);
rowctr++;
}
}
catch (Exception e) {
//JOptionPane.showMessageDialog(se+ "NotFound"), se, se, messageType);
}
}
///////////////////////////////////////////////////////////////////////////
public Vector getInfo()throws Exception{
Vector<Vector<String>> InfoVector = new Vector<Vector<String>>();
String se = jTextField1.getText();
String database = "jdbc
dbc
river={Microsoft Access Driver (*.mdb)}; DBQ=C:/Users/OJT/Documents/db.mdb";
Connection conn = DriverManager.getConnection(database);
PreparedStatement pre = conn.prepareStatement("select * from Info ");
ResultSet rs = pre.executeQuery();
while(rs.next())
{
Vector<String> Info = new Vector<String>();
Info.add(rs.getString(1));
Info.add(rs.getString(2));
Info.add(rs.getString(3));
Info.add(rs.getString(4));
Info.add(rs.getString(5));
Info.add(rs.getString(6));
Info.add(rs.getString(7));
Info.add(rs.getString(8));
Info.add(rs.getString(9));
InfoVector.add(Info);
}
if(conn!=null)
conn.close();
return InfoVector;
}
