upload.jsp~6~
来自「JSP版的在线相册系统」· JSP~6~ 代码 · 共 40 行
JSP~6~
40 行
<%@ page contentType="text/html;charset=gb2312"%><%@ page import="java.sql.*" %><%@ page import="java.util.*"%><%@ page import="java.text.*"%><%@ page import="java.io.*"%><html><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><title>上传图片</title></head><body><jsp:useBean id="format" scope="page" class="photo.StrFormat"/> <jsp:useBean id="dbconn" scope="page" class="photo.DBConnection"/><%try{Connection conn=dbconn.getConnection();String title=format.StrFormat(request.getParameter("title"));String filename=format.StrFormat(request.getParameter("image"));//获得所要显示图片的标题、存储路径、内容，并进行中文编码FileInputStream str=new FileInputStream(filename);String user_name=(String)session.getAttribute("user");String sql="insert into pictures(picture_title,picture_name,upload_time,user_name) values(?,?,getdate(),'+user_name+')";PreparedStatement pstmt=conn.prepareStatement(sql);pstmt.setString(1,title);pstmt.setBinaryStream(2,str,str.available());pstmt.execute();//将数据存入数据库out.println("Success,You Have Insert an Image Successfully");pstmt.close();conn.close();response.sendRedirect("up_picture.jsp");}catch(Exception e){ out.println("失败"); e.printStackTrace();}%></body></html>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?