1、SqliteUtils类:
package com.geoway.net;
import java.io.ByteArrayOutputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
/*
* jdbc-sqlite版本3.7.2
*/
public class SqliteUtils {
private Connection conn;
private PreparedStatement ps;
public SqliteUtils(){
try {
Class.forName("org.sqlite.JDBC");
conn = DriverManager.getConnection("jdbc:sqlite:E:\\sqlite\\dbFile\\Tiles.db");
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
System.out.println("数据库已经打开!");
}
public void add(int level, int x, int y, File imgFile){
try {
ps = conn.prepareStatement("insert into Tile(level, x, y, img) values(?,?,?,?);");
byte[] tile_image = null;
FileInputStream fis = new FileInputStream(imgFile);
ByteArrayOutputStream bos = new ByteArrayOutputStream();
byte[] buf = new byte[1024];
try {
for (int readNum; (readNum = fis.read(buf)) != -1;)
{
bos.write(buf, 0, readNum);
System.out.println("read " + readNum + " bytes,");
}
tile_image = bos.toByteArray();
ps.setInt(1, level);
ps.setInt(2, x);
ps.setInt(3, y);
ps.setBytes(4, tile_image);
int s &