📄 vote.jsp

📁 可以让初学者有一个感性的认识

💻 JSP

字号:

<HTML>
<%@page contentType="text/html;charset=GB2312"%>
<%@page import="java.sql.*" %>

<BODY bgcolor=cyan><Font size=3>

<%	StringBuffer nameList=new StringBuffer();	
	Connection con;
	Statement sql;
	ResultSet rs;

	try
	{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	}catch(ClassNotFoundException e){out.print(e);}
	try
	{
		con=DriverManager.getConnection("jdbc:odbc:vote","","");
		sql=con.createStatement();
		rs=sql.executeQuery("SELECT * FROM people");
		nameList.append("<FORM action=startvote.jsp method=post>");
			nameList.append("<Table border>");
			nameList.append("<TR>");	
				nameList.append("<TH width=100>"+"姓名");
				nameList.append("<TH width=50>"+"投票选择");
			nameList.append("</TR>");
			while(rs.next())
			{
				nameList.append("<TR>");
					String name=rs.getString(1);
					nameList.append("<TD>"+name+"</TD>");
					String s="<INPUT type=radio name=name value="+name+">";
					nameList.append("<TD>"+s+"</TD>");
				nameList.append("</TR>");
			}
			nameList.append("</Table>");
			nameList.append("<INPUT type=submit value=提交>");
		nameList.append("</FORM>");
		con.close();
		out.print(nameList);
	} catch(SQLException e1){ }
%>

</FONT>
</BODY>
</HTML>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -