如何用sql server image列生成图片？

nameisaj 2003-11-25 01:25:10

help

...全文

109 5 打赏收藏转发到动态举报

写回复

用AI写文章

5 条回复

切换为时间正序

请发表友善的回复…

发表回复

dengyin2000 2003-11-26

打赏
举报

我这里有：
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*"%>
<%@ page import="java.text.*"%>
<%@ page import="java.io.*"%>
<script language="javascript">
function backward()
{
history.back();
}
</script>
<jsp:useBean id="fileBean" scope="page" class="moq.MoqUploadBean"/>
上传类；
<%
fileBean.setObjectPath("D:\\Temp\\");
fileBean.setSize(10000*1024);
fileBean.setSuffix(".gif.jpg.png.jpge.html.htm");
fileBean.setSourceFile(request);
String [] saSourceFile = fileBean.getSourceFile();
String [] saObjectFile = fileBean.getObjectFileName();
String [] saDescription = fileBean.getDescription();
int iCount = fileBean.getCount();
String sObjectPath = fileBean.getObjectPath();
for(int i=0;i<iCount;i++) {
out.println("<br>源始文件:");
out.println(saSourceFile[i]);
out.println("<br>目标文件:");
out.println(sObjectPath+saObjectFile[i]);
out.println("<br>上传说明:");
out.println(saDescription[i]);
out.println("<br>");
}
out.println("<br>说明:" + fileBean.getFieldValue("Comment"));
//说明　先将客户端的图片上传到本地　　然后再奖本地的图片存入数据库

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//加载驱动程序类
Connection conn=DriverManager.getConnection("jdbc:odbc:jsp");
//建立数据库联机，其中jsp为数据库名
Statement stmt=conn.createStatement();
//建立Statement对象
String detail=fileBean.getFieldValue("Comment");
//detail=new String(detail.getBytes("8859_1"),"gb2312");
String filename=sObjectPath+saObjectFile[0];
java.util.Date m_date=new java.util.Date();
String postTime=m_date.toLocaleString();
String postUser=(String)session.getAttribute("uid");
File file = new File(filename);

FileInputStream str=new FileInputStream(file);
out.println(filename);

String sql="insert photo(postUser,postTime,postPhoto,detail) values(?,?,?,?)";
PreparedStatement pstmt=conn.prepareStatement(sql);
pstmt.setString(1,postUser);
pstmt.setString(2,postTime);
pstmt.setBinaryStream(3,str,(int)file.length());
pstmt.setString(4,detail);
pstmt.execute();
%>
<p align="center"><input type="button" name="button2" value="返回" onclick="backward()"></p>

nameisaj 2003-11-26

打赏
举报

请问有上传图片到sql server数据库的实例吗？

nameisaj 2003-11-26

打赏
举报

请问谁有上传组件，是通过request变量始终化的

vyzm 2003-11-25

打赏
举报

<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*"%>
<%@ page import="java.text.*"%>
<%@ page import="java.io.*"%>
<html>
<body>
<%

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

String url="jdbc:odbc:myserver";
Connection conn=DriverManager.getConnection(url,"sa","");
String sql = "select image from mytest";
Statement stmt=null;
ResultSet rs=null;
try{
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
}catch(SQLException e){}
try {
while(rs.next()) {
//res.setContentType("image/jpeg");
ServletOutputStream sout = response.getOutputStream();
InputStream in = rs.getBinaryStream(1);
byte b[] = new byte[0x7a120];
for(int i = in.read(b); i != -1;)
{
sout.write(b);
in.read(b);
}
sout.flush();
sout.close();
}
}
catch(Exception e){System.out.println(e);}
%>
</body>
</html>

nameisaj 2003-11-25