import java.awt.List;
import java.sql.*;
import java.net.*;
import java.util.ArrayList;
import java.util.Vector;
import javax.swing.JFrame;
import javax.swing.JTable;
public class Jtabinsertion {
public static void main(String[] args){
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn=DriverManager.getConnection("jdbc

racle:thin:@172.16.40.4:1521:hpsipos","commorm","commorm");
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from pty_im where rownum<3");
JTable jtb=null;
Vector columnnames=new Vector();
columnnames.addElement("pty_cd");
columnnames.addElement("csnr_flg");
Vector rownames=new Vector();
Vector rowdata=new Vector();
//ArrayList rowdata=new ArrayList();
int i=0;
int pre=0,post=0;
while(rs.next()){
if(i<3)
{
rownames.addElement(rs.getString("pty_cd"));
rownames.addElement(rs.getString("csnr_flg"));
post=rownames.lastIndexOf(rownames.lastElement())+1;
System.out.println("pre:"+pre);
System.out.println("post:"+post);
rowdata.add(rownames.subList(pre,post));
//System.out.println(rownames.toString());
pre=post;
i++;
}
}
//System.out.println(rowdata.toString());
jtb=new JTable(rowdata,columnnames);
JFrame jf=new JFrame();
jf.add(jtb);
jf.pack();
jf.setVisible(true);
/*System.out.println(rs.getString("pty_cd"));
System.out.println(rs.getString("csnr_flg"));
System.out.println(rownames.elementAt(1));*/
// System.out.println(rowdata.toString());
}
catch(Exception e){
System.out.println(e);
}
}
}