以下文章讲述如何利用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)
// {
//
// }
}