java JDBC解析excel文档

以下文章讲述如何利用jdbc处理这些数据----利用java JDBC解析excel文档

package com.p1;

public class Choice {

 private int cid;
 private String title;
 private String answerA;
 private String answerB;
 private String answerC;
 private String answerD;
 private String rightAnswer;
 public String getAnswerA() {
  return answerA;
 }
 public void setAnswerA(String answerA) {
  this.answerA = answerA;
 }
 public String getAnswerB() {
  return answerB;
 }
 public void setAnswerB(String answerB) {
  this.answerB = answerB;
 }
 public String getAnswerC() {
  return answerC;
 }
 public void setAnswerC(String answerC) {
  this.answerC = answerC;
 }
 public String getAnswerD() {
  return answerD;
 }
 public void setAnswerD(String answerD) {
  this.answerD = answerD;
 }
 public int getCid() {
  return cid;
 }
 public void setCid(int cid) {
  this.cid = cid;
 }
 public String getRightAnswer() {
  return rightAnswer;
 }
 public void setRightAnswer(String rightAnswer) {
  this.rightAnswer = rightAnswer;
 }
 public String getTitle() {
  return title;
 }
 public void setTitle(String title) {
  this.title = title;
 }
}

单选题类Choice.java

以下为主测试类

ExcelTest .java

import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

public class ExcelTest {
 public static void main(String[] args) {
  Connection c = null;
  Statement stmnt = null;
  try {
   
   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   c = DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ=c:\\Book1.xls ");
//   c = DriverManager.getConnection("jdbc:odbc:data", "", "");
//   c= new ExcelTest().getConnection("C:\\Book1.xls");

/

*

以上连接方法任意都行,其中data为系统DSN的数据源名称,在管理工具中设置数据源类型为Microsoft Excel Driver (*.xls)};

*/
   stmnt = c.createStatement();
   String query = "SELECT * FROM [Sheet1$]";
   ResultSet rs = stmnt.executeQuery(query);
   List<Choice> l = new ArrayList<Choice>();
   while (rs.next()) {
    Choice ch = new Choice();

    ch.setAnswerA(rs.getString("答案A").trim());
    ch.setAnswerB(rs.getString("答案B").trim());
    ch.setAnswerC