con.close(); 内容来自www.paper51.com
} copyright paper51.com catch(SQLException e) http://www.paper51.com {message="你还没有注册,或该用户已经存在,请你更换一个名字"; 内容来自www.paper51.com } 内容来自www.paper51.com } http://www.paper51.com
} 内容来自www.paper51.com (2)用户登录 userLogin.jsp: copyright paper51.com <%String string=response.encodeURL("userLogin.jsp"); 内容来自www.paper51.com
%> 内容来自www.paper51.com <H3> 内容来自www.paper51.com
<P>输入用户名和密码: copyright paper51.com <FORM action="<%=string%>" Method="post"> 内容来自论文无忧网 www.paper51.com
<BR>登录名称<Input type=text name="logname"> 内容来自论文无忧网 www.paper51.com <BR>输入密码<Input type=password name="password"> copyright paper51.com <BR><Input type=submit name="g" value="提交"> copyright paper51.com
</Form> http://www.paper51.com
<jsp:useBean id="login" class="book.Login"scope="session" > http://www.paper51.com </jsp:useBean> paper51.com <% //提交信息后,验证信息是否正确: http://www.paper51.com String message="", 内容来自www.paper51.com logname="", copyright paper51.com password=""; 内容来自论文无忧网 www.paper51.com if(!(session.isNew())) copyright paper51.com {logname=request.getParameter("logname"); 内容来自www.paper51.com if(logname==null) copyright paper51.com {logname=""; http://www.paper51.com } paper51.com logname=codeString(logname); 内容来自www.paper51.com password=request.getParameter("password"); http://www.paper51.com if(password==null) paper51.com {password=""; 内容来自www.paper51.com } 内容来自www.paper51.com
password=codeString(password); 内容来自www.paper51.com
} 内容来自论文无忧网 www.paper51.com
%> copyright paper51.com <% copyright paper51.com if(!(logname.equals(""))) 内容来自论文无忧网 www.paper51.com { 内容来自www.paper51.com %> 内容来自论文无忧网 www.paper51.com <jsp:setProperty name="login" property="logname" value="<%=logname%>" /> 内容来自论文无忧网 www.paper51.com
<jsp:setProperty name="login" property="password" value="<%=password%>"/> paper51.com <p> copyright paper51.com <% paper51.com message=login.getMessage(); 内容来自论文无忧网 www.paper51.com if(message==null) copyright paper51.com {message=""; 内容来自论文无忧网 www.paper51.com } 内容来自www.paper51.com } 内容来自论文无忧网 www.paper51.com
%> paper51.com
<% if(!(session.isNew())) copyright paper51.com {if(message.equals("ok")) http://www.paper51.com { String str=response.encodeURL("buybook.jsp"); copyright paper51.com response.sendRedirect(str); 内容来自www.paper51.com } copyright paper51.com else paper51.com
{out.print(message); paper51.com } 内容来自论文无忧网 www.paper51.com } 内容来自www.paper51.com
%> copyright paper51.com 本程序用了Bean: Login.java : paper51.com package book; http://www.paper51.com import java.sql.*; 内容来自www.paper51.com public class Login copyright paper51.com { String logname, paper51.com realname, copyright paper51.com password, copyright paper51.com phone, 内容来自www.paper51.com address; http://www.paper51.com Stringsuccess="false",message=""; 内容来自论文无忧网 www.paper51.com Connection con; copyright paper51.com Statement sql; 内容来自论文无忧网 www.paper51.com ResultSet rs; 内容来自www.paper51.com public Login() paper51.com
{ //加载桥接器: 内容来自www.paper51.com try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 内容来自www.paper51.com
} http://www.paper51.com
catch(ClassNotFoundException e){} paper51.com
} http://www.paper51.com //查询数据库的user表: copyright paper51.com
public String getMessage() 内容来自www.paper51.com {try{ paper51.com
con=DriverManager.getConnection("jdbc:odbc:shop","",""); 内容来自www.paper51.com sql=con.createStatement(); http://www.paper51.com String condition= paper51.com "SELECT * FROM user WHERE logname ="+"'"+logname+"'"; 内容来自论文无忧网 www.paper51.com rs=sql.executeQuery(condition); copyright paper51.com int rowcount=0; 内容来自论文无忧网 www.paper51.com
String ps=null; 内容来自www.paper51.com while(rs.next()) 内容来自www.paper51.com { rowcount++; 内容来自论文无忧网 www.paper51.com logname=rs.getString("logname"); http://www.paper51.com System.in的话,就必须先做处理了。 http://www.paper51.com
|