把图片和文本文件存储到数据库
点击连接->C3P0连接数据库
请先查看C3P0连接数据库,再查看下面代码
PictureAndTxtToMysql.java
package com.zr.demo;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import org.junit.Test;
import com.zr.utils.C3P0Util;
/**
* 把图片和文本文件存储到数据库
* @author ZR
*
*/
public class PictureAndTxtToMysql {
//获取C3P0连接
Connection connection=C3P0Util.getConnection();
PreparedStatement statement=null;
ResultSet resultSet=null;
/**
* 把图片和文本文件存储到数据库
*/
@Test
public void insertPictureAndTxt() {
//sql语句
String sql="insert into pt values(null,?,?)";
try {
//sql预编译
statement = connection.prepareStatement(sql);
//sql赋值
statement.setBlob(1, new FileInputStream("src/7.jpg"));
statement.setClob(2, new FileReader("src/com/zr/utils/C3P0Util.java"));
//执行sql
int update = statement.executeUpdate();
if (update>0) {
System.out.println("插入成功");
}else {
System.out.println("出入失败");
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (FileNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
//关闭连接,释放资源
C3P0Util.close(connection, statement, resultSet);
}
}
}