【JSP开源代码栏目提醒】:网学会员为需要JSP开源代码的朋友们搜集整理了update_bimage.jsp相关资料,希望对各位网友有所帮助!
<meta name="generator" content="Namo WebEditor(Trial)">
<% %>
<%@ page contentType="text/html; charset=big5" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="../../Connections/OnlineBook.jsp" %>
<%request.setCharacterEncoding("big5");%>
<%
Driver Driverset_image = (Driver)Class.forName(MM_OnlineBook_DRIVER).newInstance();
Connection Connset_image = DriverManager.getConnection(MM_OnlineBook_STRING,MM_OnlineBook_USERNAME,MM_OnlineBook_PASSWORD);
PreparedStatement Statementset_image = Connset_image.prepareStatement("SELECT * FROM online_book.set_image");
ResultSet set_image = Statementset_image.executeQuery();
boolean set_image_isEmpty = !set_image.next();
boolean set_image_hasData = !set_image_isEmpty;
Object set_image_data;
int set_image_numRows = 0;
%>
<%
int book_size =0;
book_size = set_image.getInt("book_size");
%>
<%--STEP 1>
<%@ page import="com.jspsmart.upload.*" %>
<%--STEP 2Beancom.jspsmart.upload.SmartUpload﹚myUpload --%>
<jsp:useBean id="myUpload" scope="page" class="com.jspsmart.upload.SmartUpload" />
<%
String savePath = "/book/book_image/";
//int maxPostSize = book_size *1204;
%>
<%
myUpload.initialize(pageContext);
//myUpload.setTotalMaxFileSize(maxPostSize);
myUpload.upload();
String SAVE_PATH ="";
String isbn ="";
String file_name = "";
String rs_subfile ="";
String state1 ="y";
String state2 ="y";
String up_state ="xxx";
isbn = myUpload.getRequest().getParameter("isbn");
up_state = myUpload.getRequest().getParameter("up_state");
int file_size = myUpload.getSize();
if(file_size > book_size * 1024)
{
state1 ="n";
response.sendRedirect("image_error.jsp?error=file_size&isbn="+isbn+"&up_state="+up_state);}
else{
com.jspsmart.upload.File myFile = null;
myFile = myUpload.getFiles().getFile(0);
if(!myFile.isMissing())
{
rs_subfile = myFile.getFileExt();
rs_subfile = rs_subfile.toLowerCase();
if(!rs_subfile.equals("gif") && !rs_subfile.equals("jpg") && !rs_subfile.equals("png")){
state2 ="n";
response.sendRedirect("image_error.jsp?error=subfile&isbn="+isbn+"&up_state="+up_state);}
else{
file_name = isbn + "." + rs_subfile;
SAVE_PATH = savePath + file_name;
try{
myFile.saveAs(SAVE_PATH);
}
catch (Exception ex){
out.println(" [");
out.println(ex.toString());
out.println("] <BR>");
}
}
%>
<%
if(state1.equals("y") && state2.equals("y")){
Driver DriverPrepared1 = (Driver)Class.forName(MM_OnlineBook_DRIVER).newInstance();
Connection ConnPrepared1 = DriverManager.getConnection(MM_OnlineBook_STRING,MM_OnlineBook_USERNAME,MM_OnlineBook_PASSWORD);
PreparedStatement Prepared1 = ConnPrepared1.prepareStatement("UPDATE online_book.book_data SET book_image = '"+file_name+"' WHERE isbn = '"+isbn+"'");
Prepared1.executeUpdate();
if(up_state.equals("up2")){response.sendRedirect("close_window.jsp?isbn="+isbn);}
else{response.sendRedirect("close_winxxx.jsp?isbn="+isbn);}
%>
<%
ConnPrepared1.close();
}
}
}
%>
<%
set_image.close();
Statementset_image.close();
Connset_image.close();
%>
上一篇:
update_back.jsp
下一篇:
不规则零件优化排样的神经网络混合优化算法