package com;
//this class is the one that i used to retrieve the data..
import java.io.*;
import java.sql.*;
import javax.servlet.jsp.*;
import javax.servlet.jsp.tagext.*;
 
public class Parents {
 
public String[] lastname;
public String[] firstname;
public String[] middlename;
public String[] relation;
 
private Connection connection = null;
private Statement statement = null;
private ResultSet rs = null;
Connect con = new Connect();
int count = 0;
 
public Parents(){}
 
public Parents(int idno) {
int i = 0;
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/sis",con.user,con.password);
statement = connection.createStatement();
rs = statement.executeQuery("SELECT * FROM guardians WHERE studidno='" + idno + "'");
 
if (rs.last()) {
count = rs.getRow();
}
 
lastname = new String[count];
firstname = new String[count];
middlename = new String[count];
relation = new String[count];
 
while (rs.next()){
lastname[i] = rs.getString("lastname");
firstname[i] = rs.getString("firstname");
middlename[i] = rs.getString("middlename");
relation[i] = rs.getString("relation");
i++;
}
 
} catch (Exception e) {
e.printStackTrace();
}
}
 
//setters in here..
 
public String[] getLastname(){return lastname;}
 
public String[] getFirstname () {return firstname;}
 
public String[] getMiddlename () {return middlename;}
 
public String[] getRelation () {return relation;}
 
}
 
and this is what i placed in my jsp page..
<%
Parents p = new Parents(info.getIdno());
for (int i = 0; i < p.getFirstname().length; i++ ) {
%>
 
 
<%= p.getLastname() %>
 
Relationship:
 
<%= p.getFirstname() %>