四月二十一日

今天所完成的代码团队项目教师管理的内容。

复制代码
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@page import="com.util.DBUtil" %>
<%@page import="com.dao.Dao" %>
    <%@ page import="java.sql.Connection"%> 
    <%@ page import="java.sql.PreparedStatement"%> 
<%@ page import="java.sql.SQLException"%> 
<%@ page import="java.sql.Statement"%> 
<%@ page import="java.sql.ResultSet"%> 
<html>
<head>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>在此处插入标题</title>
</head>
<body>
<form action="addpingjia1.jsp" method="get">
<table align="center" border="1" width="500">
<tr>
        <td>队名</td>
        <td><input type="text" name="name"  size = "40"/></td>

</tr>
<tr>
        <td>教师评价</td>
        <td><input type="text" name="jiaoshipingjia"  size = "40"/></td>

</tr>
<tr align="center">
                <td colspan="2"><input type="submit" value="提交" /></td>
            </tr>
            <input type="button" value="返回" onclick="location.href='liulan1.jsp'" /></br>
</body>
</html>
复制代码
复制代码
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@page import="com.util.DBUtil" %>
<%@page import="com.dao.Dao" %>
<html>
<head>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>在此处插入标题</title>
</head>
<body>
<% 
String name = request.getParameter("name");
String jiaoshipingjia = request.getParameter("jiaoshipingjia");
Dao.update1(jiaoshipingjia, name);
        %>
        <input type="button" value="返回" onclick="location.href='liulan1.jsp'" /></br>
</body>
</html>
复制代码
复制代码
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@ page language="java" contentType="text/html; charset=UTF-8"    pageEncoding="UTF-8"%>
<%@page import="com.util.DBUtil" %>
<%@page import="com.dao.Dao" %>
    <%@ page import="java.sql.Connection"%> 
    <%@ page import="java.sql.PreparedStatement"%> 
<%@ page import="java.sql.SQLException"%> 
<%@ page import="java.sql.Statement"%> 
<%@ page import="java.sql.ResultSet"%> 
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>在此处插入标题</title>
</head>
<body>
<a id="downLoad" href="javascript:void(0)">点击下载pdf</a>
<script src="https://cdnjs.cloudflare.com/ajax/libs/html2canvas/0.4.1/html2canvas.js"></script>
   <script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf/1.0.272/jspdf.debug.js"></script>
   <script type="text/javascript">
      var downPdf = document.getElementById("downLoad");
 
      downPdf.onclick = function() {
          downPdf.parentNode.removeChild(downPdf);
          html2canvas(document.body, {
              onrendered:function(canvas) {
 
                  var contentWidth = canvas.width;
                  var contentHeight = canvas.height;
 
                  //一页pdf显示html页面生成的canvas高度;
                  var pageHeight = contentWidth / 595.28*841.89;
                  //未生成pdf的html页面高度
                  var leftHeight = contentHeight;
                  //pdf页面偏移
                  var position = 0;
                  //a4纸的尺寸[595.28,841.89]，html页面生成的canvas在pdf中图片的宽高
                  var imgWidth = 595.28;
                  var imgHeight = 595.28/contentWidth * contentHeight;
 
                  var pageData = canvas.toDataURL('image/jpeg', 1.0);
 
                  var pdf = new jsPDF('', 'pt', 'a4');
 
                  //有两个高度需要区分，一个是html页面的实际高度，和生成pdf的页面高度(841.89)
                  //当内容未超过pdf一页显示的范围，无需分页
                  if (leftHeight < pageHeight) {
                      pdf.addImage(pageData, 'JPEG', 0, 0, imgWidth, imgHeight );
                  } else {
                      while(leftHeight > 0) {
                          pdf.addImage(pageData, 'JPEG', 0, position, imgWidth, imgHeight)
                          leftHeight -= pageHeight;
                          position -= 841.89;
                          //避免添加空白页
                          if(leftHeight > 0) {
                              pdf.addPage();
                          }
                      }
                  }
 
                  pdf.save('content.pdf');
              }
          })
      }
    </script>
<h1></h1>
<jsp:useBean id="util" class="com.util.DBUtil" scope="page" />
<table border="1"style="text-align:center;"width = "1400">
             <tr>
            <td align="center" >队名</td>
            <td align="center" >参赛人员</td>
            <td align="center" >参赛人数</td>
            <td align="center" >选题</td>
            <td align="center" >教师评价</td>
            <td align="center" >评分</td>
            <td align="center" >名次</td>
            </tr>
<%
Connection connection = DBUtil.getConn();
PreparedStatement ps = null;
try {
    String sql = "SELECT * FROM m5 ";
    ps = connection.prepareStatement(sql);
    ResultSet rs = ps.executeQuery();//要用statement类的executeQuery()方法来下达select指令以查询数据库，executeQuery()方法会把数据库响应的查询结果存放在ResultSet类对象中供我们使用。即语句：ResultSet rs=s.executeQuery(sql);
    while(rs.next()){
%>
             <tr>
            <td><%=(rs.getString("队名")) %></td>
            <td><%=(rs.getString("参赛人员")) %></td>
            <td><%=(rs.getString("参赛人数")) %></td>
            <td><%=(rs.getString("选题")) %></td>
            <td><%=(rs.getString("教师评价")) %></td>
            <td><%=(rs.getString("小组评分")) %></td>
            <td><%=(rs.getString("名次")) %></td>
            </tr>    
            
<%
            }
        } catch (Exception e) {
            out.println(e);
        }
    %>
</body>
</html>
复制代码

 

posted @   布吉岛？？？  阅读(18)  评论(0)  编辑  收藏  举报
相关博文：
· 四月二十三日
· 四月十一日
· 23.4.20每日总结
· 团队作业4——项目冲刺-6
· 没有队名-第五次作业
阅读排行：
· 【自荐】一款简洁、开源的在线白板工具 Drawnix
· 没有Manus邀请码？试试免邀请码的MGX或者开源的OpenManus吧
· 无需6万激活码！GitHub神秘组织3小时极速复刻Manus，手把手教你使用OpenManus搭建本
· C#/.NET/.NET Core优秀项目和框架2025年2月简报
· DeepSeek在M芯片Mac上本地化部署
点击右上角即可分享
微信分享提示