📄 selectform.jsp

📁 jsp动态网站开发与实例（第3版）源码

💻 JSP

字号:

<%@page contentType="text/html"%><%@page pageEncoding="GB2312"%><%@page import = "java.sql.*"%><html>    <head><title>成绩查询主页面</title></head>    <body>        <form action="resultForm.jsp" method="post">        <%        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");        Connection con =                 DriverManager.getConnection("jdbc:odbc:webData");        Statement smt =  con.createStatement();        String sql = "SELECT Name from grades";        ResultSet rs = smt.executeQuery(sql);        out.println("<select size='1' name = 'name'>");        while(rs.next())            out.println("<option>" + rs.getString(1));            out.println("</select>");            con.close();        %>                <input type="submit" value="查询成绩"></form>    </body></html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -