以下文章讲述如何利用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(rs.getString("答案C").trim());
    ch.setAnswerD(rs.getString("答案D").trim());
    l.add(ch);
   }
   for (Choice ch : l) {
    System.out.println(ch.getAnswerA());
    
   }
  } catch (Exception e) {
   System.err.println(e);
  } finally {
   try {
    stmnt.close();
    c.close();
   } catch (Exception e) {

    e.printStackTrace();
   }
  }

 }
// public Connection getConnection(String filePath) throws Exception
// {
//  Connection c = null;
//  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//  String conStr ="jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ="+filePath;
//  c = DriverManager.getConnection(conStr);
//  return c;
// }
// public void closeConnection(Connection con)
// {
//  
// }
}