📄 sample4.jsp
字号:
<%@ page language="java" import="java.sql.*,com.jspsmart.upload.*"%><jsp:useBean id="mySmartUpload" scope="page" class="com.jspsmart.upload.SmartUpload" /><HTML><BODY BGCOLOR="white"><H1>jspSmartUpload : Sample 4</H1><HR><% // Variables int count=0; // 建立到数据库的连接 Class.forName("com.mysql.jdbc.Driver").newInstance(); Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/jnestore","root","admin"); // 执行查询操作，建立结果集对象rs Statement stmt = con.createStatement(ResultSet.TYPE_FORWARD_ONLY ,ResultSet.CONCUR_UPDATABLE); ResultSet rs = stmt.executeQuery("SELECT * FROM TFILES WHERE ID=1"); // 如果rs不为null if (rs.next()){ mySmartUpload.initialize(pageContext); mySmartUpload.upload(); if (!mySmartUpload.getFiles().getFile(0).isMissing()){ try { rs.updateString("FILENAME",mySmartUpload.getFiles().getFile(0).getFileName()); // 将当前文件存储到数据库中FILE字段 mySmartUpload.getFiles().getFile(0).fileToField(rs,"FILE"); //更新数据库 rs.updateRow(); count++; } catch(Exception e) { out.println("An error occurs : " + e.toString()); } } } // Display the number of files uploaded out.println(count + " file(s) uploaded in the database."); rs.close(); stmt.close(); con.close();%></BODY></HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -