📄 toupiao1.jsp.bak
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@page import="java.sql.*"%>
<%
String SQL = "SELECT * From tp_title ";
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException ce){
out.println(ce.getMessage());
}
try{
conn=DriverManager.getConnection("jdbc:odbc:toupiao");
stmt=conn.createStatement();
rs=stmt.executeQuery(SQL);
}
catch(SQLException e){
System.out.println(e.getMessage());
}
%>
<HTML>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>在线投票系统</title>
</head>
<BODY BGCOLOR="BEIGE">
<H1 ALIGN="CENTER">在线投票系统</H1>
<HR>
<FORM Action="toupiao2.jsp" Method="GET">
<%
String leixing = "";
String tihao = "";
while (rs.next())
{
tihao = rs.getString("id");
leixing= rs.getString("types");
out.print("<B>" + tihao + "." + rs.getString("title")+ "</B>");
out.print("<div>");
for (int i=1; i<5; i++)
{
if (leixing.equals("单选"))
{
out.print("<INPUT Type=Radio" + " Name="+ tihao+" Value=" + i +">" + (rs.getString("选项" + i)) + "<BR>");
}
else
{
out.print("<INPUT Type=CheckBox" + " Name="+ tihao+"No" +i+" Value=" + i +">" + (rs.getString("选项" + i)) + "<BR>");
}
}
out.print("</div>");
}
%>
<INPUT Type=Submit Value="投票">
</FORM>
<HR>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -