index.jsp

来自「利用java做选择程序」· JSP 代码 · 共 36 行

JSP
36
字号
<%@page contentType="text/html;charset=GBK" %><%--引入数据库操作类型--%><%@page import="java.sql.*"%><html><head><title>查询记录示例</title></head><body><jsp:useBean id="dataBean" class="data.DataODBC"/><center><h3>查询记录示例</h3><%Connection conn=dataBean.getConn();Statement stmt=conn.createStatement();ResultSet rs;String selectStr="Select * from f_zd_state";try{    rs=stmt.executeQuery(selectStr);    out.println("<p>查询结果如下所示:</p>");    while(rs.next())        {            out.println("<p>");            out.println("code=" + rs.getString("code") + "   ");            out.println("context=" + rs.getString("name") + "    ");            out.println("</p>");    }    }   catch(Exception ex){    out.println("<p>查询记录失败</p>");    ex.printStackTrace();        }%></center></body></html>

⌨️ 快捷键说明

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