📄 y2.jsp~2~

📁 JAVA实验图形 =各种的 JAVA简单代码出初学者必备！！！！！！！！！

💻 JSP~2~

字号:

<%@ 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 sql="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:" + sql);            ResultSet g = stmt.executeQuery(sql);           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="images/1.bmp" width="<%=Math.floor(vnum*200/totnum)%>" height="10"> <%=Math.floor(vnum*100/totnum)%>% [得：<%=vnum%>票 共：<%=totnum%>票]</td></tr><%i++;}%><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 + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -