将字符串存入BLOB字段

将String字符串存入BLOB字段

1.获取连接

/**
	 * 获取连接
	 * 
	 * @return
	 */
	public Connection getConn() {
		Connection conn = null;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			conn = DriverManager.getConnection(url);
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return conn;

	}

2.插入信息

/**
	 * 将信息存入BLOB字段
	 * 
	 * @param id
	 * @param taskInfo
	 * @throws SQLException
	 * @throws IOException
	 */
	public void insertBlob(String id, String taskInfo) throws SQLException, IOException {
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		Connection con = null;
		try {
			//获取连接
			con = getConn();
			ByteArrayInputStream stream = null;
			pstmt = con.prepareStatement("update tableName set blobCol=? where id=?");
			stream = new ByteArrayInputStream(taskInfo.getBytes());
			pstmt.setBinaryStream(1, stream, stream.available());
			pstmt.setInt(2, Integer.valueOf(tpId));
			pstmt.executeUpdate();

		} catch (NumberFormatException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			// 关闭相应数据库连接
			closeAll(rs, pstmt, con);
		}
	}

3.关闭连接

/**
	 * 关闭连接
	 * 
	 * @param rs
	 * @param stmt
	 * @param conn
	 */
	public void closeAll(ResultSet rs, Statement stmt, Connection conn) {
		if (rs != null) {
			try {
				rs.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		if (stmt != null) {
			try {
				stmt.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		if (conn != null) {
			try {
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}