📄 upload.jsp

📁 一个自己完成的网上书店
💻 JSP
字号:
<%@ page language="java" import="java.util.*,java.sql.*,com.jspsmart.upload.*" pageEncoding="gb2312"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>My JSP 'upfile.jsp' starting page</title>
    
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->

  </head>
  <jsp:useBean id="su" scope="page" class="com.jspsmart.upload.SmartUpload"/>
  <body>
    <%
    
    		Class.forName("com.mysql.jdbc.Driver");
			DriverManager.registerDriver(new com.mysql.jdbc.Driver());
			String dburl = "jdbc:mysql://localhost:3306/bookstore?useUnicode=true&characterEncoding=GB2312";
			String user = "root";
			String pass = "ptnest";
			Connection con;
			con = java.sql.DriverManager.getConnection(dburl, user, pass);
			Statement stmt = con.createStatement();
			
			String bookid;
			bookid=(String)session.getAttribute("id");
    		
    		//out.print(bookid);
    		
    		//int bkid=Integer.parseInt(bookid);
		try
		{
			final String UpFileType="jpg|gif";
			String ErrMsg=null;
			boolean Err=true;
			//初始化
			su.initialize(pageContext);
			//上传
			su.upload();
			com.jspsmart.upload.File myFile=su.getFiles().getFile(0);
			if (!myFile.isMissing()) 
			{
				String FileType=myFile.getFileExt();
				FileType=FileType.toLowerCase();   //将扩展名转换成小写
				if (UpFileType.indexOf(FileType)==-1)
				{
					ErrMsg="上传文件失败！目前只允许上传以下格式的文件："+UpFileType;
					out.print ("<script>alert('"+ErrMsg+"');</script>");
					Err=false;
				} 
				FileType="image/"+bookid+"."+FileType;
				if(Err)
				myFile.saveAs(FileType);
				//在数据库添加图片路径
				String sql="update book set image='"+FileType+"' where id='"+bookid+"'";
				try
				{
					int num1=stmt.executeUpdate(sql);
					out.println("<div align='center'><font color='red'>添加成功</font></div>");
			   		out.print("<div align=center><font color=#FF0000><a href=/bookstore/admin/image.jsp>继续上传</a></font></div>");
			   		out.print("<div align=center><font color=#FF0000><a href=/bookstore/admin/index.jsp>点击此处返回</a></font></div>");
		      }
		     catch(SQLException e)
		     {
		     out.println("失败");
		    
		     }
	
}
	

}
catch(Exception e)
{
	e.printStackTrace();
}

%>


  </body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -