mysql数据库插入图片_向MySql数据库插入与读取图片文件

1、插入图片

import java.io.FileInputStream;

import java.io.InputStream;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.SQLException;

public class TestAdd {

/**java

测试向mysql添加大字段

*/

public void testAdd() {mysql

// 1.create sql ;

String sql = "insert into userinfo ( username , password , image) values (?,?,?)";android

// 2.get connection

Connection conn = null;sql

PreparedStatement psmt = null;数据库

InputStream is = null; 测试

try {code

conn = JdbcHelper.getConnection(); 图片

// 3.prepare sql

psmt = conn.prepareStatement(sql);资源

// 4.set paramsrem

psmt.setString(1, "javaee");

psmt.setString(2, "123456");

// (1)get the stream

is = new FileInputStream(