📄 testimage1.jsp~16~
字号:
<%@page contentType="text/html; charset=GBK"%> <%@ page import="java.sql.*" %> <%@ page import="java.util.*"%> <%@ page import="java.text.*"%> <%@ page import="java.io.*"%> <%request.setCharacterEncoding("gb2312");%> <html> <body> <% try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //定义JDBC URL }catch (Exception e) { out.println(e.getMessage()); } try{ String sql="insert into test2(id,content) values(1,?,?)"; System.out.print("SQL:" + sql); String url = "jdbc:odbc:s"; //其中mysql为你数据库的名字,user为你连接数据库的用户,password为你连接数据库用户的密码,可自己改 Connection con = DriverManager.getConnection(url); String content=request.getParameter("content"); String filename=request.getParameter("image"); FileInputStream str=new FileInputStream(filename); PreparedStatement pstmt=con.prepareStatement(sql); System.out.print("SQL:" + sql); pstmt.setString(1,content); pstmt.setString(2,filename);pstmt.execute(); } catch (Exception e) {} out.print("恭喜 插入图片成功!"); %> <a href="testimageout.jsp">显示图片</a> </body> </html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -