📄 quizeapplication.jsp
字号:
<%@ page import="java.sql.*" %><!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=UTF-8"><title>JSP Page</title></head><body><% String ans=" ";if(request.getParameter("correctAns")!=null){ ans=request.getParameter("correctAns").toString();}Connection conn = null;String driver = "com.mysql.jdbc.Driver";String url = "jdbc:mysql://192.168.10.211:3306/";String db = "amar";String user = "amar";String pass = "amar123";Statement st = null;ResultSet qrst;ResultSet rs = null;String id=request.getParameter("id");System.out.println("id:"+id);int i=1;String s,g;int count=0;try {Class.forName(driver);conn = DriverManager.getConnection(url+db,user,pass);st = conn.createStatement();//for(i=1;i<=2;i++)// {rs = st.executeQuery("select * from question_deatil");while(rs.next()) {%><br><br/><center><table border="1" width="500px" bgcolor="pink" cellspacing="0" cellpadding="0"> <tr> <td width="100%"><form name="form1"> <h2 align="center"><font color="red">Online Quize Application</font></h2><b>Select Correct Answer</b> <table border="0" width="500px" cellspacing="2" cellpadding="4"> <tr><td width="50%"> Question:</td><input type="hidden" name="correctAns" value="<%=rs.getString(7)%>" /><tr><td><%= rs.getString("quest") %></td></tr><tr><td>1: <input type="radio" name="a" value= "QA" /></td> <td><%= rs.getString("QA") %></td></tr> <tr><td>2: <input type="radio" name="a" value="QB" /></td><td><%= rs.getString("QB") %></td></tr><tr><td>3: <input type="radio" name="a" value="QC" /></td><td><%= rs.getString("QC") %> </td></tr><tr><td>4: <input type="radio" name="a" value="QD" /> </td><td> <%= rs.getString("QD") %> </td></tr><tr><td><center> <input type="submit" value="Submit" name="submit"></center></td></tr></table></form> </td> </tr></table></center></body><% g=request.getParameter("a");%><% if(g.equals(ans)){count++;out.println("Correct");}elseout.println("false");%><%}}// }catch (Exception ex) {ex.printStackTrace();%><%} finally {if (rs != null) rs.close();if (st != null) st.close();if (conn != null) conn.close();}out.println("Score="+count);%></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -