第八周-邮件系统1

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>




  
   
  
  
  
   

     用户名：  



     密   码：

     

     
     
  

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ page import="scc.Userdao" %>



  


  
  
  
           <%
             String name=request.getParameter("name");
             String password=request.getParameter("password");
              
              
              Userdao dao=new Userdao();
              if(dao.select(name, password)){
              request.getRequestDispatcher("main.jsp").forward(request, response);
              }else{
               response.sendRedirect("login.jsp");
              }
           
            %>

  

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@page  import="java.sql.*" %>
<%@page  import="scc.JDBCUtils" %>
<%@page  import="scc.Msg" %>



  


  
  
  
        <% String nn=request.getParameter("name");
        
         %>
          
        <%
         
         Connection con=null;
		 PreparedStatement st=null;
		 ResultSet rst=null;
            try{
            con=JDBCUtils.getCon();
			 
			 
			 
			 String sql="select*from msg where sender=?";
			 
			 
			st=con.prepareStatement(sql);
			 
			 
			 st.setString(1, nn);
          
            rst=st.executeQuery();
            Msg m=new Msg();
            %>
     
       
     
       
     
           
             
             
             
             
            <%  while(rst.next()){ %>
              
 
               
           
                
             
           
         
          <%} %>
            
             

               

            
 标题
            
 内容
            
 发件人
             
收件人
             
 日期
            
 状态
             

            
 <%=rst.getString("title") %>
            
 <%=rst.getString("content") %>
            
 <%=rst.getString("sender") %>
             
<%=rst.getString("recive") %>
             
 <%=rst.getString("date") %>
            
 <%=rst.getString("state") %>
             
 
          <%
            }catch(Exception e){
            throw new RuntimeException(e);
            }
            finally{
            JDBCUtils.closeAll(rst, st, con);
            }
	
         %>
             
  
  
  
  
  

             
             
             
             

             

                        请输入你的标题