mysql 字段值显示(binary/image)是什么意思_为什么在数据库建表时图片字段不能编辑（显示binary）?类型应该是image吗？怎么才能把图片插入表中？...

import java.io.*;

import java.sql.*;

public class PutImg {

public void putimg() {

try {

Class.forName("com.mysql.Driver").newInstance();

String url = "jdbc:mysql://localhost/img?user=root&password=root&useUnicode=true&characterEncoding=gbk";

Connection conn = DriverManager.getConnection(url);

Statement stmt = conn.createStatement();

//stmt.execute("insert into imgt (id) values (5)");

stmt.close();

PreparedStatement pstmt = null;

String sql = "";

File file = new File("c:\\blog.jpg");

InputStream photoStream = new FileInputStream(file);

//sql = " UPDATE imgt SET img = ? ";

sql = "INSERT INTO imgtable (img) VALUES (?)";

pstmt = conn.prepareStatement(sql);

pstmt.setBinaryStream(1, photoStream, (int) file.length());

pstmt.executeUpdate();

pstmt.close();

conn.close();

} catch (Exception e) {

e.printStackTrace();

}

}

public static void main(String args[]){

PutImg pi=new PutImg();

pi.putimg();

}

}

这个是写，UPDATE 那个就是修改了，读取是一样的，取出来，以流的形式向页面显示就可以了