四则运算

package com.jaovo.msg.dao;

import java.util.List;

import com.jaovo.msg.model.Shizi;

public interface IuseShizi {
    public List<Shizi> chuTi(int quality);//鍑洪
    public void Suanfen();//绠楀垎鏁?
    public void baoCun();//淇濆瓨
    
    
}

package com.jaovo.msg.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import com.jaovo.msg.model.Shizi;
import com.jaovo.msg.util.DBUtil;

public class MangageShizi {
    
    public void add(Connection connection,Shizi shizi)
    {
        String sql="insert into shi_s(firstnumber,secondnumber,characte,realanswer) value (?,?,?,?)";
        
        PreparedStatement preparedStatement=null;
        try {
            preparedStatement = connection.prepareStatement(sql);
            preparedStatement.setInt(1,shizi.getFirstNumber());
            preparedStatement.setInt(2, shizi.getSecondNumber());
            preparedStatement.setString(3, shizi.getCharacter());
            preparedStatement.setInt(4, shizi.getRealAnswer());
            preparedStatement.executeUpdate();
            
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }finally {
            DBUtil.close(preparedStatement);
            //DBUtil.close(connection);
            
        }
    }

}

package com.jaovo.msg.model;

public class Shizi {
    private int firstNumber;
    private int secondNumber;
    private int maybeThirdNumber;
    private int answer;
    private int realAnswer;
    private String character;
    private boolean rightOrWrong;
    public int getMaybeThirdNumber() {
        return maybeThirdNumber;
    }
    public void setMaybeThirdNumber(int maybeThirdNumber) {
        this.maybeThirdNumber = maybeThirdNumber;
    }
    public int getAnswer() {
        return answer;
    }
    public void setAnswer(int answer) {
        this.answer = answer;
    }
    public int getRealAnswer() {
        return realAnswer;
    }
    public void setRealAnswer(int realAnswer) {
        this.realAnswer = realAnswer;
    }
    public int getFirstNumber() {
        return firstNumber;
    }
    public void setFirstNumber(int firstNumber) {
        this.firstNumber = firstNumber;
    }
    public int getSecondNumber() {
        return secondNumber;
    }
    public void setSecondNumber(int secondNumber) {
        this.secondNumber = secondNumber;
    }
    public String getCharacter() {
        return character;
    }
    public void setCharacter(String character) {
        this.character = character;
    }
    public boolean isRightOrWrong() {
        return rightOrWrong;
    }
    public void setRightOrWrong(boolean rightOrWrong) {
        this.rightOrWrong = rightOrWrong;
    }

}

package com.jaovo.msg.servlet;

import java.io.IOException;
import java.sql.Connection;
import java.util.Random;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.jaovo.msg.dao.MangageShizi;
import com.jaovo.msg.model.Shizi;
import com.jaovo.msg.util.DBUtil;

/**
 * Servlet implementation class MyServlet
 */
@WebServlet("/MyServlet")
public class MyServlet extends HttpServlet {
    private static final long serialVersionUID = 1L;
    public MyServlet() {
        super();
    }
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doPost(request,response);
    }
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        int quality = Integer.parseInt(request.getParameter("quality"));
        Connection connection =  DBUtil.getConnection();
        MangageShizi mShizi=new MangageShizi();
        Random random=new Random();
        int a,b,d;
        char ch;
        for(int i=0;i<quality;i++)
        {
            d=random.nextInt(4);
            if(d==0)
                ch='+';
            else if(d==1)
                ch='-';
            else if(d==2)
                ch='*';
            else 
                ch='/';
            Shizi shizi=new Shizi();
            shizi.setCharacter(String.valueOf(ch));
            if(d==0) {
                a=random.nextInt(100)+1;
                b=random.nextInt(100-a)+1;
                shizi.setFirstNumber(a);
                shizi.setSecondNumber(b);
                shizi.setRealAnswer(a+b);
            }
            else if(d==1) {
                a=random.nextInt(100)+1;
                b=random.nextInt(100)+1;
                if(a<b) {
                    b=random.nextInt(100)+1;
                }
                shizi.setFirstNumber(a);
                shizi.setSecondNumber(b);
                shizi.setRealAnswer(a-b);
            }
            else if(d==2) {
                a=random.nextInt(11);
                b=random.nextInt(11);
                shizi.setFirstNumber(a);
                shizi.setSecondNumber(b);
                shizi.setRealAnswer(a*b);
            }
            else {
                a=random.nextInt(11);
                b=random.nextInt(11);
                a=a*b;
                shizi.setFirstNumber(a);
                shizi.setSecondNumber(b);
                shizi.setRealAnswer(a/b);
            }
            mShizi.add(connection,shizi);
        }
        DBUtil.close(connection);
        //System.out.println("鏁版嵁搴?");
        RequestDispatcher dispatcher = request.getRequestDispatcher("doit.jsp");
        dispatcher .forward(request, response);
        //request.getRequestDispatcher("../doit.jsp").forward(request, response);
    }

}

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 {
            Class.forName("com.mysql.jdbc.Driver").newInstance();
        } catch (InstantiationException | IllegalAccessException | ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        String user = "root";
        String password = "root";
        String url = "jdbc:mysql://localhost:3306/jaovo_msg?useUnicode=true&characterEncoding=utf-8&useSSL=false";
        //jdbc:mysql://localhost:3306/jaovo_msg?useUnicode=true&characterEncoding=utf-8&useSSL=false
        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) {
        if(connection!=null) {
            try {
                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();
        }
    }
    
}

<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.Connection"%>
<%@page import="com.jaovo.msg.util.DBUtil"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<base href="<%=basePath%>">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>答题</title>
</head>
<body>
<%
    Connection connection = DBUtil.getConnection();
    Statement statement=connection.createStatement();
    ResultSet resultSet=statement.executeQuery("select * from shi_s");
    int idn=0;
    while(resultSet.next())
    {
        int num1=resultSet.getInt("firstnumber");
        int num2=resultSet.getInt("secondnumber");
        String character=resultSet.getString("characte");  
        int realanswer=resultSet.getInt("realanswer");
        String ind=String.valueOf(realanswer);
        if(request.getParameter(ind)!=null)
        {
            int answer=Integer.parseInt(request.getParameter(ind));
%>
        <label for="name" ><%=num1+character+num2 %>=</label>
        <table width="75" border="1">
            <tr>
                <td>
                    <%=answer %>
                </td>
            
            </tr>
        </table>
<%
            if(answer==realanswer)
            {
                %>回答正确 <%
            }
            else{
             %>回答错误,正确答案为<%=realanswer %>
<%
            }
         }
           else
           {
               out.print(request.getParameter(ind));
               out.print("出错");
           }
           
        }
    statement.executeUpdate("delete from shi_s");
    %>
    
    <p>
  </body>
</html>

<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.Connection"%>
<%@page import="com.jaovo.msg.util.DBUtil"%>
<%@page import="com.jaovo.msg.model.Shizi"%>
<%@page import="java.util.ArrayList"%>
<%@page import="java.util.Random"%>
<%@page import="java.util.ArrayList"%>
<%@page import="java.util.List"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<base href="<%=basePath%>">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>做题页面</title>
</head>
<body>
        <input type="button" value="倒计时" id="counter" /><br /><br />
        <input type="button" value="开始" id="start" />
        <script type="text/javascript">
        function $(id){return document.getElementById(id)}
        var i=20,s='';
        $('start').onclick=function(){
         i=20;s='';
         var t=setInterval(function(){
           if(s!='是否重新计时？' && i>0){
            $('counter').value='倒计时'+(i--)+'秒';
           }else{
            clearInterval(t)
            if(i==0)alert('时间到')
           }
          },1000);
        }
        $('stop').onclick=function(){
         s=$('arg').value;
        }
        </script>
        <form id="form1" name="form1" method="post" action="answer.jsp">
<%
        Connection connection = DBUtil.getConnection();
        Statement statement=connection.createStatement();
        ResultSet resultSet=statement.executeQuery("select * from shi_s");
        int idn=0;
        while(resultSet.next())
        {
            idn++;
            int num1=resultSet.getInt("firstnumber");
            int num2=resultSet.getInt("secondnumber");
            String character=resultSet.getString("characte");
            int realanswer=resultSet.getInt("realanswer");
            
%>
            <label for="name">
                <%=num1+character+num2 %>=
            </label>
                <input type="text" name="<%=realanswer %>" id="<%=realanswer %>" />
<%
        }
        %>
        <input type="submit" name="提交"/>
        </form>
        <%
        
%>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%
    String path = request.getContextPath();
    String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
    %>
     
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<base href="<%=basePath%>">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<object height="100" width="100" data="abc.mp3"></object>
<title>首页</title>
</head>
<body>
<style type="text/css">
body,td,th{
    font-size: 24px;
}
body{
background-color: #0CF;
background-image: url(a.jpg);
}

</style>
<%

%>
         <form id="form1" name="form1" method="post" action="MyServlet">
                多少道题 : &nbsp;
                <input type="text" name="quality" size="20" /> &nbsp; 
                <input type="submit" value="开始" />
        </form>
    
</body>
</html>