JavaBeans¤Î¥µ¥ó¥×¥ë¤Ç¤¹¡£HTMLTable¤Î¥µ¥ó¥×¥ë¤òJavaBeans¤Ë¤·¤Æ¤ß¤Þ¤·¤¿¡£
jt400.jar¤Èjt400Servlet.jar¤ò¥¯¥é¥¹¥Ñ¥¹¤ËÄ̤·¤Æ¤¯¤À¤µ¤¤¡£
jt400.jar¤Èjt400Servlet.jar¤ò¥¯¥é¥¹¥Ñ¥¹¤ËÄ̤·¤Æ¤¯¤À¤µ¤¤¡£
package primula.jp; import java.sql.Connection; import java.sql.ResultSet; import java.sql.Statement; import com.ibm.as400.access.AS400; import com.ibm.as400.access.AS400JDBCDataSource; import com.ibm.as400.util.html.HTMLTable; import com.ibm.as400.util.servlet.HTMLTableConverter; import com.ibm.as400.util.servlet.SQLResultSetRowData; public class SampleBean { private String htmlStr; public SampleBean() { AS400 as400 = new AS400("SHUFFLE","PRIMULA","NERINE"); AS400JDBCDataSource ds = new AS400JDBCDataSource(as400); try { // £Ä£Â¤Ë¥³¥Í¥¯¥È Connection con = ds.getConnection(); Statement st = con.createStatement(); st.execute("select EMPNO,FIRSTNME,LASTNAME from SAMPLEDB.EMPLOYEE"); ResultSet rs = st.getResultSet(); // rowData¥ª¥Ö¥¸¥§¥¯¥È¤Ë·ë²Ì¤ò³Îǧ SQLResultSetRowData rowData = new SQLResultSetRowData(rs); // Table¤Î¥Ø¥Ã¥À HTMLTable table = new HTMLTable(); String[] headers = {"No","À«Ì¾","̾Á°"}; table.setHeader(headers); table.setBorderWidth(1); table.setCellSpacing(1); table.setCellPadding(5); // HTML¥³¥ó¥Ð¡¼¥¿ HTMLTableConverter conv = new HTMLTableConverter(); conv.setTable(table); HTMLTable[] html = conv.convertToTables(rowData); htmlStr = html[0].toString(); } catch (Exception e) { e.printStackTrace(); } } public String getHtmlStr() { return htmlStr; } }
¤³¤Î¥Ú¡¼¥¸¤Ø¤Î¥³¥á¥ó¥È
qa92Kj Thanks a lot for the article post.Really thank you! Will read on...