1855被浏览406093分享邀请回答/r/SnUiOg-EhlL5rUtZ9yBY (二维码自动识别)7. 一直在寻找一个简单，可以让我专注于把「思考」转换为「文字」的工具。iA Writer很好，但是我需要搜索，我需要格式，我需要快速打开一个Note，我需要随时可以换到另一个Note，我需要同时打开多个Notes... 于是就有了Lenote缺点是目前只支持Mac，markdown支持不完善，没有iCloud，没有专注模式，没有版本控制...Lenote更多介绍在这里：好用的记事软件还有很多，如Writeroom，Imagine，Clean Writer，OmmWriter，Notefile... 不再介绍下去了。-- Peng27131 条评论分享收藏感谢收起14 条评论分享收藏感谢收起查看更多回答Download Hay Day APK 1_36_212 (hay-day.apk) - APK4Fun
Download APK
Hay Day APK 1_36_212 Free Download
& Updated: October 11, 2017
You are about to download the Hay Day 1_36_212 apk file for Android 4.0.3 and up: Grow and customize your farm. Sunshine is never ending, trading is a way of life, animal are all over the place ... Please be aware that APK4Fun has verified the apk signature of Hay Day v1_36_212 to ensure the file's integrity and security. Before you download the
file, you could read , check the
or get it on .
Hay Day version 1_36_212 release notes:
Introducing: Derby & Event improvements!oKeep an eye out for special Bingo-themed derbies. The first one will hit very soon!oWatch your event board for some exciting new and improved eventsCommunity Requested Features:oNew peonies and sunflower cropsoNew Flower shop production machineoNew products (8)oTown and Shop UI improvementsoNew achievementsoNew XP boosteroNew leader and co-leader messaging options for neighborhoodsComing soon:oStay tuned for our Halloween celebrations"
Download Hay Day apk 1_36_212 for Android 4.0.3 and up:
Choose a server location to download the apk file:
Please verify the apk file integrity after you download:
& File: com.supercell.hayday-1_36_.apk
bytes (94.26 MB)
& MD5: EC91DBDCE1F
& SHA1: 39ED2D66D4D780A504B6C227663B
Advertisements
Hay Day is a free and fun
game by : Best. Farm. Ever. Welcome to Hay Day, the most popular farming game on mobiles and tablets, number one in 122 ...
After you get the Hay Day 1_36_212 apk file (com.supercell.hayday-1_36_.apk), move it to your Android phone's SD card and then your file manager to browse, install
& enjoy it.
Google Play and the Google Play logo are trademarks of Google Inc. Hay Day (com.supercell.hayday) is the trademark of the developer Supercell. All apk files on APK4Fun are only for home or personal use.
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&
Other apk options for Hay Day ()
Need old versions of com.supercell.hayday? Download the old apk files now:
(Updated: Aug 14, 2017)
(Updated: Jun 14, 2017)
(Updated: March 28, 2017)
(Updated: March 27, 2017)
(Updated: December 19, 2016)
(Updated: December 12, 2016)
(Updated: November 4, 2016)
(Updated: October 31, 2016)
(Updated: October 12, 2016)
(Updated: June 29, 2016)
More Casual Games to Consider
Updated: October 25, 2017
Updated: October 27, 2017
Updated: October 25, 2017
Updated: October 23, 2017
Updated: October 30, 2017
Updated: October 27, 2017
Updated: October 30, 2017
Updated: October 26, 2017
Updated: October 30, 2017
Updated: October 25, 2017
Updated: October 31, 2017
Updated: September 29, 2017
Updated: November 4, 2017
Updated: May 12, 2017
Updated: November 5, 2017
Updated: November 6, 2017
Updated: November 6, 2017
Updated: October 27, 2017
Updated: November 5, 2017
Updated: November 2, 2017大数据-将MP3保存到数据库并读取出来《黑马程序员_超全面的JavaWeb视频教程vedio》day17
时间： 12:20:51
&&&& 阅读：168
&&&& 评论：
&&&& 收藏：0
标签：&&&&&&&&&&&&&&&&&&&&&&&&&&&黑马程序员_超全面的JavaWeb视频教程vedio\黑马程序员_超全面的JavaWeb教程-源码笔记\JavaWeb视频教程_day17-资料源码\day17_code\day17_1\
目标：把mp3保存到数据库中！
在my.ini中添加如下配置！
max_allowed_packet=
1　什么是大数据
所谓大数据，就是大的字节数据，或大的字符数据。标准SQL中提供了如下类型来保存大数据类型：
28--1B（256B）
216-1B（64K）
mediumblob
224-1B（16M）
232-1B（4G）
28--1B（256B）
216-1B（64K）
mediumclob
224-1B（16M）
232-1B（4G）
但是，在mysql中没有提供tinyclob、clob、mediumclob、longclob四种类型，而是使用如下四种类型来处理文本大数据：
28--1B（256B）
216-1B（64K）
mediumtext
224-1B（16M）
232-1B（4G）
首先我们需要创建一张表，表中要有一个mediumblob（16M）类型的字段。
CREATE TABLE tab_bin(
id INT PRIMARY KEY AUTO_INCREMENT,
filenameVARCHAR(100),
data MEDIUMBLOB
　向数据库插入二进制数据需要使用PreparedStatement为原setBinaryStream(int, InputSteam)方法来完成。
con = JdbcUtils.getConnection();
String sql = "insert into tab_bin(filename,data) values(?, ?)";
pstmt = con.prepareStatement(sql);
pstmt.setString(1, "a.jpg");
InputStream in = new&FileInputStream("f:\\a.jpg");
pstmt.setBinaryStream(2, in);
pstmt.executeUpdate();
&读取二进制数据，需要在查询后使用ResultSet类的getBinaryStream()方法来获取输入流对象。也就是说，PreparedStatement有setXXX()，那么ResultSet就有getXXX()。
con = JdbcUtils.getConnection();
String sql = "select filename,data from tab_bin where id=?";
pstmt = con.prepareStatement(sql);
pstmt.setInt(1, 1);
rs = pstmt.executeQuery();
rs.next();
String filename = rs.getString("filename");
OutputStream out = new&FileOutputStream("F:\\"&+ filename);
InputStream in = rs.getBinaryStream("data");
IOUtils.copy(in, out);
out.close();
&　　还有一种方法，就是把要存储的数据包装成Blob类型，然后调用PreparedStatement的setBlob()方法来设置数据
con = JdbcUtils.getConnection();
String sql = "insert into tab_bin(filename,data) values(?, ?)";
pstmt = con.prepareStatement(sql);
pstmt.setString(1, "a.jpg");
File file = new&File("f:\\a.jpg");
byte[] datas = FileUtils.getBytes(file);//获取文件中的数据
Blob blob = new&SerialBlob(datas);//创建Blob对象
pstmt.setBlob(2, blob);//设置Blob类型的参数
pstmt.executeUpdate();
con = JdbcUtils.getConnection();
String sql = "select filename,data from tab_bin where id=?";
pstmt = con.prepareStatement(sql);
pstmt.setInt(1, 1);
rs = pstmt.executeQuery();
rs.next();
String filename = rs.getString("filename");
File file = new&File("F:\\"&+ filename) ;
Blob blob = rs.getBlob("data");
byte[] datas = blob.getBytes(0, (int)file.length());
FileUtils.writeByteArrayToFile(file, datas);
上课老师敲的代码：
package cn.itcast.demo4;
import java.io.FileInputS
import java.io.FileNotFoundE
import java.io.FileOutputS
import java.io.IOE
import java.io.InputS
import java.io.OutputS
import java.sql.B
import java.sql.C
import java.sql.PreparedS
import java.sql.ResultS
import java.sql.SQLE
import javax.sql.rowset.serial.SerialB
import mons.io.IOU
import org.junit.T
import cn.itcast.demo3.JdbcU
* @author cxf
public class Demo4 {
* 把mp3保存到数据库中。
* @throws SQLException
* @throws IOException
* @throws FileNotFoundException
public void fun1() throws Exception {
* 1. 得到Connection
* 2. 给出sql模板，创建pstmt
* 3. 设置sql模板中的参数
* 4. 调用pstmt的executeUpdate()执行
Connection con = JdbcUtils.getConnection();
String sql = "insert into tab_bin values(?,?,?)";
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setInt(1, 1);
pstmt.setString(2, "流光飞舞.mp3");
* 需要得到Blob
* 1. 我们有的是文件，目标是Blob
* 2. 先把文件变成byte[]
* 3. 再使用byte[]创建Blob
// 把文件转换成byte[]
byte[] bytes = IOUtils.toByteArray(new FileInputStream("F:/流光飞舞.mp3"));
// 使用byte[]创建Blob
Blob blob = new SerialBlob(bytes);
// 设置参数
pstmt.setBlob(3, blob);
pstmt.executeUpdate();
* 从数据库读取mp3
* @throws SQLException
public void fun2() throws Exception {
* 1. 创建Connection
Connection con = JdbcUtils.getConnection();
* 2. 给出select语句模板，创建pstmt
String sql = "select * from tab_bin";
PreparedStatement pstmt = con.prepareStatement(sql);
* 3. pstmt执行查询，得到ResultSet
ResultSet rs = pstmt.executeQuery();
* 4. 获取rs中名为data的列数据
if(rs.next()) {
Blob blob = rs.getBlob("data");
* 把Blob变成硬盘上的文件！
* 1. 通过Blob得到输入流对象
* 2. 自己创建输出流对象
* 3. 把输入流的数据写入到输出流中
InputStream in = blob.getBinaryStream();
OutputStream out = new FileOutputStream("c:/lgfw.mp3");
IOUtils.copy(in, out);
&标签：&&&&&&&&&&&&&&&&&&&&&&&&&&&原文：/rogge7/p/7008124.html
教程昨日排行
&&国之画&&&& &&&&&&
&& &&&&&&&&&&&&&&
鲁ICP备号-4
打开技术之扣，分享程序人生！