android通过jxl读excel存入sqlite3数据库_app

概述复制代码代码如下:packagecom.demo.day20140228;importjava.io.File;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.PreparedStatement;importjava.sql.SQLException;importjava.sql.Stat

复制代码代码如下:
package com.demo.day20140228;

import java.io.file;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.sqlException;
import java.sql.Statement;

import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;

public class DictExcelDemo {
public static voID main(String[] args) {
  DictExcelDemo ded = new DictExcelDemo();
  Connection conn = ded.getConnection();
  ded.readExcel_(conn);
}

private Connection getConnection(){
  Connection conn = null;
  try {
   Class.forname("org.sqlite.JDBC");
   conn = DriverManager.getConnection("jdbc:sqlite:database.db");
   Statement stat = conn.createStatement();
   stat.executeUpdate("create table if not exists dictionary(enword varchar(200),cnword varchar(200));");// 创建一个表，两列

  } catch (ClassNotFoundException e) {
   e.printstacktrace();
  } catch (sqlException e) {
   e.printstacktrace();
  }
  return conn;
}

private voID readExcel_(Connection conn) {
  try {
   Workbook book = Workbook.getWorkbook(new file("English.xls"));
   PreparedStatement prep = conn.prepareStatement("insert into dictionary(enword,cnword) values(?,?);");

   for (int a = 0; a < 26; a++) {
    // 获得第一个工作表对象
    Sheet sheet = book.getSheet(a);
    // 得到第一列第一行的单元格
    // 得到第一列第一行的单元格
    int columnum = sheet.getColumns();// 得到列数
    int rownum = sheet.getRows();// 得到行数
    for (int i = 1; i < rownum; i++)// 循环进行读写
    {// 行
     String key = "";
     String value = "";
     for (int j = 0; j < columnum; j++) {// 列
      Cell cell1 = sheet.getCell(j,i);
      String result = cell1.getContents();
      if (j == 0) {
       key += result;
      } else {
       value += result;
      }
     }
     // System.out.println(key+"=="+value);
     prep.setString(1,key);
     prep.setString(2,value);
     prep.addBatch();
    }
   }
   conn.setautoCommit(false);
   prep.executeBatch();
   conn.setautoCommit(true);
   conn.close();
   book.close();
  } catch (Exception e) {
   System.out.println(e);
  }
}
}