package com.bjpowernode.javaweb.servlet;
import com.bjpowernode.javaweb.utils.DButil;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;
@WebServlet(name = "edit",value = "/edit")
public class Edit extends HttpServlet {
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String contextPath = request.getContextPath();
response.setContentType("text/html;charset=UTF-8");
request.setCharacterEncoding("UTF-8");
PrintWriter out =response.getWriter();
//jsp文档
out.println("<html lang='en'>");
out.println("<head>");
out.println(" <meta charset='UTF-8'>");
out.println(" <link href='h/favicon2.ico' rel='icon' type='image/x-icon'/>");
out.println(" <title>添加信息</title>");
out.println(" <style>");
out.println(" body {");
out.println(" background-color:#FDF5E6;");
out.println(" }");
out.println(" </style>");
out.println(" <style>");
out.println(" body {");
out.println(" width: 100%;");
out.println(" height: 100%;");
out.println(" background: url('./img/olypic.jpg');");
out.println(" background-repeat: no-repeat;");
out.println(" background-size: 100% 100%;");
out.println(" background-attachment: fixed;");
out.println(" }");
out.println(" </style>");
out.println(" <style>");
out.println(" input{");
out.println(" width: 20%;");
out.println(" padding: 12px 20px;");
out.println(" margin: 8px 0;");
out.println(" box-sizing: border-box;");
out.println(" border: 1px solid #555;");
out.println(" outline: none;");
out.println(" }");
out.println("");
out.println(" input:focus {");
out.println(" background-color: lightblue;");
out.println(" }");
out.println(" </style>");
out.println(" <style>");
out.println(" #boxshadow {");
out.println(" position: relative;");
out.println(" -moz-box-shadow: 1px 2px 4px rgba(0, 0, 0,0.5);");
out.println(" -webkit-box-shadow: 1px 2px 4px rgba(0, 0, 0, .5);");
out.println(" box-shadow: 1px 2px 4px rgba(0, 0, 0, .5);");
out.println(" padding: 10px;");
out.println(" background:#F0F8FF;");
out.println(" border-radius:8px;");
out.println(" }");
out.println("");
out.println(" /* Make the image fit the box */");
out.println(" #boxshadow img {");
out.println(" width: 50%;");
out.println(" border: 0px solid #8a4419;");
out.println(" border-style: inset;");
out.println(" }");
out.println("");
out.println(" #boxshadow::after {");
out.println(" content: '';");
out.println(" position: absolute;");
out.println(" z-index: -1; /* hide shadow behind image */");
out.println(" -webkit-box-shadow: 0 15px 20px rgba(0, 0, 0, 0.3);");
out.println(" -moz-box-shadow: 0 15px 20px rgba(0, 0, 0, 0.3);");
out.println(" box-shadow: 0 15px 20px rgba(0, 0, 0, 0.3);");
out.println(" width: 70%;");
out.println(" left: 15%; /* one half of the remaining 30% */");
out.println(" height: 100px;");
out.println(" bottom: 0;");
out.println(" }");
out.println(" </style>");
out.println(" <style>");
out.println(" .button {");
out.println(" background-color:#337AB7; /* Green */");
out.println(" border: none;");
out.println(" color: white;");
out.println(" padding: 16px 32px;");
out.println(" text-align: center;");
out.println(" text-decoration: none;");
out.println(" display: inline-block;");
out.println(" font-size: 16px;");
out.println(" margin: 4px 2px;");
out.println(" -webkit-transition-duration: 0.4s; /* Safari */");
out.println(" transition-duration: 0.4s;");
out.println(" cursor: pointer;");
out.println(" }");
out.println("");
out.println(" .button1 {");
out.println(" background-color: white;");
out.println(" color: black;");
out.println(" border: 2px solid #337AB7;");
out.println(" }");
out.println(" .button1:hover {");
out.println(" background-color: #337AB7;");
out.println(" color: white;");
out.println(" box-shadow: 0 12px 16px 0 rgba(0,0,0,0.24),0 17px 50px 0 rgba(0,0,0,0.19);");
out.println(" }");
out.println(" </style>");
out.println("");
out.println("</head>");
out.println("<body>");
out.println("");
out.println("<div style='padding:2px;width:1080px;height:470px;margin-top:10%;margin-left:20%;opacity: 0.8' id='boxshadow'>");
out.println(" <div>");
out.println(" <img src='img/olypic.jpg' style='float:left;margin-top:5%;'>");
out.println(" </div>");
out.println(" <div style='float:right;'>");
out.println(" <form action='"+contextPath+"/update' method='post'>");
//获取国家名称
String country=request.getParameter("name");
//连接数据库
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs=null;
try {
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
//获取连接
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mofa", "root", "123456");
String sql = "select * from medals_table where Country=?";
//编译sql语句
ps = conn.prepareStatement(sql);
//赋值 第一个问好赋值 country 国家名称
ps.setString(1, country);
//查询返回结果集 这个结果集只有一条记录 ，国家名称是主键 ， 故只有一条数据
rs = ps.executeQuery();
if(rs.next()){
String logo=rs.getString("logo");
String Glod = rs.getString("Glod_num");
String Silver = rs.getString("Silver_num");
String Copper = rs.getString("Copper_num");
String sum=rs.getString("Sum");
String id=rs.getString("id");
System.out.println("你好，你好，你好，齐天大圣！！！");
//输出动态网页
out.println("<p style='margin-right:200px;'>");
out.println(" 国家名称   <input type='text' name='Country' value='"+country+"' style='border
JavaWeb项目,足够通过课程考核
5星 · 超过95%的资源 需积分: 5 49 浏览量
2022-03-22
13:22:11
上传
评论 14
收藏 15.05MB RAR 举报 
JavaWeb项目,足够通过课程考核 （166个子文件） 
Edit.class 9KB Edit.class 9KB Select.class 4KB Select.class 4KB Take_02.class 4KB Take_02.class 4KB Take_01.class 4KB Take_01.class 4KB Picture.class 4KB Take_03_text.class 4KB Picture.class 4KB Take_03_text.class 4KB Xiangqing.class 4KB Xiangqing.class 4KB CountOut.class 4KB CountOut.class 4KB OpenC.class 3KB OpenC.class 3KB Update.class 3KB Update.class 3KB Delete.class 3KB Delete.class 3KB Register.class 3KB Register.class 3KB Add.class 3KB Add.class 3KB OpenIn.class 3KB OpenIn.class 3KB Show.class 3KB Show.class 3KB Login.class 3KB Login.class 3KB Mysql.class 2KB Mysql.class 2KB Update.class 2KB Update.class 2KB Olypic.class 2KB Olypic.class 2KB DButil.class 2KB DButil.class 2KB Count.class 1KB Count.class 1KB Comment.class 881B Comment.class 881B .gitignore 184B
index.html 8KB index.html 8KB test.html 2KB test.html 2KB test.html 2KB servlet01.iml 4KB
mysql-connector-java-5.0.8-bin.jar 528KB standard.jar 384KB jstl.jar 20KB Edit.java 10KB Select.java 4KB Take_02.java 3KB Take_03_text.java 3KB Take_01.java 3KB Xiangqing.java 3KB Picture.java 3KB Login.java 3KB CountOut.java 3KB Add.java 3KB Register.java 3KB Delete.java 3KB OpenC.java 3KB Update.java 2KB OpenIn.java 2KB Test.java 2KB DButil.java 2KB Detals.java 2KB juquery.java 2KB Show.java 2KB Olypic.java 2KB Details.java 1KB Update.java 1KB Mysql.java 1KB Dept.java 1KB Person.java 1012B test.java 1008B Count.java 688B Comment.java 556B tsw.java 238B
water.jpg 116KB water.jpg 116KB 美国.jpg 48KB 美国.jpg 48KB olypic.jpg 45KB olypic.jpg 45KB 韩国.jpg 24KB 韩国.jpg 24KB Glod1.jpg 18KB Glod1.jpg 18KB Glod_2.jpg 13KB Glod_2.jpg 13KB 法国.jpg 12KB 法国.jpg 12KB 意大利.jpg 6KB 意大利.jpg 6KB共 166 条
- 1
- 2
评论5