考试卡的增删改查

Ka类：

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
 
import passage.Card;
import passage.Student;
import passage.Card;
import tool.Tool;
 
public class Ka {
    public void add(Card stu) {
        Connection conn=Tool.getConnection();
        String sql="insert into biao (cid,cname,cteacher,couid,counat,credit,couclass,coum,testway,testdata,testcount,testm,testgrade,testeva,testa) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
        try {
            PreparedStatement ps=conn.prepareStatement(sql);
            ps.setString(1,stu.getCardId());
            ps.setString(2,stu.getCourseName());
            ps.setString(3, stu.getCourseTeacher());
            ps.setString(4, stu.getCourseID());
            ps.setString(5, stu.getCourseNature());
            ps.setString(6, stu.getCredit());
            ps.setString(7, stu.getCourseClass());
            ps.setString(8,stu.getCourseMajor());
            ps.setString(9,stu.getTestWay());
            ps.setString(10, stu.getTestData());
            ps.setString(11, stu.getTestCount());
            ps.setString(12, stu.getTestMethod());
            ps.setString(13, stu.getTestGrade());
            ps.setString(14, stu.getTestEvaluation());
            ps.setString(15, stu.getTestAnalysis());
            ps.executeUpdate();
        }catch(SQLException e) {
            e.printStackTrace();
        }finally{
            Tool.release(conn, null, null);
        }
         
    }
    public void del(String num) {//删除
        Connection connn=null;
        PreparedStatement preparedStatement=null;
        try {
            connn= Tool.getConnection();
            String sql="delete from biao where cid=?";
            preparedStatement=connn.prepareStatement(sql);
            preparedStatement.setString(1,num);
            preparedStatement.executeUpdate();
            } catch (SQLException e) {
                e.printStackTrace();
            }finally {
                Tool.release(connn,preparedStatement,null);
            }
    }
    public List<Card> findAll(){//浏览
        List<Card> list=new ArrayList<>();
        Connection connection=null;
        PreparedStatement preparedStatement=null;
        ResultSet resultSet=null;
        try {
            //调用Tool连接mysql数据库
            connection= Tool.getConnection();
            String sql="select * from biao";//查询语句
            preparedStatement=connection.prepareStatement(sql);
            resultSet = preparedStatement.executeQuery();
            while (resultSet.next()){
                //从resultSet拿出每个属性数据
            String cid=resultSet.getString("cid");
            String cname=resultSet.getString("cname");
            String time=resultSet.getString("cteacher");
            String couid=resultSet.getString("couid");
            String counat=resultSet.getString("counat");
            String credit=resultSet.getString("credit");
            String couclass=resultSet.getString("couclass");
            String coum=resultSet.getString("coum");
            String testway=resultSet.getString("testway");
            String testdata=resultSet.getString("testdata");
            String testcount=resultSet.getString("testcount");
            String testm=resultSet.getString("testm");
            String testgrade=resultSet.getString("testgrade");
            String testeva=resultSet.getString("testeva");
            String testa=resultSet.getString("testa");
               
            //String name,String bianhao, String time, String jieci, String xueyuan, String teanum, String teaname,
            //String renshu
                Card student = new Card(cid,null,cname,time,couid,counat,credit,couclass,coum,testway,testdata,testcount,testm,testgrade,testeva,testa,null,null,null,null,null);
                list.add(student);//可能多条数据，放到集合中
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            //调用JDBCTools，关闭connection，preparedStatement，resultSet
            Tool.release(connection,preparedStatement,resultSet);
        }
        return list;
    }
    public Card finds(String num) {//查询
    Connection conn=Tool.getConnection();
    PreparedStatement pre=null;
    ResultSet resultSet=null;
    Card stu=null;
    String sql="SELECT *FROM biao where cid=? ";
    try {
    pre=conn.prepareStatement(sql);
    pre.setString(1, num);
    resultSet=pre.executeQuery();
    while(resultSet.next()) {
        String cid=resultSet.getString("cid");
            String cname=resultSet.getString("cname");
            String time=resultSet.getString("cteacher");
            String couid=resultSet.getString("couid");
            String counat=resultSet.getString("counat");
            String credit=resultSet.getString("credit");
            String couclass=resultSet.getString("couclass");
            String coum=resultSet.getString("coum");
            String testway=resultSet.getString("testway");
            String testdata=resultSet.getString("testdata");
            String testcount=resultSet.getString("testcount");
            String testm=resultSet.getString("testm");
            String testgrade=resultSet.getString("testgrade");
            String testeva=resultSet.getString("testeva");
            String testa=resultSet.getString("testa");
             stu = new Card(cid,null,cname,time,couid,counat,credit,couclass,coum,testway,testdata,testcount,testm,testgrade,testeva,testa,null,null,null,null,null);
    }
    }
catch(SQLException e) {
         
        e.printStackTrace();
    }finally{
        Tool.release(conn, pre, resultSet);
    }
    return stu;
}
    public void Up(String cid,String kname,String teachername,String kenum,String xingzhi,String xuefen,String ban,String zhuanye,String fangshi,String time,String ren,String mingti,String zucheng,String kf,String fenxi ) {//修改
    Connection connn=null;
    PreparedStatement preparedStatement=null;
    try {
        connn=Tool.getConnection();
        String sql="update biao set cname=?,cteacher=?,couid=?,counat=?,credit=?,couclass=?,coum=?,testway=?,testdata=?,testcount=?,testm=?,testgrade=?,testeva=?,testa=? where cid=?";
        preparedStatement=connn.prepareStatement(sql);
        preparedStatement.setString(1,kname);
        preparedStatement.setString(2,teachername);
        preparedStatement.setString(3,kenum);
        preparedStatement.setString(4,xingzhi);
        preparedStatement.setString(5,xuefen);
        preparedStatement.setString(6,ban);
         preparedStatement.setString(7,zhuanye);
        preparedStatement.setString(8,fangshi);
        preparedStatement.setString(9,time);
        preparedStatement.setString(10,ren);
        preparedStatement.setString(11,mingti);
        preparedStatement.setString(12,zucheng);
         preparedStatement.setString(13,kf);
        preparedStatement.setString(14,fenxi);
        preparedStatement.setString(15,cid);
        preparedStatement.executeUpdate();
    }
    catch(SQLException e) {
        e.printStackTrace();
    } finally {
        Tool.release(connn,preparedStatement,null);
    }
}
    public String  find(String name,String kclass,String zhuanye) {//查询
        Connection conn=Tool.getConnection();
        PreparedStatement pre=null;
        ResultSet resultSet=null;
        String stu=null;
            if(name!=null&&kclass!=null&&zhuanye!=null) {
                try {
                String sql="SELECT *FROM biao where cname=? and couclass=? and coum=?";
        pre=conn.prepareStatement(sql);
        pre.setString(1, name);
        pre.setString(2, kclass);
        pre.setString(3, zhuanye);
        resultSet=pre.executeQuery();
        while(resultSet.next()) {
            String cid=resultSet.getString("cid");
                String cname=resultSet.getString("cname");
                String couclass=resultSet.getString("couclass");
                String coum=resultSet.getString("coum");
                     stu="编号:"+cid+" 课程名称:"+cname+" 授课班级:"+couclass+" 授课专业:"+coum;
        }
                }
                catch(SQLException e) {
                     
                    e.printStackTrace();
                }finally{
                    Tool.release(conn, pre, resultSet);
                }
        }else if(name==null&&kclass!=null&&zhuanye!=null) {
            try {
            String sql="SELECT *FROM biao where couclass=? and coum=?";
            pre=conn.prepareStatement(sql);
            pre.setString(1, kclass);
            pre.setString(2, zhuanye);
            resultSet=pre.executeQuery();
            while(resultSet.next()) {
                String cid=resultSet.getString("cid");
                    String cname=resultSet.getString("cname");
                    String couclass=resultSet.getString("couclass");
                    String coum=resultSet.getString("coum");
                         stu="编号:"+cid+" 课程名称:"+cname+" 授课班级:"+couclass+" 授课专业:"+coum;
            }
            }   catch(SQLException e) {
                 
                e.printStackTrace();
            }finally{
                Tool.release(conn, pre, resultSet);
            }
        }else if(name==null&&kclass!=null&&zhuanye==null) {
            try {
            String sql="SELECT *FROM biao where couclass=?";
            pre=conn.prepareStatement(sql);
            pre.setString(1, kclass);
            resultSet=pre.executeQuery();
            while(resultSet.next()) {
                String cid=resultSet.getString("cid");
                    String cname=resultSet.getString("cname");
                    String couclass=resultSet.getString("couclass");
                    String coum=resultSet.getString("coum");
                         stu="编号:"+cid+" 课程名称:"+cname+" 授课班级:"+couclass+" 授课专业:"+coum;
            }
            }   catch(SQLException e) {
                 
                e.printStackTrace();
            }finally{
                Tool.release(conn, pre, resultSet);
            }
        }else if(name==null&&kclass==null&&zhuanye!=null) {
            try {
            String sql="SELECT *FROM biao where coum=?";
            pre=conn.prepareStatement(sql);
            pre.setString(1,zhuanye);
            resultSet=pre.executeQuery();
            while(resultSet.next()) {
                String cid=resultSet.getString("cid");
                    String cname=resultSet.getString("cname");
                    String couclass=resultSet.getString("couclass");
                    String coum=resultSet.getString("coum");
                         stu="编号:"+cid+" 课程名称:"+cname+" 授课班级:"+couclass+" 授课专业:"+coum;
            }}  catch(SQLException e) {
                 
                e.printStackTrace();
            }finally{
                Tool.release(conn, pre, resultSet);
            }
        }else if(name!=null&&kclass==null&&zhuanye!=null) {
            try {
            String sql="SELECT *FROM biao where cname=? and coum=?";
            pre=conn.prepareStatement(sql);
            pre.setString(1, name);
            pre.setString(2, zhuanye);
            resultSet=pre.executeQuery();
            while(resultSet.next()) {
                String cid=resultSet.getString("cid");
                    String cname=resultSet.getString("cname");
                    String couclass=resultSet.getString("couclass");
                    String coum=resultSet.getString("coum");
                         stu="编号:"+cid+" 课程名称:"+cname+" 授课班级:"+couclass+" 授课专业:"+coum;
            }
            }   catch(SQLException e) {
                 
                e.printStackTrace();
            }finally{
                Tool.release(conn, pre, resultSet);
            }
        }else if(name!=null&&kclass==null&&zhuanye==null) {
            try {
            String sql="SELECT *FROM biao where cname=? ";
            pre=conn.prepareStatement(sql);
            pre.setString(1, name);
            resultSet=pre.executeQuery();
            while(resultSet.next()) {
                String cid=resultSet.getString("cid");
                    String cname=resultSet.getString("cname");
                    String couclass=resultSet.getString("couclass");
                    String coum=resultSet.getString("coum");
                         stu="编号:"+cid+" 课程名称:"+cname+" 授课班级:"+couclass+" 授课专业:"+coum;
            }
            }   catch(SQLException e) {
                 
                e.printStackTrace();
            }finally{
                Tool.release(conn, pre, resultSet);
            }
        }else {
            try {
            String sql="SELECT *FROM biao where cname=? and kclass=?";
            pre=conn.prepareStatement(sql);
            pre.setString(1, name);
            pre.setString(2, kclass);
            resultSet=pre.executeQuery();
            while(resultSet.next()) {
                String cid=resultSet.getString("cid");
                    String cname=resultSet.getString("cname");
                    String couclass=resultSet.getString("couclass");
                    String coum=resultSet.getString("coum");
                         stu="编号:"+cid+" 课程名称:"+cname+" 授课班级:"+couclass+" 授课专业:"+coum;
            }
        }
    catch(SQLException e) {
             
            e.printStackTrace();
        }finally{
            Tool.release(conn, pre, resultSet);
        }
        }
        return stu;
         
    }
}

　　Kasev类：

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
import java.io.IOException;
import java.util.List;
import passage.Card;
import passage.Student;
import passage.Card;
import jakarta.servlet.ServletException;
import jakarta.servlet.annotation.WebServlet;
import jakarta.servlet.http.HttpServlet;
import jakarta.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;
@WebServlet("/ka")
public class Kasev extends HttpServlet{
    Ka d=new Ka();
    public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{
        String method=request.getParameter("method");
        if (method==null){
            method="findall";
        }
        switch (method){
        case "add":
            String cid= request.getParameter("num");
            String kname=request.getParameter("kname");
            String teachername=request.getParameter("teachername");
            String kenum=request.getParameter("kenum");
            String xingzhi=request.getParameter("xingzhi");
            String xuefen=request.getParameter("xuefen");
            String ban=request.getParameter("ban");
            String zhuanye=request.getParameter("zhuanye");
            String fangshi=request.getParameter("fangshi");
            String time=request.getParameter("time");
            String ren=request.getParameter("ren");
            String mingti=request.getParameter("mingti");
            String zucheng=request.getParameter("zucheng");
            String kf=request.getParameter("kf");
            String fenxi=request.getParameter("fenxi");
            Card c=new Card(cid,null,kname,teachername,kenum,xingzhi,xuefen,ban,zhuanye,fangshi,time,ren,mingti,zucheng,kf,fenxi,null,null,null,null,null);
            d.add(c);
            request.setAttribute("test", "添加并且保存成功");
            request.getRequestDispatcher("xts.jsp").forward(request, response);
            break;
        case "delete":
            String num2=request.getParameter("num");
            d.del(num2);
            request.setAttribute("test", "删除成功");
            request.getRequestDispatcher("xts.jsp").forward(request, response);
            break;
        case "findall":
             List<Card> list = d.findAll();
                request.setAttribute("test", list);
                request.getRequestDispatcher("mmesss.jsp").forward(request, response);
                break;
        case "findalls":
             List<Card> lists = d.findAll();
                request.setAttribute("test", lists);
                request.getRequestDispatcher("ll.jsp").forward(request, response);
                break;
        case "findByid":String num3=request.getParameter("num");
            Card s=d.finds(num3);
            request.setAttribute("test", s);
            request.getRequestDispatcher("updatec.jsp").forward(request, response);
            break;
        case "findByids":
            String knames= request.getParameter("kname");
            String keclass=request.getParameter("keclass");
            String zhuanyes=request.getParameter("zhuanye");
            String res=d.find(knames, keclass, zhuanyes);
            request.setAttribute("test", res);
            request.getRequestDispatcher("xts.jsp").forward(request, response);
            break;
        case "up":
            String cid1= request.getParameter("num");
            String kname1=request.getParameter("kname");
            String teachername1=request.getParameter("teachername");
            String kenum1=request.getParameter("kenum");
            String xingzhi1=request.getParameter("xingzhi");
            String xuefen1=request.getParameter("xuefen");
            String ban1=request.getParameter("ban");
            String zhuanye1=request.getParameter("zhuanye");
            String fangshi1=request.getParameter("fangshi");
            String time1=request.getParameter("time");
            String ren1=request.getParameter("ren");
            String mingti1=request.getParameter("mingti");
            String zucheng1=request.getParameter("zucheng");
            String kf1=request.getParameter("kf");
            String fenxi1=request.getParameter("fenxi");
            d.Up(cid1,kname1,teachername1,kenum1,xingzhi1,xuefen1,ban1,zhuanye1,fangshi1,time1,ren1,mingti1,zucheng1,kf1,fenxi1);
            request.setAttribute("test", "修改成功");
            request.getRequestDispatcher("xts.jsp").forward(request, response);
            break;
        }
        }
    @Override
    public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{
        doPost(request,response);
}
}

　　zhuanjiao.jsp

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
<%@ 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>
<title>Insert title here</title>
</head>
<body>
<center>
<p><a href="addk.jsp">新增试卷审批卡</a>
    </p>
<p><a href="ka?method=findall">修改或删除试卷审批卡</a>
    </p>
    <p><a href="ka?method=findalls">浏览试卷审批卡信息</a>
    </p>
    <p><a href="find.jsp">查询考试信息</a>
    </p>
    </center>
</body>
</html>

　　addk.jsp

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
<%@ 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>
<title>Insert title here</title>
</head>
<body>
 <form action="ka" method="post">
<center>
<p>试卷编号
              <input type="text" name="num"/>
              </p>
<p>课程名称
              <input type="text" name="kname"/>
              </p>
              <p>任课教师
              <input type="text" name="teachername"/>
              </p>
              <p>课程代码
              <input type="text" name="kenum"/>
              </p>
              <p>课程性质：
                <input type="radio" name="xingzhi" value="必修" checked/>必修
                <input type="radio" name="xingzhi" value="选修"/>必修
              </p>
              <p>学分
              <input type="text" name="xuefen"/>
              </p>
              <p>授课班级
              <input type="text" name="ban"/>
              </p>
              <p>授课专业
              <input type="text" name="zhuanye"/>
              </p>
              <p>考试方式：
                <input type="radio" name="fangshi" value="闭卷" checked/>闭卷
                <input type="radio" name="fangshi" value="开卷"/>开卷
                <input type="radio" name="fangshi" value="其他"/>其他
              </p>
              <p>考试时间
              <input type="text" name="time"/>
              </p>
              <p>考试人数
              <input type="text" name="ren"/>
              </p>
              <p>命题方式
              <input type="text" name="mingti"/>
              </p>
              <p>成绩组成
              <input type="text" name="zucheng"/>
              
              </p>
              <p>考核与评价方式
              <input type="text" name="kf"/>
              </p>
              <p>考核内容合理性分析
              <input type="text" name="fenxi"/>
              </p>
              <input type="hidden" name="method" value="add"/>
              <p>
        <input type="submit" value="提交">
        </p>
</center>
</form>
</body>
</html>

　　xts.jsp

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
<%@ 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>
<title>Insert title here</title>
</head>
<body>
<center>
<%=request.getAttribute("test")%>
 
        </p>
        </center>
        </form>
</body>
</html>

　　mmesss.jsp

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
<%@ page language="java" contentType="text/html; charset=UTF-8"
 
    pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
 
<html>
 
<head>
<title>Insert title here</title>
</head>
<body>
<center>
<c:forEach items="${test}" var="list">
<tr>
<td>${list.getCardId()}</td>
<td>${list.getCourseName()}</td>
<td>${list.getCourseTeacher()}</td>
<td>${list.getCourseID()}</td>
<td>${list.getCourseNature()}</td>
<td>${list.getCredit()}</td>
<td>${list.getCourseClass()}</td>
<td>${list.getCourseMajor()}</td>
<td>${list.getTestWay()}</td>
<td>${list.getTestData()}</td>
<td>${list.getTestCount()}</td>
<td>${list.getTestMethod()}</td>
<td>${list.getTestGrade()}</td>
<td>${list.getTestEvaluation()}</td>
<td>${list.getTestAnalysis()}</td>
<td>
<td>
          <a href="ka?method=delete&num=${list.getCardId()}">删除</a>
        <a href="ka?method=findByid&num=${list.getCardId()}">修改</a>
        </td>
        <br></br>
</tr>
</c:forEach>
</center>
</body>
</html>

　　ll.jsp

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
<%@ page language="java" contentType="text/html; charset=UTF-8"
 
    pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
 
<html>
 
<head>
<title>Insert title here</title>
</head>
<body>
<center>
<c:forEach items="${test}" var="list">
<tr>
<td>${list.getCardId()}</td>
<td>${list.getCourseName()}</td>
<td>${list.getCourseTeacher()}</td>
<td>${list.getCourseID()}</td>
<td>${list.getCourseNature()}</td>
<td>${list.getCredit()}</td>
<td>${list.getCourseClass()}</td>
<td>${list.getCourseMajor()}</td>
<td>${list.getTestWay()}</td>
<td>${list.getTestData()}</td>
<td>${list.getTestCount()}</td>
<td>${list.getTestMethod()}</td>
<td>${list.getTestGrade()}</td>
<td>${list.getTestEvaluation()}</td>
<td>${list.getTestAnalysis()}</td>
<td>
<td>
        </td>
        <br></br>
</tr>
</c:forEach>
</center>
</body>
</html>

　　updatec.jsp

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
<%@ 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>
    <title>Title</title>
</head>
<body>
<center>
<form action="ka" method="post">
    试卷编号: <input type="text" name="num" value="${test.getCardId()}" readonly/><br/>
    课程名称：<input type="text" name="kname" value="${test.getCourseName()}"/><br/>
    任课教师：<input type="text" name="teachername" value="${test.getCourseTeacher()}"/><br/>
    课程代码：<input type="text" name="kenum" value="${test.getCourseID()}"/><br/>
    课程性质：<input type="text" name="xingzhi" value="${test.getCourseNature()}"/><br/>
    学分：<input type="text" name="xuefen" value="${test.getCredit()}"/><br/>
    授课班级：<input type="text" name="ban" value="${test.getCourseClass()}"/><br/>
    授课专业：<input type="text" name="zhuanye" value="${test.getCourseMajor()}"/><br/>
    考试方式：<input type="text" name="fangshi" value="${test.getTestWay()}"/><br/>
    考试时间：<input type="text" name="time" value="${test.getTestData()}"/><br/>
    考试人数：<input type="text" name="ren" value="${test.getTestCount()}"/><br/>
    命题方式：<input type="text" name="mingti" value="${test.getTestMethod()}"/><br/>
    成绩组成：<input type="text" name="zucheng" value="${test.getTestGrade()}"/><br/>
    考核与评价方式：<input type="text" name="kf" value="${test.getTestEvaluation()}"/><br/>
    考核内容合理性分析：<input type="text" name="fenxi" value="${test.getTestAnalysis()}"/><br/>
    <input type="hidden" name="method" value="up"/>
    <input type="submit" value="修改"/>
</form>
</center>
</body>
</html>

　　最后，查询的综合查询不够完善，浏览信息未达到要求。

posted @   一个小虎牙  阅读(26)  评论(0)  编辑  收藏  举报
相关博文：
· 开学小测总结（下）
· 考试基础类定义
· 2.24博客
· 开学考试——数据库增删改查实现
· 南昌航空大学软件学院pta第三阶段总结22201116-廖振波
阅读排行：
· 无需6万激活码！GitHub神秘组织3小时极速复刻Manus，手把手教你使用OpenManus搭建本
· Manus爆火，是硬核还是营销？
· 终于写完轮子一部分：tcp代理 了，记录一下
· 别再用vector＜bool＞了！Google高级工程师：这可能是STL最大的设计失误
· 单元测试从入门到精通
点击右上角即可分享
微信分享提示