一聚教程网:一个值得你收藏的教程网站

最新下载

热门教程

jsp用户登陆代码

时间:2009-09-12 编辑:简简单单 来源:一聚教程网

jsp用户登陆代码
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@include file="DB.jsp"%>

http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
http://www.w3.org/1999/xhtml">
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>


用户登录-
css" rel="stylesheet" type="text/css" />


<%
if(request.getParameter("Dropsubmit")!=null){
 Cookie deleteNewCookie=new Cookie("username",null);
 deleteNewCookie.setMaxAge(0);
 response.addCookie(deleteNewCookie);
 out.print("");
 return ;
}
if(request.getParameter("midisubmit")!=null){
 String username=new String(request.getParameter("username").getBytes("iso-8859-1"));
 String password=new String(request.getParameter("password").getBytes("iso-8859-1"));
 password=loginMD5.getMD5ofStr(password);
 String company=new String(request.getParameter("company").getBytes("iso-8859-1"));
 String conname=new String(request.getParameter("conname").getBytes("iso-8859-1"));
 String email=new String(request.getParameter("email").getBytes("iso-8859-1"));
 String address=new String(request.getParameter("address").getBytes("iso-8859-1"));
 String content=new String(request.getParameter("content").getBytes("iso-8859-1"));
 String tel=new String(request.getParameter("tel").getBytes("iso-8859-1"));
 String orderr=new String(request.getParameter("order").getBytes("iso-8859-1"));
 Statement stmt_ADD=conn.createStatement();
 stmt_ADD.executeUpdate("Update Member Set password='"+password+"',content='"+content+"',company='"+company+"',tel='"+tel+"',conname='"+conname+"',email='"+email+"',address='"+address+"',qunx='"+orderr+"' where username='"+username+"'");
 stmt_ADD.close();
 out.print("");
 return ;
}
if(request.getParameter("editname")!=null){
 String editname=new String(request.getParameter("editname").getBytes("iso-8859-1"));
 Statement stmt_u2=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
 String sqlu2 = "select * from Member where username='" + editname +"'";
 ResultSet Rsu2 = stmt_u2.executeQuery(sqlu2);
 if(Rsu2.next()){
%>


<%@include file="head.jsp"%>


 
   
     
   
   
 
      background="images/l_m_bg.jpg" height="370">       cellpadding="0" width="300" border="0">
       
         
           
         
         
           
         
         
           
         

       


     
        width="706" />
            class="f12red" style="FONT-SIZE:14px; FONT-WEIGHT: bold; COLOR: #cccc00">修改个人资料
                 
            action="" method="post">
                                cellspacing="0" cellpadding="8" width="570" align="center" border="0">
                     
                       
                         
                         
                         
                       
                       
                         
                         
                         
                       
                       
                         
                         
                         
                       
                       
                         
                         
                         
                       
                       
                         
                         
                         
                       

                       


                         
                         
                         
                       
                       
                         
                         
                         
                       
                       
                         
                         
                         
                       

                       


                         
                         
                       
                       
                         
                         
                       
                     
                   
                height="20">
                             
                               
                                 
                               
                             
                         
用户名:
<%=Rsu2.getString("username")%>

                             
                               
                                 
     " />
      " />
                               
                             
                         
密码:
                  name="password" /> 二次修改需要确认以前的密码!

                             
                               
                                 
                               
                             
                         
                align="right">确认密码:
                  name="password2" /> 

                             
                               
                                 
                               
                             
                         
                align="right">单位名称:
                name="company" value="<%=Rsu2.getString("company")%>" />

                             
                               
                                 
                               
                             
                         
联系人:
"/>                         

                             
                               
                                 
                               
                             
                         
联系电话:
                  bgcolor="#fafafa">

                             
                               
                                 
                               
                             
                         
                  align="right">E_mail:

                             
                               
                                 
                               
                             
                         
联系地址:
"/>                         

                             
                               
                                 
                               
                             
                         
备注                         class="f12red">:(可不填)

                 
          />
 

<%@include file="foot.jsp"%>


<%
  }
 Rsu2.close();
 stmt_u2.close();
return ;
}
if (request.getParameter("loginCheck")!=null){
 Cookie deleteNewCookie=new Cookie("username",null);
 deleteNewCookie.setMaxAge(0);
 response.addCookie(deleteNewCookie);
 String username=new String(request.getParameter("username").getBytes("iso-8859-1"));
 String password=new String(request.getParameter("password").getBytes("iso-8859-1"));
 password=loginMD5.getMD5ofStr(password);
 Statement stmt_Check=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
 String sql = "select * from Member where password='"+ password + "' and username='" + username +"'";
 ResultSet RsLoginCheck = stmt_Check.executeQuery(sql);
 if(RsLoginCheck.next()){
  if(RsLoginCheck.getString("qunx").equals("1")){
   Cookie cookie=new Cookie("username",java.net.URLEncoder.encode(username,"gb2312"));
   //cookie.setMaxAge(1*24*60*60);
   response.addCookie(cookie); //写COOKIE
   out.print("");
  }else{
   out.print("");
  }
 }else{
  out.print("");
 }
 RsLoginCheck.close();
 stmt_Check.close();
 conn.close();
}
Cookie cookies[]=request.getCookies();
Cookie sCookie=null;
String svalue=null;
String sname=null;
String SCname=null;
if(cookies.length>1){
//for(int i=1;i   sCookie=cookies[1];
  SCname=java.net.URLDecoder.decode(sCookie.getValue(),"gb2312");
  //out.print("用户名是"+sCookie.getName()+" "+"密码是"+java.net.URLDecoder.decode(sCookie.getValue(),"gb2312")+"
");
//}
}
if (SCname!=null){
 Statement stmt_u=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
 String sqlu = "select * from Member where username='" + SCname +"'";
 ResultSet Rsu = stmt_u.executeQuery(sqlu);
 if(Rsu.next()){
%>

<%@include file="head.jsp"%>

 
   
     
      background="images/l_m_bg.jpg" height="370">       cellpadding="0" width="300" border="0">
       
         
           
         
         
           
        width="706" />
            class="f12red" style="FONT-SIZE:14px; FONT-WEIGHT: bold; COLOR: #cccc00">我的个人信息
                 
            action="" method="post">
                                cellspacing="0" cellpadding="8" width="570" align="center" border="0">
                     
                       
                         
                         
                         
                       
                       
                         
                         
                         
                       
                       
                         
                         
                         
                       

                       


                         
                         
                         
                       
                       
                         
                         
                         
                       
                       
                         
                         
                         
                       
    
                       
                         
                         
                       
      
                         
                         
             
                height="20">
                             
                               
                                 
                               
                             
                         
用户名:
<%=Rsu.getString("username")%>                      

                             
                               
                                 
                               
                             
                         
                align="right">单位名称:
<%=Rsu.getString("company")%>

                             
                               
                                 
                               
                             
                         
联系人:
                         <%=Rsu.getString("conname")%>

                             
                               
                                 
                               
                             
                         
联系电话:
                  bgcolor="#fafafa">

                             
                               
                                 
                               
                             
                         
                  align="right">E_mail:

                             
                               
                                 
                               
                             
                         
联系地址:
  <%=Rsu.getString("address")%>                         

                             
                               
                                 
                               
                             
                         
备注                         class="f12red">:
  <%=Rsu.getString("content")%>

                             
                               
                                 
                               
                             
                         
状态                         class="f12red">:

        <% if (Rsu.getString("qunx").equals("1")){
       out.print("已审核");
      }else{ out.print("等待审核"); }
       %>