weiyong
/
201906G202


			
				
					
						
						
							12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485
							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 MMC_01 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('PS4','2333',' 2998')"; 
	      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(); 
	  
	      ResultSet rs=stmt.executeQuery("select *from student"); 
	      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>"); 
	      out.println(" <center><font size='14px'> 设备管理系统"); 
	      out.println("</font> </center>"); 
	      //输出表头部分 
	      out.print("<table align='center' border='1'><tr><td>设备名称" + 
	      "</td><td>数量</td><td>价格</td><td>修改</td><td>删除</td></tr>"); 
	      while(rs.next()) 
	      { 
	        //获取数据库中的ID 
	        String name=rs.getString("name"); 
	        
	        //输出一列元素 
	        out.print("<tr><td>"+rs.getString("name") 
	        +"</td><td>"+rs.getString("calssGrent")+"" + 
	        "</td><td>"+rs.getString("result")+"</td>" + 
	        "<td><a href='UpdatePage?name="+name+"'>修改</a></td>" + 
	        "<td><a href='delete?name="+name+"'> 删除 </a></td></tr>"); 
	          
	      } 
	      out.println("<td><a href=AddPage>添加数据</a></td>"); 
	      out.println(" </BODY>"); 
	      out.println("</HTML>");  
	      conn.close(); 
	        
	    } 
	    catch (Exception e) 
	    { 
	      e.printStackTrace(); 
	    } 
	    out.flush(); 
	    out.close(); 
	  } 
	  
	}