四则运算1 java+jsp+SQLServer

1，设计思想
（1）在java resourse里定义包和类

（2）在类里定义生成算式，并将算式保存在数据库中的方法

（3）在jsp文件中调用java方法

2，源程序代码

生成算式的方法

public void create() {
		// TODO Auto-generated method stub
		Equation equ=new Equation();
		Random ran=new Random();
		for(int i=1;i<=1000;i++){
			Connection con=DBUtil.getConnection();
			equ.setFirstNum(ran.nextInt(0+100));
			equ.setSecondNum(ran.nextInt(0+100));
			equ.setSymbol(equ.s[ran.nextInt(4)]);
			if(i<10)
			equ.setId("000"+i);
			if(i>=10&&i<100)
				equ.setId("00"+i);
			if(i>=100&&i<1000)
				equ.setId("0"+i);
			if(i==1000)
				equ.setId("1000");
			if(equ.getSymbol()=="+")
				equ.setResult(equ.getFirstNum()+equ.getSecondNum());
			if(equ.getSymbol()=="-")
				equ.setResult(equ.getFirstNum()-equ.getSecondNum());
			if(equ.getSymbol()=="*")
				equ.setResult(equ.getFirstNum()*equ.getSecondNum());
			if(equ.getSymbol()=="/"&&equ.getSecondNum()!=0&&(equ.getFirstNum()%equ.getSecondNum()==0)&&equ.getFirstNum()>=equ.getSecondNum())
				equ.setResult(equ.getFirstNum()/equ.getSecondNum());
			{
				if(equ.getResult()<100&&equ.getResult()>=0){
				try{
				    String sql="insert into equation(id,firstNum,symbol,secondNum,result)values('"+equ.getId()+"','"+equ.getFirstNum()+"','"+equ.getSymbol()+"','"+equ.getSecondNum()+"','"+equ.getResult()+"')";
				    Statement stmt=con.createStatement();
				    stmt.executeUpdate(sql);//更新
				}catch(SQLException e){
					e.printStackTrace();
				}finally {
					DBUtil.close(con);
				}
			}
			else i--;
				} 
		}
	}
	
	
	public String show(){
		Equation equ=new Equation();
		Connection con=DBUtil.getConnection();
		String str ="";
		Random ran=new Random();
		Statement stmt;
		try {
			stmt = con.createStatement();
			int id1=ran.nextInt(999)+1;
			ResultSet rs=stmt.executeQuery("SELECT * FROM equation where id="+id1);
			while(rs.next()){
				str=rs.getString("id")+" "+rs.getString("firstNum")+rs.getString("symbol")+rs.getString("secondNum")+"=";
			}
		} catch (SQLException e) {
			
			e.printStackTrace();
		}
		
		return str;
	}

　　jsp

<%@ 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>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>四则运算</title>
</head>
<center>
<body background="D:图片动漫20150422H2607_fKHLB.jpeg">
    <%if(request.getAttribute("error1")!=null){
        out.print("<script language='javaScript'>alert('题数和时间不能为空'); </script>)");
        }
        %>
    <%if(request.getAttribute("error2")!=null){ 
        out.print("<script language='javaScript'>alert('请正确输入'); </script>)");
    }
    %>
    <center>
        <font color="red" size="4" face="楷体">欢迎来到四则运算</font>
    </center>
    <form action="caculateInput.jsp" method="post">
        <table align="center" >
        <tr>
            <td>
                <font face="楷体">请输入出题数目</font>
            </td>
            <td>
            <input type="text" name="number" placeholder="请输入……">
            </td>
        </tr>
         <tr>
            <td>
                <font face="楷体">请设置做题时间(秒)</font>
            </td>
            <td>
            <input type="text" name="time" placeholder="请输入……">
            </td>
        </tr>
        <tr align="center">
                <td colspan="2">
                <input type="submit" value="开始答题"/>
                <input type="reset" value="重置题目数目"/>
                </td>
            </tr>
        </table>
    </form>
</body>
</center>
</html>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
 <%@page import="com.jaovo.msg.Util.showAnswer"%>
 <%@page import="com.jaovo.msg.dao.EquationDaoImpl" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%    
      String url = "http://localhost:8080/四则运算2/equation/start.jsp";   //设置跳转的地址  
      int time=Integer.parseInt(request.getParameter("time"));
      int number=Integer.parseInt(request.getParameter("number"));
      EquationDaoImpl equ=new EquationDaoImpl();
      String time1=request.getParameter("time");
      String number1=request.getParameter("number");
%> 
    <%if("".equals(time1.trim())||"".equals(number1.trim())){
        request.setAttribute("error1", "题数和时间不能为空");
    %>
        <jsp:forward page="start.jsp"></jsp:forward>
    <%
    }
    %>
    
    <%
    if(time<0||number<0){
        request.setAttribute("error2", "请正确输入");
    
    %>
    <jsp:forward page="start.jsp"></jsp:forward>
   <%
    }
   %>
<html>
<head >
<title>四则运算</title>
<meta http-equiv=refresh content=<%=time %>;url=<%=url %>>  
</head>
<body background="D:图片新建文件夹9252150_130954294310_2.jpg" background-size:cover>
<form action="caculate.jsp" method="post">
    <table align="center" >
            <%
            for(int i=0;i<number;i++){
                String str=equ.show();
            %>
            <tr>
                <td><%=str.substring(6, str.length()) %></td>
                <td>
                    <input type="text" name="result" placeholder="请输入……" >
                </td>
            </tr>
            <tr>
                <td>
                    <input type="hidden" name="id" value="<%=str.substring(0,4) %>" >
                </td>
            </tr>
            <%
            }
            %>
        <div align="center">  
            <h3 style=color:red>答题剩余时间:<span id=jump ></span></h3>  
            <h4><a href="start.jsp" onclick="jumpToIndex()">重新设题</a></h4>  
        </div> 
            <tr align="center">
                <td colspan="2">
                <input type="submit" value="提交"/>
                <input type="reset" value="重置"/>
                </td>
            </tr>
    </table>
</form>
</body>
        <script>  
             function countDown(secs){  
                       jump.innerText=secs;  
                       if(--secs>0)  
                                setTimeout("countDown("+secs+" )",1000);
                       if(secs==0)
                           document.forms[0].submit();
             }
             countDown(<%=time%>);        
            function jumpToIndex(){  
                window.location.href='<%="http://localhost:8080/四则运算2/equation/start.jsp" %>';  
            }  
       </script>
</html>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%@page import="java.util.*" %>
    <%@page import="com.jaovo.msg.dao.EquationDaoImpl" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>计算结果</title>
</head>
<body background="D:图片新建文件夹9252150_130954294310_2.jpg">
    <%
       String[] result=request.getParameterValues("result");
       String[] id=request.getParameterValues("id");
       String[] idNum=new String[100];
       int I=0;
       for(String i:id){
           idNum[I]=i;
           I++;
       }
       String[] RCaculate=new String[100];
       int x=0;
       String[] WCaculate=new String[100];
       int y=0;
       String[] KCaculate=new String[100];
       int z=0;
       I=0;
       EquationDaoImpl equDao=new EquationDaoImpl();
       for(String str:result){
           if(str == null || "".equals(str.trim())){
               KCaculate[z]=equDao.show1(idNum[I]);z++;continue;
               }
           if(equDao.caculate(str,idNum[I]).equals("正确")){
               RCaculate[x]=equDao.show1(idNum[I]);x++;
            }
           if(equDao.caculate(str,idNum[I]).equals("错误")){
               WCaculate[y]=equDao.show1(idNum[I]);y++;
           }
           I++;
       }
      out.println("正确的数量:"+x);
    %>
    <br/>
    <%
    out.print("错误的题目数量:"+y);
    %>
<!--     <a href="wrong.jsp">查看错题</a> -->
    <br/>
    <%
    out.print("未答的题目数量:"+z);
    %>
<!--     <a href="">查看未答的题目</a> -->
    <br/>
    <a href="create.jsp">更新题目</a><br/>
    <a href="start.jsp">重新计算</a><br/>
    <form action="wrong.jsp" method="post">
        <table align="center">
            <%
                for(int i=0;i<y;i++){
            %>
            <tr>
                <td>
                    <input type="hidden" name="wrong" value="<%=WCaculate[i]%>" >
                </td>
            </tr>
            <%} %>
            <%
            for(int i=0;i<z;i++){ 
            %>
            <tr>
                <td>
                    <input type="hidden" name="kong" value="<%=KCaculate[i]%>" >
                </td>
            </tr>
            <%} %>
            <tr>
                <input type="submit" value="查看错题和未做的题"/>
            </tr>
        </table>
    </form>
    
</body>
</html>

3，运行结果截图

【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/news1997/p/7993803.html