📄 picup.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" language="java"
import="java.util.*,com.jspsmart.upload.*,java.sql.*"%>
<jsp:useBean id="myUpload" scope="page" class="com.jspsmart.upload.SmartUpload" />
<HTML>
<BODY BGCOLOR="white">
<%
myUpload.initialize(pageContext);
myUpload.upload();
java.text.SimpleDateFormat formatter=new java.text.SimpleDateFormat("yyyy-MM-dd HH-mm-ss");
java.util.Date Now=new java.util.Date(new java.util.Date().getTime());
String zjtime=formatter.format(Now);
out.print(zjtime);
String url = "jdbc:mysql://localhost:3306/mydb";
Connection con;
Statement stmt;
Class.forName("org.gjt.mm.mysql.Driver");
String Insert= "insert into shoppic (zjtime) values('"+zjtime+"')";
con = DriverManager.getConnection(url, "root", "test");
stmt = con.createStatement();
stmt.executeUpdate(Insert);
String id = "";
String query = "select max(id) from shoppic";
ResultSet rs = stmt.executeQuery(query);
while(rs.next()){
id = rs.getString(1);
}
// Files
String demonstration = "";
com.jspsmart.upload.File s1 = myUpload.getFiles().getFile(0);
if (!s1.isMissing()){
demonstration = id + "." +s1.getFileExt();
s1.saveAs("/shoppic/" + demonstration,myUpload.SAVE_VIRTUAL);
}
for (int i=0;i<myUpload.getFiles().getCount();i++){
out.print(myUpload.getFiles().getFile(i).getFieldName());
if (!myUpload.getFiles().getFile(i).isMissing())
out.print(" = " + myUpload.getFiles().getFile(i).getFileName() + " (" + myUpload.getFiles().getFile(i).getSize() + ")");
else
out.print(" = vide");
out.println("<BR>");
}
String UpdateString = "update shoppic set pic_url='"+demonstration+"' where id="+id+";";
UpdateString = new String(UpdateString .getBytes("ISO8859_1"),"gb2312");
out.println("<br>"+UpdateString);
stmt = con.createStatement();
stmt.executeUpdate(UpdateString);
stmt.close();
con.close();%>
<script language="JavaScript">
alert("成功");
</script>
<%
session.setAttribute("pic",demonstration);
response.sendRedirect("soldshop.jsp");%>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -