<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=8">
<style type="text/css">
.numberdiv{ float: left;width: 35px;height:35px;text-align:center;font-size:20px;margin: 1px;background:#F0F8FF;font-weight: bold;}
.answerdiv{ float: left;top:10px;width: 90px;height:35px;text-align: center;border:solid;font-size: 20px;}
</style>
<script type="text/javascript" src="excel_data.js"></script>
<script type="text/javascript">
var tiku = [];
var tiku_number = 0;
var tiku_url = "";
var userchooseNumber = 1;
var fenshu = new Array();
var ifanswer = new Array();
var answers = new Array();
var ifshow = false;
function init() {
if (isIE()) {
if (tiku_url != "" && tiku_url != null) {
ReadExcel(2);
load();
}
else{
alert("还没导入题库，请导入题库。");
}
} else {
//document.getElementsByTagName("body")[0].style.display = "none";
ReadExcel(2)
load();
}
}
function load() {
ifshow = false;
//清空数字面板数据
var numberpanel = document.getElementById("numberpanel");
var childs = numberpanel.childNodes;
for (var i = childs.length - 1; i >= 0; i--) {
numberpanel.removeChild(childs[i]);
}
var rows = tiku_number;
for (i = 0; i < rows; i++) {
fenshu[i] = 0;
ifanswer[i] = 0;
answers[i] = 'kong';
}
for (i = 1; i <= rows; i++) {
var createDiv = document.createElement("div");
createDiv.id = i;
createDiv.className = "numberdiv";
createDiv.innerHTML = i;
document.getElementById("numberpanel").appendChild(createDiv);
}
var numberpanel = document.getElementById("numberpanel");
var divs = numberpanel.getElementsByTagName("div");
for (var i = 0; i < divs.length; i++) {
divs[i].onclick = function (event) {
var eve=event || window.event;
var target =eve.target || eve.srcElement;
userchooseNumber = target.id;
//alert(target.id);
chooseNumber(target.id);
}
}
chooseNumber(1);
showDaan();
}
function chooseNumber(id) {
var type = tiku[id - 1].leixing;
var answer = answers[id - 1];
updateNumberUI(id);
updateAnswerUI(answer);
document.getElementById("xuhao").innerHTML = '题目:' + id;
document.getElementById("leixing").innerHTML = tiku[id - 1].leixing;
document.getElementById("tigan").innerHTML = tiku[id - 1].tigan;
document.getElementById("A").innerHTML = 'A.' + tiku[id - 1].A;
document.getElementById("B").innerHTML = 'B.' + tiku[id - 1].B;
document.getElementById("C").innerHTML = 'C.' + tiku[id - 1].C;
document.getElementById("D").innerHTML = 'D.' + tiku[id - 1].D;
document.getElementById("daan").innerHTML = '参考答案:' + tiku[id - 1].daan;
document.getElementById("beizhu").innerHTML = '备注:' + tiku[id - 1].beizhu;
}
function chooseAnswer() {
var A = '';
var B = '';
var C = '';
var D = '';
var valueA = document.getElementById("radioA").checked;
var valueB = document.getElementById("radioB").checked;
var valueC = document.getElementById("radioC").checked;
var valueD = document.getElementById("radioD").checked;
if (valueA === true) {
A = 'A';
}
if (valueB === true) {
B = 'B';
}
if (valueC === true) {
C = 'C';
}
if (valueD === true) {
D = 'D';
}
var userchooseAnswer = A + B + C + D;
var daan = tiku[userchooseNumber - 1].daan;
var x = userchooseAnswer.toLowerCase();
var y = daan.toLowerCase();
answers[userchooseNumber - 1] = userchooseAnswer;
if (x === y) {
alert('回答正确');
fenshu[userchooseNumber - 1] = 1;
ifanswer[userchooseNumber - 1] = 1;
} else {
alert('回答错误');
fenshu[userchooseNumber - 1] = 0;
ifanswer[userchooseNumber - 1] = 1;
}
}
function submit() {
var x = 0,
y = 0;
for (var i = 0; i < tiku_number; i++) {
x = x + fenshu[i];
y = y + ifanswer[i];
}
alert('正确题数：' + x + '\n错误题数：' + (y - x) + '\n未作答：' + (tiku_number - y) );
}
function showDaan() {
if (ifshow == false) {
document.getElementById("daan").style.display = "none";
ifshow = true;
} else {
document.getElementById("daan").style.display = "";
ifshow = false;
}
}
function updateNumberUI(id) {
var numberpanel = document.getElementById("numberpanel");
var divs = numberpanel.getElementsByTagName("div");
for (var i = 0; i < divs.length; i++) {
divs[i].style.background = '#F0F8FF';
if (ifanswer[i] === 1) {
if (fenshu[i] === 1) {
divs[i].style.background = '#00FF00';
} else {
divs[i].style.background = 'red';
}
}
}
document.getElementById(id).style.background = 'yellow';
var answer = answers[id - 1];
}
function updateAnswerUI(userchooseAnswer) {
var choosepanel = document.getElementById("choosepanel");
var inputs = choosepanel.getElementsByTagName("input");
if (userchooseAnswer !== "kong") {
for (var i = 0; i < inputs.length; i++) {
inputs[i].checked = false;
}
for (var i = 0; i < userchooseAnswer.length; i++) {
if (userchooseAnswer.charAt(i) === 'A') {
document.getElementById("radioA").checked = true;
}
if (userchooseAnswer.charAt(i) === 'B') {
document.getElementById("radioB").checked = true;
}
if (userchooseAnswer.charAt(i) === 'C') {
document.getElementById("radioC").checked = true;
}
if (userchooseAnswer.charAt(i) === 'D') {
document.getElementById("radioD").checked = true;
}
}
for (var i = 0; i < inputs.length; i++) {
inputs[i].style.color = 'white';
}
} else {
for (var i = 0; i < inputs.length; i++) {
inputs[i].checked = false;
}
}
}
function ReadExcel(type) {
if (type == 1) {
var tempStr = "";
//得到文件路径的值
var filePath = document.getElementById("upfile").value;
if(filePath!=""){
//创建操作EXCEL应用程序的实例
try{
var oXL = new ActiveXObject("Excel.application");
}
catch(e){
location.reload();
}
//打开指定路径的excel文件
var oWB = oXL.Workbooks.open(filePath);
//操作第一个sheet(从一开始，而非零)
oWB.worksheets(1).select();
var oSheet = oWB.ActiveSheet;
//使用的行数
var rows = oSheet.usedrange.rows.count;
tiku_number = rows - 1;
tiku_url = filePath;
try {
for (var i = 2; i <= rows; i++) {
//var a = oSheet.Cells(i, 2).value.toString() == "undefined" ? "": oSheet.Cells(i, 2).value;
tiku[i - 2] = new Object();
tiku[i - 2].xuhao = oSheet.Cells(i, 1).value;
tiku[i - 2].leixing = oSheet.Cells(i, 2).value;
tiku[i - 2].tigan = oSheet.Cells(i, 3).value;
tiku[i - 2].A = oSheet.Cells(i, 4).value;
tiku[i - 2].B = oSheet.Cells(i, 5).value;
tiku[i - 2].C = oSheet.Cells(i, 6).value;
tiku[i - 2].D = oSheet.Cells(i, 7).value;
tiku[i - 2].daan = oSheet.Cells(i, 8).value;
tiku[i - 2].beizhu = oSheet.Cells(i, 9).value;
}
} catch (e) {
//document.getElementById("txtArea").value = "导入失败";
}
num = rows - 1;
alert("成功导入" + num + "道题");
//退出操作excel的实例对象
oXL.Application.Quit();
//手动调用垃圾收集器
CollectGarbage();
load();
}
else{
alert("未选择导入文件，请选择后点击导入。");
}
} else if (type == 2) {
//console.log(data)
var tempStr = "";
//得到文件路径的值
var filePath = tiku_url;
//创建操作EXCEL应用程序的实例
//var oXL = new ActiveXObject("Excel.application");
//打开指定路径的excel文件
//var oWB = oXL.Workbooks.open(filePath);
//操作第一个sheet(从一开始，而非零)
//oWB.worksheets(1).select();
//var oSheet = oWB.ActiveSheet;
//
免费刷题工具.zip （4个子文件） 
免费刷题工具 
excel_data.js 13KB
题库.xls 25KB
免费刷题工具_2023_6_20.exe 8.77MB
index.html 12KB资源评论
神奇的代码在哪里
- 粉丝: 3856
最新资源
- 个人计算机简称PC机,这种计算机属于___.doc
- 信息技术如何在“互联网+教育”模式中发挥作用获奖科研报告论文.docx
- 基于PLC的电梯控制电气设计.doc
- 工程项目管理系统结构PPT课件.pptx
- 最新国家开放大学电大《网络营销与策划》机考第一套真题题库.docx
- 软件项目特点ppt课件.ppt
- 软件工程实践心得体会.docx
- 基于VB实现课前短信提醒系统[最终版].pdf
- 商业银行数据采集实践诠释.doc
- 网络营销类培训助教-工作流程(超赞的总结).doc
- 数字矿山软件国内现状.pdf
- 微型计算原理与接口技术秒表课程设计报告.docx
- 项目管理试卷全.doc
- 中学信息化年终工作总结.doc
- 研发多项目管理培训课程.doc
- 客户关系管理与网络营销之客户满意和客户忠诚.pptx
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
