resultform.jsp

来自「jsp动态网站开发与实例(第3版) 源码」· JSP 代码 · 共 24 行

JSP
24
字号
<%@page contentType="text/html"%><%@page pageEncoding="GB2312"%><%@page import = "java.sql.*"%><html>    <head><title>成绩查询结果</title></head>    <body>    <%        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");        Connection con =                 DriverManager.getConnection("jdbc:odbc:webData");        Statement smt =  con.createStatement();        String name =                new String(request.getParameter("name").getBytes("ISO-8859-1"));        String sql = "select * from grades where Name ='" + name + "'";        String color;        ResultSet rs = smt.executeQuery(sql);        rs.next();    %>                                                                            <font color="blue" size="5"><%=rs.getString(2)%>的成绩如下:</font><p>语文:<%=rs.getString(3)%><br>英语:<%=rs.getString(4)%><br>数学:<%=rs.getString(5)%><p>        </body></html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?