四则运算二
一、记录开发过程中的时间记录日志
| PSP2.1 | Personal Software Process Stages | Time |
| Planning | 计划 | 48小时 |
| Development | 开发 | |
| · Analysis | · 需求分析 (包括学习新技术) |
一个下午+一晚 （32小时） |
| · Design Spec | ·生成设计文档 | 2小时 |
| ·Design Review | ·设计复审（和同事审核设计文档） | 1小时 |
| ·Coding Standard | ·代码规范（为目前的开发制定合适的规范） | 1小时 |
| ·Design | .具体设计 | 2小时 |
| ·Coding | ·具体编码 | 8小时 |
| ·Code Review | ·代码复审 | 1小时 |
| .Test | ·测试（自我测试、修改代码、提交修改） | 1小时 |
| Reporting | 报告 | |
| ·Test Report | ·测试报告 | 1小时 |
| ·Size Measurement | ·计算工作量 | 1小时 |
| ·Postmortem & Precess Improvement Plan | ·事后总结，并提出过程改进计划 | 1小时 |
| 合计 | 51小时 |
二、程序设计思想
按Bean+Servlet+jsp模式（即MVC模式），首先数据库要建三个表，一个储存用户信息，一个储存题目，一个储存成绩。其余是Java文件，实现对整数，真分数以及混合数的运算。最后写jsp文件，实现网页界面显示。
三、源代码
（这里只粘贴部分代码）
package db;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DBConn {
private static final String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
private static final String url = "jdbc:sqlserver://localhost:1433; DatabaseName=Arithmetic";
private static final String user= "sa";
private static final String password= "yyq838485140///";
private static Statement stmt = null;
private static Connection coon= null;
private static PreparedStatement pstmt;
private static ResultSet rs;
static{
try {
Class.forName(driver);
coon = DriverManager.getConnection(url, user, password);
stmt = coon.createStatement();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
static public Connection getConnection(){
return coon;
}
public static void close() {
if(rs!=null){
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}finally{
try{
if(pstmt!=null)
pstmt.close();
}catch(SQLException e){
e.printStackTrace();
}finally{
try{
if(coon!=null)
coon.close();
}catch(SQLException e)
{
e.printStackTrace();
}
}
}
}
}
public static void main(String[] args) {
try {
DBConn.getConnection();
} catch (Exception e) {
e.printStackTrace();
}
}
}
1 package dao; 2 3 import java.sql.Connection; 4 import java.sql.PreparedStatement; 5 import java.sql.ResultSet; 6 import java.sql.SQLException; 7 8 import db.DBConn; 9 import model.User; 10 11 public class UserDao1 { 12 13 public static void main(String[] args) { 14 15 User u = new User(); 16 u.setUsername("asdsfd"); 17 u.setPwd("1111"); 18 UserDao1 a = new UserDao1(); 19 try { 20 a.insert(u); 21 } catch (SQLException e) { 22 // TODO Auto-generated catch block 23 e.printStackTrace(); 24 } 25 26 } 27 public void insert(User u) throws SQLException 28 { 29 Connection conn = null; 30 PreparedStatement pstmt = null; 31 ResultSet rs = null; 32 33 conn = DBConn.getConnection(); 34 //pstmt = conn.prepareStatement("insert into User(username,pwd) values(?,?)"); 35 pstmt = conn.prepareStatement("insert into user1(username,pwd) values(?,?)"); 36 pstmt.setString(1, u.getUsername()); 37 pstmt.setString(2, u.getPwd()); 38 pstmt.executeUpdate(); 39 40 DBConn.close(); 41 } 42 43 public User selectByUsername(User u) throws SQLException 44 { 45 Connection conn = null; 46 PreparedStatement pstmt = null; 47 ResultSet rs = null; 48 49 User n = null; 50 conn = DBConn.getConnection(); 51 pstmt = conn.prepareStatement("select * from user1 where username=?"); 52 pstmt.setString(1, u.getUsername()); 53 54 rs = pstmt.executeQuery(); 55 56 if(rs.next()) 57 { 58 n = new User(); 59 n.setUsername(rs.getString("username")); 60 n.setPwd(rs.getString("pwd")); 61 n.setQnum(rs.getInt("qNum")); 62 n.setEnum(rs.getInt("eNum")); 63 n.setRnum(rs.getInt("rNum")); 64 65 } 66 67 DBConn.close(); 68 return n; 69 } 70 71 public void update(User u) throws SQLException 72 { 73 Connection conn = null; 74 PreparedStatement pstmt = null; 75 ResultSet rs = null; 76 77 conn = DBConn.getConnection(); 78 pstmt = conn.prepareStatement("update user1 set qNum=?,eNum=?,rNum=? where username=?"); 79 pstmt.setInt(1, u.getQnum()); 80 pstmt.setInt(2, u.getEnum()); 81 pstmt.setInt(3, u.getRnum()); 82 pstmt.setString(4, u.getUsername()); 83 pstmt.executeUpdate(); 84 85 DBConn.close(); 86 } 87 88 89 }
<!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>登录</title> <script type="text/javascript"> </script> <style type="text/css"> #input { position:absolute;left:0px; top:30%; width:100%; } #logo { position: absolute; left: 0px; top: 17px; width: 100%; z-index: 100; } img {z-index: -1;} #logo form h1 { font-style: italic; font-size: 46px; color: white; } </style> </head> <body> <img src="images/p2.jpg" width="100%" height="100%"/> <div id="loginMessage"> </div> <div id="logo"> <form> <center> <h1>KNY熊出没答题网</h1> </center> </form> </div> <div id="input"> <center> <form action="Loginac" method="post" onsubmit="return check()"> <table> <tr><td>用户名：</td><td><input type="text" id="n1" name="username"></td><td><span id="userInfo"></span></td></tr> <tr><td>密码：</td><td><input type="password" id="pwd" name="pwd"></td><td><span id="pwdInfo"></span></td></tr> <tr><td><a href="Logon.html"><input type="button" id="bt1" value="注册"></a></td><td><input type="submit" value="登录"></td></tr> <tr><td></td><td><span id="loginResult"></span></td></tr> </table> </form> </center> </div> </body> </html>
1 <%@ page language="java" contentType="text/html; charset=UTF-8" 2 pageEncoding="UTF-8"%> 3 4 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> 5 <html> 6 <head> 7 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> 8 <title>主页</title> 9 10 <script src="js/jquery-2.1.1.min.js"></script> 11 12 13 <script type="text/javascript" src="js/index.js"></script> 14 15 <style type="text/css"> 16 #logo { 17 position: absolute; 18 left: 0px; 19 top: 17px; 20 width: 100%; 21 z-index: 100; 22 } 23 img {z-index: -1;} 24 #logo form h1 { 25 font-style: italic; 26 font-size: 36px; 27 color: #66FFCC;} 28 #user{position:absolute;left:5%;top:10px;z-index:200;} 29 #login{position:absolute;left:91%;top:10px;z-index:200;} 30 #logout{position:absolute;left:95%;top:10px;z-index:200;} 31 #wrap {position:absolute;left:0px;top:0px;width:100%;height:100%} 32 #menu {display: none;text-align: center;} 33 #userInfo {display: none;text-align: center;} 34 #zuoTiInput {display: none;} 35 #selectInput {display: none;text-align: center;} 36 #show {display: none; height: 350px;overflow: auto;} 37 #right {position:absolute;left:50%;top:40px;height:80%;width:40%} 38 #left { 39 position: absolute; 40 width: 518px; 41 top: 116px; 42 left: 48px; 43 height: 13px; 44 } 45 #zuoTiFuZhu {text-align: center;} 46 #result {text-align: center;} 47 #user { 48 color: #000033; 49 } 50 #user { 51 font-weight: bold; 52 } 53 #user { 54 color: #900; 55 } 56 #user { 57 color: #CC0033; 58 } 59 </style> 60 61 62 </head> 63 <body> 64 <img src="images/p4.jpeg" width="100%" height="100%"> 65 <div id="logo"> 66 <form> 67 <center> 68 <h1>KNY熊出没答题网</h1> 69 </center> 70 </form> 71 </div> 72 <!-- 73 <div id="loginBT" align="right"> 74 <a href="Login.html"><button>登录</button></a> 75 </div> 76 !--> 77 <div id="login"> 78 <a href="Login.html"><button>登录</button></a> 79 </div> 80 <div id="add"> 81 <a href="Logon.jsp"><button>注册</button></a> 82 </div> 83 <div id="user"> 84 您好！${user.username} 85 </div> 86 <div id="wrap"> 87 88 <div id="left"> 89 90 91 <div id="loginMessage"></div> 92 93 94 <!--<div id="userInfo"> 95 用户名：${user.username} 96 <!-- <div id="loginBT" align="right"> 97 <a href="Logoutac"><button id="logout">注销</button></a> 98 </div> !--> 99 100 101 <div id="menu"> 102 <button id="zuoTi">做题</button> 103 <button id="selectLiShiShiTi">查询历史试题</button> 104 </div> 105 106 <div id="zuoTiInput" > 107 108 <table align="center"> 109 <tr><td>试题类型：</td><td><label>整数式<input type="radio" name="type" value="0" checked="checked"></label></td><td><label>真分数式<input type="radio" name="type" value="1"></label></td></tr> 110 <tr><td>有无乘除：</td><td><label>无<input type="radio" name="hasChengChu" value="0" checked="checked"></label></td><td><label>有<input type="radio" name="hasChengChu" value="1"></label></td></tr> 111 <tr><td>有无括号：</td><td><label>无<input type="radio" name="hasKuoHao" value="0" checked="checked"></label></td><td><label>有<input type="radio" name="hasKuoHao" value="1"></label></td></tr> 112 <tr><td>最大值：</td><td colspan="2"><input type="text" name="maxNum" value="10"><span id="maxNumInfo"></span></td></tr> 113 <tr><td>试题个数：</td><td colspan="2"><input type="text" name="num" value="10"><span id="numInfo"></span></td></tr> 114 <tr><td colspan="3"><input type="button" id="zuoTiInputTiJiao" value="提交"></td></tr> 115 </table> 116 117 </div> 118 119 <div id="selectInput"> 120 <select id="shiJuanList"> 121 122 </select> 123 124 <select id="typeSelect"> 125 <option value="all" selected="selected"> 126 全部 127 </option> 128 129 <option value="right"> 130 正确 131 </option> 132 133 <option value="wrong"> 134 错误 135 </option> 136 137 </select> 138 139 <button id="selectShiJuan"> 140 查询 141 </button> 142 </div> 143 144 145 <div id="show"> 146 <table id="showShiTiTable" align="center" border="1"> 147 148 </table> 149 <div id="zuoTiFuZhu"><button id="jiaoJuanBT">交卷</button><span id="shengYuTime"></span></div> 150 <div id="result"> 151 152 </div> 153 </div> 154 155 </div> 156 </div> 157 </body> 158 </html
四、程序运行结果
（部分截图）
