jsp投票系统

最新推荐文章于 2022-12-11 19:49:15 发布

温柔徐u.

最新推荐文章于 2022-12-11 19:49:15 发布

阅读量1.2k

点赞数 4

分类专栏： Java Web 文章标签：前端

本文链接：https://blog.csdn.net/XU_MENGQI/article/details/123631077

版权

Java 同时被 2 个专栏收录

14 篇文章 0 订阅

订阅专栏

Web

10 篇文章 0 订阅

订阅专栏

display.jsp

<%@ page language="java" import="java.sql.*" pageEncoding="UTF-8"%>
<html>
  <body>
  <style type="text/css">
     body{

    background-color:#ffdee0;

    font-family:黑体;
}

  </style>
  
  
  <table align="center">
  <caption>最美大学生在线投票</caption>
  <tr bgcolor="#ffa07">
  <td>编号</td>
  <td>姓名</td>
  <td>得票数</td>
  <td>投票</td>
  </tr>
  
  
   <% 
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/student??useUnicode=true&characterEncoding=UTF-8","root","123456");
         Statement stat=conn.createStatement();
   		String sql="select no,name,vote from xmq";
   		ResultSet rs=stat.executeQuery(sql);
   		while(rs.next()){
   		String no=rs.getString("no");
   		String name=rs.getString("name");
   		int vote=rs.getInt("vote");
   		%>
    <tr bgcolor="#ffdea">
  <td><%=no%></td>
  <td><%=name%></td>
  <td><img src="img/jk.jpg" width="<%=vote%>" height="10"><%=vote %></td>
  <td><a href="vote.jsp?no=<%=no %>">投票</a></td>
  </tr>
  <% 
  }
  stat.close();
  conn.close();
  %>
    </table>
  </body>
</html>

vote.jsp

<%@ page language="java" import="java.sql.*" pageEncoding="UTF-8"%>
<html>
  <body>
   <%
   		String no=request.getParameter("no");
   		
   		Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/student??useUnicode=true&characterEncoding=UTF-8","root","123456");
                                		
   		
   		String sql="update xmq set vote=vote+1 where no=?";
   		//PreparedStatement是Statement的子接口语句的组织变量不依赖变量不容意出错
   		PreparedStatement ps=conn.prepareStatement(sql);
   		ps.setString(1, no);
   		ps.executeLargeUpdate();
   		ps.close();
   		conn.close();
    %>
    <jsp:forward page="display.jsp"></jsp:forward>
  </body>
</html>

温柔徐u.

关注

4
点赞
踩
6

收藏

觉得还不错? 一键收藏
1
评论
jsp投票系统

display.jsp<%@ page language="java" import="java.sql.*" pageEncoding="UTF-8"%><html> <body> <style type="text/css"> body{ background-color:#ffdee0; font-family:黑体;} </style> <table align=.
复制链接

扫一扫