fileup.jsp test.showKid bean 是一个读取类别的//test.DBconn //连接数据库的
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,java.util.*" errorPage="" %> <jsp:useBean id="show" scope="page" class="test.showKid"/> <jsp:useBean id="test" scope="page" class="test.DBconn"/> <html> <head> <title>MMS图片上传</title> <%@ include file="page.css"%> </head> <body> <center> <table width="500" height="500"> <form action="fileup_in.jsp" method="post" enctype="multipart/form-data" name="form1"> <tr> <th height="30" colspan="3">MMS图片上传</th> </tr> <tr> <td height="20" colspan="3"> 图片路径:<input name="thisfile" type="file" id="thisfile"> </td> </tr> <tr> <td height="20" colspan="3"> 图片类别:<%=show.showKid()%> </td> </tr> <tr> <td height="20" colspan="3"> 图片说明:<input type="text" class="pp" name="name" size="20"> </td> </tr> <tr> <td height="20" colspan="3"> 下载次数:<input type="text" class="pp" name="down" size="20"> </td> </tr> <tr> <td height="20" colspan="3"> 图片排序:<input type="text" class="pp" name="seqno" size="20"> </td> </tr> <tr> <td height="20" colspan="3"> <input type="submit" name="Submit" value="确 定"> </td> </tr> </form> <tr> <td colspan="3" height="30"> </td> </tr> <% int pid = show.getTop(); int i = 0; Object tmpid; Object pixid; Object pic_url; ArrayList al = new ArrayList(); try { String sql = "select pid,pixid,pic_url from picturelib where pid="+pid+""; ResultSet rs = test.executeQuery(sql); while (rs.next()) { tmpid = rs.getString(1); pixid = rs.getString(2); pic_url = rs.getString(3); al.add(0,tmpid); al.add(1,pixid); al.add(2,pic_url); i++; } } catch(Exception e) { System.out.println("sql error"); } //System.out.println(al.size()); %> <form action="fileup2_in.jsp" method="post" enctype="multipart/form-data" name="form1"> <tr> <td width="351" height="60"> <input type="hidden" name="id" value="<%=pid%>"> 30 X 30px: <input type="hidden" name="pixid" value="1"><input name="thisfile" type="file" id="thisfile"> </td> <td width="137"> <%if (al.size()>2){%> <img src="<%="images/"+al.get(2)%>" width="60" height="60"> <%}%> </td> </tr> <tr> <td height="60"> <input type="hidden" name="id" value="<%=pid%>"> 128 X 128px:<input type="hidden" name="pixid" value="2"> <input name="thisfile2" type="file" id="thisfile2"></td> <td width="137"> <%if (al.size()>5){%> <img src="<%="images/"+al.get(5)%>" width="60" height="60"> <%}%> </td> </tr> <tr> <td height="60"> <input type="hidden" name="id" value="<%=pid%>"> 160 X 128px:<input type="hidden" name="pixid" value="3"> <input name="thisfile3" type="file" id="thisfile3"></td> <td width="137"> <%if (al.size()>8){%> <img src="<%="images/"+al.get(8)%>" width="60" height="60"> <%}%> </td> </tr> <tr> <td height="60"> <input type="hidden" name="id" value="<%=pid%>"> 160 X 150px:<input type="hidden" name="pixid" value="4"> <input name="thisfile4" type="file" id="thisfile4"></td> <td width="137"> <%if (al.size()>11){%> <img src="<%="images/"+al.get(11)%>" width="60" height="60"> <%}%> </td> </tr> <tr> <td height="20" colspan="2"> <input type="submit" name="Submit" value="确 定"> </td> </tr> </form> <tr> <td colspan="2"> </td> </tr> </table>
</center> </body> </html>

|