y2.jsp~3~

来自「JAVA实验图形 =各种 的 JAVA简单代码 出初学者必备!!!!!!!!!」· JSP~3~ 代码 · 共 97 行

JSP~3~
97
字号
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %><html><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><title>查看投票结果</title></head><link rel="stylesheet" type="text/css" href="css/css.css"><body><%!int totnum;%><%Statement stmt=null;        PreparedStatement pstmt=null;  String sql="select sum(vnum) as totnum from vote";        //加载JDBC-ODBC桥驱动        try {            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");            //定义JDBC URL        }catch (Exception e) {        out.println(e.getMessage());        }          try{        String url = "jdbc:odbc:s";            //得到与数据库的连接            Connection con = DriverManager.getConnection(url);            //显示UPL和连接信息            System.out.print("URL:" + url);            System.out.print("Connection:" + con);            //得到一个Statement对象            stmt = con.createStatement();            //执行SQL语句            System.out.print("SQL:" + sql);            ResultSet p = stmt.executeQuery(sql);%><table width="100%" cellpadding="0" cellspacing="1" align="center"><tr bgcolor="#99ccff"><td align="center">序 号</td><td align="center">选 项</td><td align="center">投 票 率</td></tr><%while(p.next()){  totnum = p.getInt("totnum");} } catch (Exception e) {} %> <%  String ssql="select * from vote";        //加载JDBC-ODBC桥驱动        try {            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");            //定义JDBC URL        }catch (Exception e) {        out.println(e.getMessage());        }          try{        String url = "jdbc:odbc:s";            //得到与数据库的连接            Connection con = DriverManager.getConnection(url);            //显示UPL和连接信息            System.out.print("URL:" + url);            System.out.print("Connection:" + con);            //得到一个Statement对象            stmt = con.createStatement();            //执行SQL语句            System.out.print("SQL:" + ssql);            ResultSet g = stmt.executeQuery(ssql);           int i=1;while(g.next()){int vnum = g.getInt("vnum");%><tr><td height="22" align="center">[<%=i%>]</td><td height="27" align="center"><%=g.getString("vname")%></td><td>投票率:<img src="1.bmp" width="<%=Math.floor(vnum*200/totnum)%>" height="10"> <%=Math.floor(vnum*100/totnum)%>% [得:<%=vnum%>票 共:<%=totnum%>票]</td></tr><%i++;} } catch (Exception e) {}%><tr bgcolor="#99ccff"><td colspan="3" height="18" align="center">[<a href="y1.jsp">返回投票页</a>]</td></tr></table></body></html>

⌨️ 快捷键说明

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