weiyong
/
201906G202


			
				
					
						
						
							12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970
							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 UpdatePage 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 
  { 
    String name=request.getParameter("name"); 
    //设置请求和响应的编码 ，不然页面上容易出现乱码 
    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; // 表示数据库的更新操作 
      // 1、使用Class类加载驱动程序 
      Class.forName("com.mysql.jdbc.Driver");  
      // 2、连接数据库 
      conn = DriverManager.getConnection(DBURL, DBUSER, DBPASS); 
      // 3、Statement接口需要通过Connection接口进行实例化操作 
      stmt = conn.createStatement(); 
      //用 rs获取查询结果 
      ResultSet rs=stmt.executeQuery("select * from student where name='"+name+"'"); 
      while (rs.next()) 
      { 
      out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">"); 
      out.println("<HTML>"); 
      out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>"); 
      out.println(" <BODY>"); 
      //输入成绩的表单，提交至Update 
      out.print(" <form action='Update' method='get'> "); 
      out.print("<table align='center'> <tr><td>设备名称：<input type='text' value='"+rs.getString("name")+"' name='name' size=20 ></td></tr>"); 
      out.print("<tr><td>数量：<input type='text' value='"+rs.getString("calssGrent")+"' name='grent' size=20></td></tr>"); 
      out.print("<tr><td>价格：<input type='text' value='"+rs.getString("result")+"' name='result' size=20></td></tr>");   
      //为了作为查询数据库的条件 ，这里要把ID传过去 
      out.print("<input type='hidden' value='"+name+"' name='name'>"); 
      out.print("<tr><td><input type='submit' value='修改'><input type='reset' value='重置'></td></tr></table></form>"); 
      out.print(" </BODY>"); 
      out.println("</HTML>"); 
      } 
      out.flush(); 
      out.close(); 
    } 
    catch (Exception e) { 
      e.printStackTrace();// TODO: handle exception 
    } 
    } 
  
}