如何把图片或word文档存入mysql 把字段类型设成blob。在这里再搜下图片存入数据库就有了。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 给你一个access或sql server的参考一下<% dim rs dim formsize,formdata,bncrlf,divider,datastart,dataend,mydata formsize=request.totalbytes '取得客户端发过来的大小 formdata=request.binaryread(formsize)'把客户发过来的数据转成二进制作 bncrlf=chrB(13) & chrB(10) divider=leftB(formdata,clng(instrb(formdata,bncrlf))-1) datastart=instrb(formdata,bncrlf & bncrlf)+4 dataend=instrb(datastart+1,formdata,divider)-datastart mydata=midb(formdata,datastart,dataend)'上面总共是取得图片的二进制数据 %> <!--#include file="conn.asp"--> <% sql="select * from pic order by id desc" Set rs = Server.CreateObject("ADODB.Recordset") rs.Open sql,conn,3,2 rs.addnew rs("big").appendchunk mydata '增加到数据库中 rs.update set rs=nothing set conn=nothing %> 连接mysql的:set conn=server.createobject("adodb.connection")strconnection="dsn=mysql;driver={myodbd driver};server=localhost;uid=dr;pwf=;database=test"conn.open strconnection-----------需要先安装mysqlx 如何访问mysql,你实践一下吧,我也是刚在网上找到的:):< %con = Server.CreateObject("MySQL.Connection");con.Connect("localhost", "root", "", "MyDatabase", 3306, 0);sql = "select FirstName, LastName from Customers";if (!con.Query(sql))Response.Write("ERROR: ".concat(con.ErrMsg()));else{%> < table> < tr> < td class="header"> First name< /td> < td class="header"> Last name< /td> < /tr> < %rs = Server.Create("MySQL.RecordSet");rs.Connection = con;while (rs.Next()){%> < tr> < td class="row"> < %= rs["FirstName"] %> < /td> < td class="row"> < %= rs["LastName"] %> < /td> < /tr> < %};%> < /table> < %};%> ... import java.io.*;import java.sql.*;import java.util.*; import java.text.*; public class Test{ public static void main(String args[]){ String driver = "com.mysql.jdbc.Driver"; String url = "jdbc:mysql://localhost:3306/Test?useUnicode=true&characterEncoding=gb2312"; String user = "root"; String password = ""; try { Class.forName(driver); //加载数据库驱动 Connection conn = DriverManager.getConnection(url, user, password); //连接数据库 FileInputStream str=new FileInputStream("F://bf//MAP//212-01.jpg"); PreparedStatement pstmt=conn.prepareStatement("insert into image(id,content,image) values(2,?,?)"); pstmt.setString(1,"kj"); pstmt.setBinaryStream(2,str,str.available()); pstmt.execute(); System.out.println("Success,You Have Insert an Image Successfully"); pstmt.close(); conn.close(); } catch(ClassNotFoundException e) { System.out.println("找不到驱动程序"); e.printStackTrace(); } catch(SQLException e) { e.printStackTrace(); } catch(FileNotFoundException e){ e.printStackTrace(); } catch(IOException e){ e.printStackTrace(); } } } 呵呵,居然没有一个用C-API的,,,,, mysql binlog mysql语句正常,却在linux下读不出数据 有关 字符串 分割 成字段 请大侠 解决一下 数据库有几个啊 求MYSQL触发器 mysql 修改查询数据的问题 如何用sql语句更新数据表中某字段的数据类型? MySQL v5.0.13的一个Bug吗? MYSQL 如何监控SQL语句执行时消耗IO情况 求助:谁有用PHP+MySQL写的论坛的原码? 请问使用mySql管理,除了MySQL-Front外,还有别的C/S的客户端软件吗? mysql 备份导入问题
<%
dim rs
dim formsize,formdata,bncrlf,divider,datastart,dataend,mydata
formsize=request.totalbytes '取得客户端发过来的大小
formdata=request.binaryread(formsize)'把客户发过来的数据转成二进制作
bncrlf=chrB(13) & chrB(10)
divider=leftB(formdata,clng(instrb(formdata,bncrlf))-1)
datastart=instrb(formdata,bncrlf & bncrlf)+4
dataend=instrb(datastart+1,formdata,divider)-datastart
mydata=midb(formdata,datastart,dataend)'上面总共是取得图片的二进制数据
%>
<!--#include file="conn.asp"-->
<%
sql="select * from pic order by id desc"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sql,conn,3,2
rs.addnew
rs("big").appendchunk mydata '增加到数据库中
rs.update
set rs=nothing
set conn=nothing
%>
set conn=server.createobject("adodb.connection")
strconnection="dsn=mysql;driver={myodbd driver};server=localhost;uid=dr;pwf=;database=test"
conn.open strconnection-----------
需要先安装mysqlx
< %
con = Server.CreateObject("MySQL.Connection");
con.Connect("localhost", "root", "", "MyDatabase", 3306, 0);
sql = "select FirstName, LastName from Customers";
if (!con.Query(sql))
Response.Write("ERROR: ".concat(con.ErrMsg()));
else
{
%>
< table>
< tr>
< td class="header">
First name
< /td>
< td class="header">
Last name
< /td>
< /tr>
< %
rs = Server.Create("MySQL.RecordSet");
rs.Connection = con;
while (rs.Next())
{
%>
< tr>
< td class="row">
< %= rs["FirstName"] %>
< /td>
< td class="row">
< %= rs["LastName"] %>
< /td>
< /tr>
< %
};
%>
< /table>
< %
};
%>
...
import java.sql.*;
import java.util.*;
import java.text.*; public class Test{
public static void main(String args[]){
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/Test?useUnicode=true&characterEncoding=gb2312";
String user = "root";
String password = "";
try {
Class.forName(driver);
//加载数据库驱动
Connection conn = DriverManager.getConnection(url, user, password);
//连接数据库
FileInputStream str=new FileInputStream("F://bf//MAP//212-01.jpg");
PreparedStatement pstmt=conn.prepareStatement("insert into image(id,content,image) values(2,?,?)");
pstmt.setString(1,"kj");
pstmt.setBinaryStream(2,str,str.available());
pstmt.execute();
System.out.println("Success,You Have Insert an Image Successfully");
pstmt.close();
conn.close();
}
catch(ClassNotFoundException e) {
System.out.println("找不到驱动程序");
e.printStackTrace();
}
catch(SQLException e) {
e.printStackTrace();
}
catch(FileNotFoundException e){
e.printStackTrace();
}
catch(IOException e){
e.printStackTrace();
}
}
}