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.println("添加成功"); 
        out.println("<br><a href=MMC_01>查看列表</a>"); 
      } 
      conn.close(); 
        
    } 
    catch (Exception e) 
    { 
      e.printStackTrace(); 
    } 
    out.flush(); 
    out.close(); 
  } 
  
}