把图片和文本文件存储到数据库

柔光的暖阳◎ 2024-04-19 10:30 62阅读 0赞

## 把图片和文本文件存储到数据库 ##

#### 点击连接->[C3P0连接数据库][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);
    		}
    	}
    
    }

[C3P0]: https://blog.csdn.net/liangruilz/article/details/100920210