login.jsp
<%@page import="org.apache.tomcat.util.descriptor.web.LoginConfig"%>
<%@page import="com.sun.java.swing.plaf.windows.resources.windows"%>
<%@page import="javax.servlet.jsp.tagext.TryCatchFinally"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@page import="java.sql.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
用户登录
<%
request.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
%>
<%!
String driver="com.mysql.jdbc.Driver";
int i=0;//测试数据库是否存在该用户
Connection conn =null;
PreparedStatement ps=null;
ResultSet rs=null;
String url="jdbc:mysql://127.0.0.1:3306/Hit_DB";
String user="root";
String password="12345678";
String sql="select user_name,user_password from user_table";
%>
<%
try{
String user_name1=request.getParameter("username");
String user_password1=request.getParameter("password11");
/* session.setAttribute("uname",user_name1); */
String user_name2=null;
String user_password2=null;
Class.forName(driver);
conn=DriverManager.getConnection(url, user, password);
ps=(PreparedStatement)conn.prepareStatement(sql);
rs=ps.executeQuery();
while(rs.next()){
user_name2=rs.getString(1);
user_password2=rs.getString(2);
if(user_name1.equals(user_name2)&&user_password1.equals(user_password2)){
request.getRequestDispatcher("index.html").forward(request,response);
i=1;
}
}
if(i==0){
out.println("alert('请重新登录!');window.history.back(-1);");
}
i=0;
String username = request.getParameter("user_name1");
}catch(SQLException e){
out.print("数据库异常!");
}finally{
}
%>
<%-- <%
String name=request.getParameter("user_name1");
session.setAttribute("uname", name);
%> --%>
<%
if(rs!=null){
rs.close();
}
if(ps!=null){
ps.close();
}
if(conn!=null){
conn.close();
}
%>
person.jsp
<%@page import="com.sun.xml.internal.txw2.Document"%>
<%@page import="javax.websocket.Session"%>
<%@page import="org.apache.catalina.connector.Request"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@page import="java.sql.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
个人页面
<%!
//定义全局变量
String driver="com.mysql.jdbc.Driver";
String url="jdbc:mysql://127.0.0.1:3306/Hit_DB";
String user="root";
String password="12345678";
/* String username=null; /
String sql="select * from user_table where user_name=?";
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs=null;
%>
<%
//设置编码,防止乱码现象
request.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
%>
<%
try{
/ String uname=(String)session.getAttribute("uname"); /
String uname = request.getParameter("username");
/ String name=new String(session.getAttribute("name").toString().getBytes("ISO-8859-1"),"UTF-8"); /
Class.forName(driver);
conn=DriverManager.getConnection(url,user,password);
ps=conn.prepareStatement(sql);
ps.setString(1,uname);
rs=ps.executeQuery();
/ String users=request.getParameter("username"); */
}catch(SQLException e){
out.print("无法查询!");
}
%>
<nav class="navbar navbar-inverse navbar-fixed-top">
<div class="container">
<div class="navbar-header">
<a href="index.html" class="navbar-brand logo"><img src="images/logo1.png" /></a>
<button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#navbar-collapse">
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
</div>
<div class="collapse navbar-collapse" id="navbar-collapse">
<ul class="nav navbar-nav navbar-right">
<li class="nav-li">
<a href="index.html" class="active"><span class="glyphicon glyphicon-home"></span> 首页</a>
</li>
<li class="nav-li">
<a href="information.html"><span class="glyphicon glyphicon-list"></span> 资讯</a>
</li>
<li class="nav-li">
<a href="case.html"><span class="glyphicon glyphicon-fire"></span>打卡小明星</a>
</li>
<li class="nav-li">
<a href="about.html"><span class="glyphicon glyphicon-question-sign"></span> 关于</a>
</li>
<li>
<div class="dropdown hidden-xs">
<img src="images/avatar.jpg" class="dropdown-toggle avatar" data-toggle="dropdown">
<ul class="dropdown-menu">
<li><a href="person.html">个人中心</a></li>
<li><a href="CircleOfFriends.html">朋友圈</a></li>
<li><a href="massage.html">消息</a></li>
<li><a href="published-topics.html">发表</a></li>
<li><a href="#">设置</a></li>
<li class="divider"></li>
<li><a href="xxx">退出</a></li>
</ul>
</div>
</li>
</ul>
</div>
</div>
</nav>
<div class="head">
<div class="container">
<div class="row">
<div class="col-md-2 hidden-xs">
<img src="images/avatar.jpg" class="img-circle head-portrait" />
</div>
<div class="col-md-10 head-num">
<div class="info">
<strong class="username">
<% sql="select user_nickname,user_sex,user_email from user_table where user_name=?";
conn=null;
ps=null;
rs=null;
%>
<%
try{
String uname = request.getParameter("username");
conn=DriverManager.getConnection(url,user,password);
ps=conn.prepareStatement(sql);
ps.setString(1,uname);
rs=ps.executeQuery();
while(rs.next()){
String nick=rs.getString("user_nickname");
out.print(nick);
}
/* String users=request.getParameter("username"); */
}catch(SQLException e){
out.print("无法查询!");
}
%>
</strong>
</div>
login.jsp是跳转到index.html这个主界面的,然后从主界面跳转到person.jsp个人界面,个人界面从数据库传数据要用到登陆界面的用户名。。。。