Posted on 2005-07-25 11:57
風太少 閱讀(253)
評論(0) 編輯 收藏
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>