用户名输入用户名和密码登入系统:
1、首先创建数据表存储用户名和密码:
创建表:
drop table user;
create table user(
id int auto_increment primary key,
username varchar(30) not null,
password varchar(30) not null
);
insert into user(username,password) values('lid','123');
insert into user(username,password) values('yuj','123');
2、创建jsp界面:
login.jsp---------------提供用户登入的表单;
login_check.jsp---------核对是否存在该用户
login_success.jsp-------登入成功后的界面
login_failuer.jsp-------登入失败后的界面
·login.jsp界面代码:
<%@ page contentType="text/html" pageEncoding="gbk"%>
<html>
<head><title>登陆</title></head>
<body>
<form action="login_check.jsp" method="post">
<center>
用户名:<input type="text" name="username"/><br/>
密码: <input type="password" name="password"/><br/>
<input type="submit" value="登入"/>
<input type="reset" value="重置"/>
</center>
</form>
</body>
</html>
·login_check.jsp界面代码:
<%@ page contentType="text/html" pageEncoding="gbk"%>
<%@ page import="java.sql.*"%>
<html>
<head><title>核对</title></head>
<body>
<!---定义常量 --->
<%!
public static final String DBDRIVER="org.gjt.mm.mysql.Driver";
public static final String DBURL="jdbc:mysql://localhost:3306/lid";
public static final String DBUSER="root";
public static final String DBPASSWORD="123";
Connection conn=null;
PreparedStatement pstmt=null;
ResultSet rs=null;
%>
<!---得到数据库的连接 --->
<%
Class.forName(DBDRIVER);
conn=DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);
%>
<!---查询用户 --->
<%
String username=request.getParameter("username");
String password=request.getParameter("password");
String sql="select name,password from user where name=? and password=?";
pstmt=conn.prepareStatement(sql);
pstmt.setString(1,username);
pstmt.setString(2,password);
rs=pstmt.executeQuery();
if(rs.next()){
%>
<jsp:forward page="login_success.jsp"/>
<%
}
else{
%>
<jsp:forward page="login_failuer.jsp"/>
<%
}
%>
</body>
</html>
·login_success.jsp界面代码:
<h2>登陆成功</h2>
·login_failuer.jsp界面代码:
<h2>用户名或密码错误</h2>