最近在用jsp做网站,虽然只是起步,但是分享一下个人经验,今天说一下用jsp做登录界面,现在我知道的共有三种方法,今天先说一下最简单的方法,个人认为:
用户登录,大家都知道,需要三个界面,登录界面(Login.jsp),成功界面(success.jsp),失败界面(fail.jsp),在本文中,用户登录成功后,在成功页面显示“用户***登录成功”,失败后显示“登录失败,点击按钮重新登录”,失败页面有个按钮。
首先建立工程为动态网站,这个再此不在多说!
Login.jsp代码
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>登录页面</title>
</head>
<body>
<h1>登录页面</h1>
<form action="log.do" method="post"> //这行一会在java文件中会提到(1)
<p>用户名:
<input name="username" type="text" style="width:150" value="">
</p>
<p>密码:
<input name="userpwd" type="password" style="width:150" value="">
</p>
<input type="submit" value="登录">
<input type="reset" value="取消">
</form>
</body>
</html>
success.jsp代码
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<h1>
用户:<%= session.getAttribute("username") %>登录成功!
</h1>
</body>
</html>
fail.jsp代码
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="fa.do" method="post">
<h1>用户名密码错误!点击按钮重新登录!</h1>
<input type="submit" value="重新登录">
</body>
</html>
在你建立的网站中java resource中的src中建立包(package),在包中建立servlet文件,文件中加入以下代码:
package action; //这个是你在src中建立包的名字,我这里叫action
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
/**
* Servlet implementation class ssss
*/
@WebServlet("/log.do") //这个log.do与Login中action那一行对应,上面以标记,指明那个jsp由这个java文件控制
public class sss extends HttpServlet { //我在包中建立servlet文件名为sss
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public sss() { //我在包中建立servlet文件名为sss
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
HttpSession session = request.getSession();
String username=request.getParameter("username");
String userpwd=request.getParameter("userpwd");
try{
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","123456");
//上面这行代码为链接数据库,其中我的数据库是mysql,数据库用户名为root,密码为123456
String sql="select * from ifo where name='"+username+"'";
//这行代码表示在我的表ifo中找name,并判断,我的表共两列,name和pwd
PreparedStatement ps=conn.prepareStatement(sql);
//ps.setString(1, username);//�˷��������ڱ����϶�ʱ
ResultSet rs=ps.executeQuery();
while(rs.next())
{
String name=rs.getString("name");
String pwd=rs.getString("pwd");
if(username.equals(name)&&userpwd.equals(pwd))
{
session.setAttribute("username",username);
response.sendRedirect("/c/su.jsp"); //c为我建立动态工程的名
}
else
{
response.sendRedirect("/c/fa.jsp");
}
}
response.sendRedirect("/c/fa.jsp");
rs.close();
conn.close();
}
catch(Exception e)
{
System.out.println("<h2>�����������"+e.getMessage()+"</h2>");
}
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
doGet(request, response);
}
}
在包中建立servlet文件,文件中加入以下代码:(同上)
package action;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
* Servlet implementation class ssss
*/
@WebServlet("/fa.do")
public class fa extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public fa() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
response.sendRedirect("/c/log.jsp");
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
doGet(request, response);
}
}
到这里界面以及控制文件都已经完成,但是还有关键的一步,就是在你的server里找到tomcat,找到context.xml打开,在最下面</Context>的上一行加入下面的代码;
context.xml代码:
<Resource auth="Container" characterEncoding="UTF8"
driverClassName="com.mysql.jdbc.Driver"
logAbandoned="true" maxActive="50" maxIdle="30"
maxWait="-1" name="health" password="123456"
removeAbandoned="true" removeAbandonedTimeout="60"
testOnBorrow="true" type="javax.sql.DataSource"
url="jdbc:mysql://localhost:3306/health?characterEncoding=utf-8" useUnicode="true"
username="root" validationQuery="select 1"/>
//说明一下,第4行中的name="health"中的health为我的数据库名,password为数据库的密码,这个是你自己需要改的,最后一行的root为登录数据库时的名,这个跟password=“123456”是对应的