201906G202/Add.java

package org.lsy.servlet; 
  
import java.io.IOException; 
import java.io.PrintWriter; 
import java.sql.Connection; 
import java.sql.DriverManager; 
import java.sql.PreparedStatement; 
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 Add extends HttpServlet 
{ 
	  public static final String DBURL = "jdbc:mysql://localhost:3306/kui"; 
	  // 连接数据库的用户名 
	  public static final String DBUSER = "root"; 
	  // 连接数据库的密码 
	  public static final String DBPASS = "001011"; 
  
  @Override
  protected void doPost(HttpServletRequest req, HttpServletResponse resp) 
      throws ServletException, IOException 
  { 
    // TODO Auto-generated method stub 
    doGet(req, resp); 
  } 
  
  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 pstmt = null; // 表示数据库的更新操作 
      String nameString=request.getParameter("name"); 
      String grentString=request.getParameter("grent"); 
      String resultString=request.getParameter("result"); 
      System.out.print(nameString); 
      String sql="insert into student(name,calssGrent,result) values('"+nameString+"','"+grentString+"','"+resultString+"')"; 
    
    
      // 1、使用Class类加载驱动程序 
      Class.forName("com.mysql.jdbc.Driver");  
      // 2、连接数据库 
      conn = DriverManager.getConnection(DBURL, DBUSER, DBPASS); 
      pstmt=conn.createStatement(); 
      int pd=pstmt.executeUpdate(sql); 
      if (pd!=0) 
      { 
    	  out.print("<style type=\"text/css\">\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" + 
    	  		"	h1{\r\n" + 
    	  		"		animation-name: move;\r\n" + 
    	  		"		animation-duration: 10s;\r\n" + 
    	  		"		text-align: center;\r\n" + 
    	  		"	}\r\n" + 
    	  		"	a{\r\n" + 
    	  		"		text-align: center;\r\n" + 
    	  		"		font-size: 28px;\r\n" + 
    	  		"		text-decoration: none;\r\n" + 
    	  		"	}\r\n" + 
    	  		"	.look{\r\n" + 
    	  		"		width: 180px;\r\n" + 
    	  		"		height: 40px;\r\n" + 
    	  		"		border: solid;\r\n" + 
    	  		"		margin: 0 auto;\r\n" + 
    	  		"		text-align: center;\r\n" + 
    	  		"	}\r\n" + 
    	  		"	.look:hover{\r\n" + 
    	  		"		background-color: pink;\r\n" + 
    	  		"	}\r\n" + 
    	  		"	</style>");
        out.println("<h1>恭喜！添加成功！</h1><br><br>"); 
        out.println("<div class=\"look\">\r\n" + 
        		"	<a href=MMC_01>查看列表</a>\r\n" + 
        		"	</div>"); 
      } 
      conn.close(); 
        
    } 
    catch (Exception e) 
    { 
      e.printStackTrace(); 
    } 
    out.flush(); 
    out.close(); 
  } 
  
}