login.jsp
页面代码如下:
<%@ page contentType="text/html; charset=GBK"%>
<form method=post action="login_check.jsp">
<TABLE align="center">
<TR>
<TD><h3>
用户编号:
<INPUT TYPE="text"
NAME="uid"></h3></TD>
</TR>
<TR>
<TD><h3>
密
码:
<INPUT
TYPE="password" NAME="upwd"></h3></TD>
</TR>
<TR>
<TD align="center"><INPUT TYPE="submit" value = "
登录
"></TD>
</TR>
</TABLE>
</form>
login_check.jsp
页面代码如下:
<%@ page contentType="text/html; charset=GBK"%>
<%@ page import = "java.sql.*" %>
<TABLE align="center">
<TR>
<TD><h1>
欢迎进入验证页
请稍后…………
</h1></TD>
</TR>
</TABLE>
<%!
public static final String DBDRIVER="oracle.jdbc.driver.OracleDriver";
public static final String DBURL="jdbc:oracle:thin:@localhost:1521:ORCL";
public static final String DBUSER="test";
public static final String DBPASS="test";
%>
<%
Connection conn=null;
Statement stmt=null;
String sql=null;
ResultSet rs=null;
boolean flag = false;
String uid=request.getParameter("uid");
String psw=request.getParameter("upwd");
%>
<%
try{
Class.forName(DBDRIVER);
conn=DriverManager.getConnection(DBURL,DBUSER,DBPASS);
sql="select * from yonghu where userid='"+uid+"'and
password='"+psw+"'";
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
if(rs.next()){
flag=true;
session.setAttribute("username",rs.getString("name"));
}
}
catch(Exception e)
{System.out.println(e.toString());}
finally{
try{
rs.close();
stmt.close();
conn.close();
}
catch ( Exception e ){
System.out.println(e.toString());
}
}
%>
<%
if(flag)
{
%>
<jsp:forward page="login_success.jsp"/>
<%
}
else
{
%>
<jsp:forward page="login_failure.jsp"/>
<%
}
%>
login_success.jsp
页面代码如下:
<%@ page contentType="text/html;charset=GBK"%>
<TABLE align="center">
<TR>
<TD><h1>
恭喜
<%= session.getAttribute( "username" ) %>
,你已
登录成功
</h1></TD>
</TR>