[Java กับ Oracle Database] ต้องการดึงข้อมูลมาโชว์ให้เพิ่มหลายเรคคอร์ด ทำไงดีคะ

<%@ page contentType="text/html; charset=TIS-620"%>
<%@ page import="java.sql.*"%>
<%

Class.forName("oracle.jdbc.driver.OracleDriver");

Connection conn = DriverManager.getConnection("jdbc:odbc:ppis","ppis","ppis");

Statement stmt = conn.createStatement();

String sql = "select * from per_type ";
ResultSet result = stmt.executeQuery(sql);
int cols=1;
int index=1;

out.println("<table width='100%' >");
while(result.next()){
	int productID = result.getInt("PT_CODE");
	string productName = result.getInt("PT_NAME");
	
	if(index>cols){
		out.println("<tr ><td colspan="+cols+">&nbsp;</td></tr>");
		index=1;
	}
	out.println("<td valign='bottom'> "+productID+"</a></td>");
	out.println("<td valign='bottom'> "productName"</a></td>");
	index++;
}

out.println("<table>");
result.close();
stmt.close();
conn.close();
%>