上传文件到数据库

最新推荐文章于 2021-08-06 01:40:58 发布

yihuei123

最新推荐文章于 2021-08-06 01:40:58 发布

阅读量1.1k

点赞数

文章标签： string import sqlserver microsoft file insert

本文链接：https://blog.csdn.net/yihuei123/article/details/971037

版权

提交页面
<HTML>
<HEAD>
<TITLE>Image   File   </TITLE>
<meta   http-equiv="Content-Type"   content="text/html;   charset=gb2312">
</HEAD>
<BODY>
<FORM   ACTION="testimage.jsp"   METHOD=POST>
<input type="file" name="file" >
<INPUT name="提交"   TYPE="submit" id="提交">
</FORM>

</BODY>
</HTML>

上传处理页面
<%@   page   contentType="text/html;charset=gb2312"%>
<%@   page   import="java.sql.*"   %>
<%@   page   import="java.util.*"%>
<%@   page   import="java.text.*"%>
<%@   page   import="java.io.*"%>
<%@ page import="com.microsoft.jdbc.sqlserver.SQLServerDriver"%>
<%request.setCharacterEncoding("GB2312");%>
<html>
<body>
<%
String classforname="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url="jdbc:microsoft:sqlserver://192.168.0.31:1433;DatabaseName=ylxt";
String user="sa";
String password="111111";
Class.forName(classforname);
Connection con=java.sql.DriverManager.getConnection(url,user,password);
String   filename=request.getParameter("file");
FileInputStream   str=new   FileInputStream(filename);
String   sql="insert   into   wenxian(contents)   values(?)";
PreparedStatement   pstmt=con.prepareStatement(sql);
pstmt.setBinaryStream(1,str,str.available());
pstmt.execute();
out.println("Success,You   Have   Insert   the   file   Successfully");
%>
</body>
</html>

下载页面
<%@   page   contentType="text/html;charset=gb2312"%>
<%@   page   import="java.sql.*"   %>
<%@   page   import="java.util.*"%>
<%@   page   import="java.text.*"%>
<%@   page   import="java.io.*"%>
<%@ page import="com.microsoft.jdbc.sqlserver.SQLServerDriver"%>
<%request.setCharacterEncoding("GB2312");%>
<%
String id=request.getParameter("id");
String classforname="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url="jdbc:microsoft:sqlserver://192.168.0.31:1433;DatabaseName=ylxt";
String user="sa";
String password="111111";
Class.forName(classforname);
Connection con=java.sql.DriverManager.getConnection(url,user,password);
String   sql   =   "select   contents   from   wenxian   where   id=23";//+id;
Statement   stmt=null;
ResultSet   rs=null;
try{
stmt=con.createStatement();
rs=stmt.executeQuery(sql);
}catch(SQLException   e){}
try   {
while(rs.next())   {
//response.setContentType("multipart/form-data");
response.setContentType("APPLICATION/OCTET-STREAM");
// response.setContentType("image/jpeg");
String filename="a.gif";
response.setHeader("Content-Disposition","attachment; filename= /"" + filename +"/"");
//ServletOutputStream sout =response.getOutputStream();
InputStream   in = rs.getBinaryStream(1);
        int i;
        while   ((i=in.read())   !=   -1)   {
        out.write(i);
        }
        out.close();
}
}
catch(Exception   e){System.out.println(e);}
%>
要编码转换，看文章编码问题

yihuei123

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
上传文件到数据库

提交页面 Image File 上传处理页面 String classforname="com.microsoft.jdbc.sqlserver.SQLServerDriver"; String url="jdbc:microsoft:sqlserver://192.168.0.31:1433
复制链接

扫一扫