📄 ex5_14.jsp

📁 黑魔方JSP基础教程源代码(耿祥义编著)是这里有课件和jsp源代码

💻 JSP

字号:

<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<HTML>
<BODY>
 <%  StringBuffer nameList=new StringBuffer();
      Connection con;
      Statement sql; 
      ResultSet rs;
      String  driv="com.microsoft.jdbc.sqlserver.SQLServerDriver";
      String url1= "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=vote";
      try{Class.forName(driv);
        }
      catch(ClassNotFoundException e){out.println(e.toString());}
      try{ con=DriverManager.getConnection(url1,"sa","123");
          sql=con.createStatement();
          rs=sql.executeQuery("SELECT * FROM people");
          nameList.append("<FORM action=startvote.jsp  Method=post>");
          nameList.append("<Table Border>");
          nameList.append("<Table Border>");
          nameList.append("<TR>");

          nameList.append("<TH width=150>"+"投票选择");
          nameList.append("</TR>");
          while(rs.next())
             { nameList.append("<TR>");
               String name=rs.getString(1);

               String s="<Input type=radio name=name value="+name+" >"+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) {out.println(e1.toString());}
%>
</BODY>
</HTML>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -