四月二十一日
今天所完成的代码团队项目教师管理的内容。
<!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>
