计算器 - ★若风

程序设计思想：

首先实现用代码生成随机的加减乘除的算式以及结果，并存入到数据库中，在运行web端的程序，弹出输入做的提的数目，并将该数量提交到另外一个jsp中，并显示题目，让使用者输入计算的结果，并实现在线答题，控制答题的时间，超出时间自动跳转，并告诉使用者对错情况，并统计使用者作对以及做错的数量。

程序源代码：

Success.jsp

<%@page import="java.util.Date"%>

<%@page import="java.text.SimpleDateFormat"%>

<%@ page language="java" contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<!--

.STYLE2 {

font-family: "Times New Roman", Times, serif;

font-weight: bold;

}

-->

</style>

<div>

<br>

<p align="center"> 愿你生活每一天都开心</p>

<hr>

<tr>

</tr>

<tr>

产生题的数量 </strong></td>

</tr>

<tr>

</tr>

</table>

SimpleDateFormat simpleDateFormat=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

Date currenTime=new Date();

String time=simpleDateFormat.format(currenTime).toString();

out.print("当前时间："+time);

</div>

<p align="center">TTF处女作品</p>

<hr>

</body>

</html>

List.jsp

<%@page import="java.util.Random"%>

<%@page import="com.jaovo.msg.model.Exercise"%>

<%@page import="com.jaovo.msg.dao.ExerciseDaoImpl"%>

<%@page import=" java.util.ArrayList" %>

<%@page import=" java.util.List" %>

<%@ page language="java" contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

var maxtime = 60 //半个小时，按秒计算，自己调整!

function CountDown(){

if(maxtime>=0){

seconds = Math.floor(maxtime%60);

msg = "距离结束还有"+seconds+"秒";

document.all["timer"].innerHTML=msg;

if(maxtime == 5) alert('注意，还有5秒!');

--maxtime;

}

else{

clearInterval(timer);

alert("时间到，结束!");

document.getElementById('Tj').click();

}

timer = setInterval("CountDown()",1000);

</SCRIPT>

<!--

body,td,th {

font-family: Courier New, Courier, monospace;

}

-->

</div>

.STYLE1 {color: #F0F0F0}

.STYLE1 {color: #FF0000}

.STYLE2 {color: #FFFFFF}

</style></head>

<div >

int a=Integer.parseInt(request.getParameter("number"));

ExerciseDaoImpl exerciseDaoImpl=new ExerciseDaoImpl();

List<Exercise>list=new ArrayList<Exercise>();

Exercise exercise=new Exercise();

String id="";

String result="";

Random random=new Random();

for(int i=0;i<a/2;i++)

{

int b=random.nextInt(98)+1;

id=id+" "+b;

exercise=exerciseDaoImpl.loadTest(b);

list.add(exercise);

}

for(int j=a/2;j<a;j++)

{

int c=random.nextInt(98)+1;

id=id+" "+c;

exercise=exerciseDaoImpl.loadTest1(c);

list.add(exercise);

}

session.setAttribute("id", id);

</div>

</tr>

int i=1;

for(Exercise exercise1:list){

<td>

<td>

</tr>

i++;

}

// session.setAttribute("loginUser",user);

</tr>

</tr>

</tr>

</table>

</form>

</div>

</body>

</html>

Checkresult.jsp

<%@page import="com.jaovo.msg.dao.ExerciseDaoImpl"%>

<%@page import="com.jaovo.msg.model.Exercise"%>

<%@page import=" java.util.ArrayList" %>

<%@page import=" java.util.List" %>

<%@ page language="java" contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<!--

.STYLE1 {color: #FFFFFF}

.STYLE2 {color: #FF0000}

.STYLE3 {color: #FF0000; font-family: Georgia, "Times New Roman", Times, serif; }

-->

</style>

int m=0;//记录正确的题数；

int n=0;//记录错误的题数；

Exercise exercise=new Exercise();

ExerciseDaoImpl exerciseDaoImpl=new ExerciseDaoImpl();

List<Exercise>list=new ArrayList<Exercise>();

String id=(String)session.getAttribute("id");

String result[]=request.getParameterValues("result");

String Id[]=id.toString().trim().split(" ");

for(int i=0;i<Id.length/2;i++)

{

exercise=exerciseDaoImpl.loadTest(Integer.parseInt(Id[i]));

list.add(exercise);

System.out.println(Id[i]);

}

for(int i=Id.length/2;i<Id.length;i++)

{

exercise=exerciseDaoImpl.loadTest1(Integer.parseInt(Id[i]));

list.add(exercise);

}

for(int j=0;j<result.length;j++)

{

System.out.println(result[j]);

}

<div >

<tr>

</tr>

int i=0;

for(Exercise exercise1:list){

<tr>

<td>

<td>

if(result[i].equals(list.get(i).getResult()))

{

m++;

<% out.print(result[i]);%>

</font>

}

else

{

n++;

<% out.print(result[i]);%>

</font>

}

</span> </div></td>

<td>

</tr>

i++;

}

// session.setAttribute("loginUser",user);

session.invalidate();

</table>

<br>

<tr>

<td>

<p align="center" class="STYLE2" color="white">答对的题目</p> </td>

<td>

<div align="center" class="STYLE3">答错的题目 </div></td>

</tr>

<td>

<td>

</tr>

</table>

</body>

</html>

主类中的程序：

package com.jaovo.msg.model;

public class Exercise {

private int id;

private String experssion;

private String result;

public int getId() {

return id;

}

public void setId(int id) {

this.id = id;

}

public String getExperssion() {

return experssion;

}

public void setExperssion(String experssion) {

this.experssion = experssion;

}

public String getResult() {

return result;

}

public void setResult(String result) {

this.result = result;

}

连接数据库：

package com.jaovo.msg.Util;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

public class DBUtil {

public static Connection getConnection() {

try {

//1 鍔犺浇椹卞姩

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();

} catch (InstantiationException | IllegalAccessException | ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

String user = "sa";

String password = "123456";

String url = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=jaovo_msg";

Connection connection = null;

try {

//2 鍒涘缓閾炬帴瀵硅薄connection

connection = DriverManager.getConnection(url,user,password);

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return connection;

}

//鍏抽棴璧勬簮鐨勬柟娉�

public static void close(Connection connection ) {

try {

if (connection != null) {

connection.close();

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

public static void close(PreparedStatement preparedStatement ) {

try {

if (preparedStatement != null) {

preparedStatement.close();

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

public static void close(ResultSet resultSet ) {

try {

if (resultSet != null) {

resultSet.close();

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

从数据库中抽题：

package com.jaovo.msg.dao;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import com.jaovo.msg.Util.DBUtil;

import com.jaovo.msg.model.Exercise;

public class ExerciseDaoImpl {

public Exercise loadTest(int id) {

Connection connection = DBUtil.getConnection();

//鍑嗗sql璇彞

String sql = "select * from Table1 where id = ?";

//鍒涘缓璇彞浼犺緭瀵硅薄

PreparedStatement preparedStatement = null;

ResultSet resultSet = null;

Exercise exercise = null;

try {

preparedStatement = connection.prepareStatement(sql);

preparedStatement.setInt(1, id);

resultSet = preparedStatement.executeQuery();

while(resultSet.next()) {

exercise = new Exercise();

exercise.setId(id);

exercise.setExperssion(resultSet.getString("expression"));

exercise.setResult(resultSet.getString("result"));

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}finally {

DBUtil.close(resultSet);

DBUtil.close(preparedStatement);

DBUtil.close(connection);

}

return exercise;

}

//获取三位数字；

public Exercise loadTest1(int id) {

Connection connection = DBUtil.getConnection();

//鍑嗗sql璇彞

String sql = "select * from Table2 where id = ?";

//鍒涘缓璇彞浼犺緭瀵硅薄

PreparedStatement preparedStatement = null;

ResultSet resultSet = null;

Exercise exercise = null;

try {

preparedStatement = connection.prepareStatement(sql);

preparedStatement.setInt(1, id);

resultSet = preparedStatement.executeQuery();

while(resultSet.next()) {

exercise = new Exercise();

exercise.setId(id);

exercise.setExperssion(resultSet.getString("expression"));

exercise.setResult(resultSet.getString("result"));

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}finally {

DBUtil.close(resultSet);

DBUtil.close(preparedStatement);

DBUtil.close(connection);

}

return exercise;

}

产生随机算式的程序：

package com.jaovo.msg.dao;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.ArrayList;

public class Main {

public static void main(String[] args) throws SQLException {

// TODO Auto-generatesd method stub

String JDriver="com.microsoft.sqlserver.jdbc.SQLServerDriver";//��

String connectDB= "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=jaovo_msg";//��Դ

try

{

Class.forName(JDriver);//��ݿ��棬��ظ��ַ��

}catch(ClassNotFoundException e)

{

//e.printStackTrace();

System.out.println("��ݿ��ʧ��");

System.exit(0);

}

System.out.println("��ݿ��ɹ�");

String user="sa";

String password="123456";

Connection con = null;

try {

con = DriverManager.getConnection(connectDB,user,password);

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}//��ݿ��

System.out.println("��ݿ�ɹ�");

Statement stmt = null;

try {

stmt=con.createStatement();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}//��SQL��

//---------------------------------------------------------------------------------------//

RandomString s=new RandomString();

ArrayList list=new ArrayList();

long i=0;

while(i!=99){

//list=s.newRandomString();

list=s.newHarderRandomString();

i++;

System.out.println("-----------------------------------------");

System.out.println("��ţ�"+i);

stmt.executeUpdate("insert into Table2(expression,result)values('"+RandomString.toString(list)+"','"+CheckAnswer.calaulateAnswer(list)+"')");

System.out.println("��ʽ�ӣ�"+RandomString.toString(list));

System.out.println(CheckAnswer.calaulateAnswer(list));

System.out.println("-----------------------------------------");

}}

}

程序运行截图：

发表于 2017-12-06 22:05 ★若风阅读(145) 评论(0) 编辑收藏举报