login.jsp

实例大全

<%@ page language="java" import="java.sql.*">
<jsp:useBean id="RegisterBean" scope="page" class="opendb.opendb" />

<%
	String name1=request.getParameter("username");
	String pwd1=request.getParameter("password");
	String sql="select * from userinfo where username='"+name1+"' and 		 password='"+pwd1+"'";
	
	ResultSet rs=LoginBean.executeQuery(sql);
	if (rs.next())
	{
		rs.close();
		session.putValue("username",name1);
%>
	<script language=javascript>
	window.location="info.jap?str=登录成功"
	</script>
<%
	}
	else
	{
		rs.close();
		session.putvalue("login_message","Error on Login!");
%>
	<script language=javascript>
	window.location="info.jsp?str=登录失败"
	</script>
<%
	}
%>