📄 testimage1.jsp~10~
字号:
<%@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 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); String sql="insert into test(id,content,image) values(1,?,?)"; PreparedStatement pstmt=con.prepareStatement(sql); System.out.print("SQL:" + sql); pstmt.setString(1,content); pstmt.setBinaryStream(2,str,str.available());pstmt.execute(); } catch (Exception e) {} out.print("Success,You Have Insert an Image Successfully"); %> <a href="testimageout.jsp">显示图片</a> </body> </html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -