weiyong
/
201906G202


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168
							package org.lsy.servlet; 
  
import java.io.IOException; 
import java.io.PrintWriter; 
import java.sql.Connection; 
import java.sql.DriverManager; 
import java.sql.ResultSet; 
import java.sql.Statement; 
  
import javax.servlet.ServletException; 
import javax.servlet.http.HttpServlet; 
import javax.servlet.http.HttpServletRequest; 
import javax.servlet.http.HttpServletResponse; 
  
public class onlyCheck extends HttpServlet 
{ 
  

	  public static final String DBURL = "jdbc:mysql://localhost:3306/kui"; 
	  // 连接数据库的用户名 
	  public static final String DBUSER = "root"; 
	  // 连接数据库的密码 
	  public static final String DBPASS = "001011"; 
  
  
  public void doGet(HttpServletRequest request, HttpServletResponse response) 
	      throws ServletException, IOException 
	  { 
	    //设置请求和响应的编码 ，不然页面上容易出现乱码 
	    request.setCharacterEncoding("UTF-8"); 
	    response.setCharacterEncoding("UTF-8");  
	    
	    response.setContentType("text/html;UTF-8"); 
	    //输出流 
	    PrintWriter out = response.getWriter(); 
	    //数据库连接代码 
	    try
	    { 
	    	
	      Connection conn = null; // 表示数据库的连接的对象 
	      Statement stmt = null; // 表示数据库的更新操作 
	      String sql="insert into student(name,calssGrent,result) values('PS的4','3的3',' 发98')"; 
	      System.out.println(sql) ; 
	      // 1、使用Class类加载驱动程序 
	      Class.forName("com.mysql.jdbc.Driver");  
	      // 2、连接数据库 
	      conn = DriverManager.getConnection(DBURL, DBUSER, DBPASS); 
	      // 3、Statement接口需要通过Connection接口进行实例化操作 
	      stmt = conn.createStatement(); 
	      
			/* String names=request.getParameter("name"); */
	      
	      
	      out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">"); 
	      out.println("<HTML>");
	      out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>"); 
	      out.print("<style type=\"text/css\">");
	      out.print("body{\r\n" + 
	      		"		background-color: skyblue;\r\n" + 
	      		"	}");
	     out.print("body{\r\n" + 
	     		"		background-color: #EECED9;\r\n" + 
	     		"	}\r\n" + 
	     		"	h1{\r\n" + 
	     		"		text-align: center;\r\n" + 
	     		"		color:#CD05F7;\r\n" + 
	     		"	}\r\n" + 
	     		"	table{\r\n" + 
	     		"		width: 400px;\r\n" + 
	     		"		height: 80px;\r\n" + 
	     		"		text-align: center;\r\n" + 
	     		"		border: none;\r\n" + 
	     		"	}\r\n" + 
	     		"	td{\r\n" + 
	     		"		border-radius: 20px;\r\n" + 
	     		"		border:1.3px solid skyblue;\r\n" + 
	     		"		color:#A71E1E;\r\n" + 
	     		"	}\r\n" + 
	     		"	td:hover{\r\n" + 
	     		"		background-color: skyblue;\r\n" + 
	     		"		font-size: 17px;\r\n" + 
	     		"	}");
	     out.print("h1{\r\n" + 
	     		"		font-size: 28px;\r\n" + 
	     		"		text-align: center;\r\n" + 
	     		"		color:#A75480;\r\n" + 
	     		"	}\r\n" + 
	     		"	@keyframes move{\r\n" + 
	     		"		0%{\r\n" + 
	     		"			color:pink;\r\n" + 
	     		"		}\r\n" + 
	     		"		20%{\r\n" + 
	     		"			color:skyblue;\r\n" + 
	     		"		}\r\n" + 
	     		"		40%{\r\n" + 
	     		"			color:red;\r\n" + 
	     		"		}\r\n" + 
	     		"		60%{\r\n" + 
	     		"			color:blue;\r\n" + 
	     		"		}\r\n" + 
	     		"		80%{\r\n" + 
	     		"			color:green;\r\n" + 
	     		"		}\r\n" + 
	     		"		90%{\r\n" + 
	     		"			color:gold;\r\n" + 
	     		"		}\r\n" + 
	     		"	}\r\n" + 
	     		"\r\n" + 
	     		"	h1{\r\n" + 
	     		"		animation-name: move;\r\n" + 
	     		"		animation-duration: 30s;\r\n" + 
	     		"	}"); 
	     out.print("	.main{\r\n" + 
	     		"		border-radius: 20px;\r\n" + 
	     		"		width: 150px;\r\n" + 
	     		"		height: 40px;\r\n" + 
	     		"		text-align: center;\r\n" + 
	     		"		font-size: 28px;\r\n" + 
	     		"		text-decoration: none;\r\n" + 
	     		"		border: solid;\r\n" + 
	     		"		display: block;\r\n" + 
	     		"		position: absolute;\r\n" + 
	     		"		top: 85%;\r\n" + 
	     		"		right: 8%;\r\n" + 
	     		"	}\r\n" + 
	     		"	.main:hover{\r\n" + 
	     		"		background-color: skyblue;\r\n" + 
	     		"	}");
	     
	      out.print("</style>");
	      out.println(" <BODY>"); 
	      //输出表头部分 
	      out.print("<h1>查询成功</h1>");
	      out.print("<table align='center' border='1'><tr><td>设备名称" + 
	      "</td><td>数量</td><td>价格</td><td>修改</td><td>删除</td></tr>"); 
	      String name=request.getParameter("name"); 
	      ResultSet rs=stmt.executeQuery("select *from student where name like '%"+name + "%'"); 
	      while(rs.next()) 
	      { 
	    	  
	        //获取数据库中的ID 
//	        String name=rs.getString("name");
	    	  String names=name;
	        
	        //输出一列元素 
	        out.print("<tr><td>"+rs.getString("name") 
	        +"</td><td>"+rs.getString("calssGrent")+"" + 
	        "</td><td>"+rs.getString("result")+"</td>" + 
	        "<td><a href='UpdatePage?name="+names+"'>修改</a></td>" + 
	        "<td><a href='delete?name="+names+"'> 删除 </a></td></tr>"); 
	          
	      } 
	      out.println("<td><a href=AddPage>添加数据</a></td>"); 
	      out.print("<a href=\"test2.html\" class=\"main\">返回主页</a>");
	      out.println(" </BODY>"); 
	      out.println("</HTML>");  
	      conn.close(); 
	        
	    } 
	    catch (Exception e) 
	    { 
	      e.printStackTrace(); 
	    } 
	    out.flush(); 
	    out.close(); 
	  } 
	  
	}