java/jsp: 登录系统
2024-10-19 08:53:33
db类
package db;
import java.sql.*; import javax.naming.InitialContext;
import javax.sql.DataSource; public class DBConnect { private Connection conn;
private Statement stmt;
private PreparedStatement pstmt;
private ResultSet rst;
private String str1; private void init()
{
try {
InitialContext ctx = new InitialContext();
DataSource dsSource = (DataSource) ctx.lookup("java:comp/env/jdbc/test");
conn = dsSource.getConnection(); } catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
} } public DBConnect()
{
//构造函数
try {
//获得一个数据库连接 init(); stmt = conn.createStatement(); } catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
} //执行数据库查询语句，string s为sql语句
public void excuteQuery(String s)
{ try {
if(stmt != null)
{
rst = stmt.executeQuery(s);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} } //对数据库执行update操作
public int excuteUpdate(String s)
{
int status = ;
try {
if(stmt != null)
status = stmt.executeUpdate(s);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} return status;
} //以下为赋值方法
//字符串赋值
public void setString(int i, String s)
{
try {
pstmt.setString(i, s);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
} //boolean赋值
public void setBoolean(int i, Boolean flag)
{
try {
pstmt.setBoolean(i, flag);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
} //date日期型赋值
public void setDate(int i, Date date) {
try {
pstmt.setDate(i, date);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
} //时间类型赋值
public void setTime(int i, Time time) {
try {
pstmt.setTime(i, time);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
} //short类型赋值
public void setShort(int i, Short short1)
{
try {
pstmt.setShort(i, short1);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
} //整形赋值
public void setInt(int i, int int1)
{
try {
pstmt.setInt(i, int1);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
} //长整型赋值
public void setLong(int i, long l)
{
try {
pstmt.setLong(i, l);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
} //浮点型赋值
public void setFloat(int i, float f)
{
try {
pstmt.setFloat(i, f);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
} //double类型赋值
public void setDouble(int i, double d)
{
try {
pstmt.setDouble(i, d);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
} //以下为获取的方法
//获取字符串
public String getString(int i) throws SQLException
{ return rst.getString(i);
}
public String getString(String str1) throws SQLException
{
return rst.getString(str1);
} //取得boolean类型
public boolean getBoolean(int i) throws SQLException
{
return rst.getBoolean(i);
}
public boolean getBoolean(String str1) throws SQLException
{
return rst.getBoolean(str1);
} //取得date日期型
public Date getDate(int i) throws SQLException
{
return rst.getDate(i);
} //取得日期字符型
public Date getDate(String str1) throws SQLException{
return rst.getDate(str1);
} //获取time时间
public Time getTime(int i) throws SQLException{
return rst.getTime(i);
} //获取time字符时间
public Time geTime(String str1) throws SQLException
{
return rst.getTime(str1);
} //获取双精度型
public double getDouble(int i) throws SQLException
{
return rst.getDouble(i);
}
public double getDouble(String str1) throws SQLException
{
return rst.getDouble(str1);
} //获取浮点型
public float getFloat(int i) throws SQLException{
return rst.getFloat(i);
}
public float getFloat(String str1) throws SQLException
{
return rst.getFloat(str1);
} //获取int型
public int getInt(int i) throws SQLException
{
return rst.getInt(i);
}
public int getInt(String str1) throws SQLException
{
return rst.getInt(str1); } //获取长整型
public long getLong(int i) throws SQLException
{
return rst.getLong(i);
}
public long getLong(String str1) throws SQLException
{
return rst.getLong(str1);
} //获取short短整型
public short getShort(int i) throws SQLException
{
return rst.getShort(i);
}
public short getShort(String str1) throws SQLException
{
return rst.getShort(str1);
} //指针下移一位
public boolean next()
{
try {
return rst.next();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return false;
}
} //释放内存
public void close()
{ try {
if(conn != null)
conn.close();
if(stmt != null)
stmt.close();
if(rst!=null)
rst.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} }
}
register包下的内容：
package register;
import java.text.ParsePosition;
import java.text.SimpleDateFormat;
import java.util.Date; public class DateFormat { public static long getDate(String s)
{
SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd");
ParsePosition parsePosition = new ParsePosition(0);
Date date = simpleDateFormat.parse(s, parsePosition);
return date.getTime(); } }
package register;
import register.product.Product;
import register.product.SqlProduct;
import register.user.SqlUser;
import register.user.User; public abstract class Factory { private static Factory factory = null;
public Factory(){}
public static Factory getInstance()
{
if(factory == null)
{
try {
Class factoryClass = Class.forName("register.SqlFactory");
factory = (Factory) factoryClass.newInstance();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
} } return factory;
} public abstract User initUser();
public abstract SqlUser initSqlUser();
public abstract Product initProduct();
public abstract SqlProduct initSqlProduct(); }
package register;
import register.product.Product;
import register.product.SqlProduct;
import register.user.SqlUser;
import register.user.User;; public class SqlFactory extends Factory{ public User initUser(){
return new SqlUser();
} public Product initProduct()
{
return new SqlProduct();
} public SqlUser initSqlUser()
{
return new SqlUser();
} public SqlProduct initSqlProduct()
{
return new SqlProduct();
}
}
register.user包
user.java
package register.user;
public interface User {
public abstract void setUser_id(String user_id);
public abstract String getUser_id();
public abstract void setPassword(String password);
public abstract String getPassword();
public abstract void setName(String name);
public abstract String getName();
public abstract void setSex(String sex);
public abstract String getSex();
public abstract void setBirth(long birth);
public abstract long getBirth();
public abstract void setDescription(String deString);
public abstract String getDescription();
}
abstractUser.java
package register.user;
public abstract class AbstractUser implements User {
private String user_id;
private String password;
private String name;
private String sex;
private long birth;
private String description;
public void setUser_id(String user_id)
{
this.user_id = user_id;
}
public String getUser_id()
{
return this.user_id;
}
public void setPassword(String password)
{
this.password = password;
}
public String getPassword()
{
return this.password;
}
public void setName(String name)
{
this.name = name;
}
public String getName()
{
return this.name;
}
public void setSex(String sex)
{
this.sex = sex;
}
public String getSex()
{
return this.sex;
}
public void setBirth(long birth)
{
this.birth = birth;
}
public long getBirth()
{
return this.birth;
}
public void setDescription(String description)
{
this.description = description;
}
public String getDescription()
{
return this.description;
}
}
sqlUser.java
package register.user;
import register.Factory;
import db.DBConnect; public class SqlUser extends AbstractUser
{ public boolean checkRPwd(String password, String rpassword)
{
if( password != null && rpassword != null )
{
if( password.equals(rpassword) )
{
return true;
}else{
return false;
}
}else{
return false;
}
} public boolean saveUser(User user)
{
String User_id = user.getUser_id();
String Password = user.getPassword();
String Name = user.getName();
String Sex = user.getSex();
long Birth = user.getBirth();
String Description = user.getDescription();
String str = "insert into users values('" + User_id +"', '"+ Password +"', '"+ Name +"', '"+ Sex +"', " +
"'"+ Birth +"', '"+ Description +"')"; try{
DBConnect dbcon = new DBConnect();
dbcon.excuteUpdate(str);
return true;
}catch(Exception e)
{
e.printStackTrace();
return false;
}
} public User getUser(String ID)
{
User user = Factory.getInstance().initUser();
String str = "select * from users where USER_ID = '"+ID+"'"; try{
DBConnect dbConnect = new DBConnect();
dbConnect.excuteQuery(str);
if(dbConnect.next())
{ user.setUser_id(dbConnect.getString());
user.setPassword(dbConnect.getString());
user.setName(dbConnect.getString());
user.setSex(dbConnect.getString());
user.setBirth(dbConnect.getLong());
user.setDescription(dbConnect.getString()); }
}catch(Exception e)
{
e.printStackTrace();
} return user;
} public int checkUser(String ID, String password)
{
int index = -;
User user = getUser(ID);
if(user != null)
{
if( user.getPassword().equals(password) )
{
index = ;
}else{
index = ;
}
}else{
index = ;
}
return index;
} }
jsp文件
index
<%@ page contentType="text/html; charset=utf-8" %>
<%@page import="java.util.Iterator"%>
<%@ page import="register.product.SqlProduct" %>
<%@ page import="register.product.Product" %>
<%@ page import="register.Factory" %> <html>
<title>登录系统</title>
<body>
<h2>Hello World!</h2> <%
String user_id = (String)session.getAttribute("user_id");
if(user_id == "" || user_id == null)
{
response.sendRedirect("login.jsp");
} Product product = null;
SqlProduct sqlProduct = Factory.getInstance().initSqlProduct();
Iterator iterator = sqlProduct.getProduct(); String product_name = "";
float price;
String description = "";
%>
<table>
<tr>
<td>用户登录系统</td>
<td>
<%
if("".equals(user_id))
{
%>
<a href="login.jsp">登录</a>，
<a href="register.jsp">注销</a>
<%
}else{ %>
<%=user_id %>你好，<a href="logout.jsp">退出</a>
<%
}
%> </td>
</tr>
<%
while( iterator.hasNext() )
{
product = (Product)iterator.next();
product_name = product.getProduct_name();
price = product.getPrice();
description = product.getDescription();
%>
<tr>
<td>产品名称:<%=product_name %></td>
<td>价格:<%=price %></td>
</tr>
<tr>
<td cospan="">说明:<%=description %></td>
</tr>
<% }
%> </table>
</body>
</html>
login.jsp
<%@ page language="java" contentType="text/html; charset=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=ISO-8859-1">
<title>login</title>
</head>
<body> <form action="do_login.jsp" method="post">
<table>
<tr>
<td colspan="" align="center">登录</td>
</tr>
<%
String info = request.getParameter("info");
String errMsg = "";
if("".equals(info))
{
errMsg = "用户名错误";
}else if("".equals(info))
{
errMsg = "密码错误";
}
if( !"".equals(errMsg))
{
%>
<tr>
<td colspan="" align="center" color="red"><%=errMsg %></td>
</tr>
<%
}
%>
<tr>
<td>用户名</td>
<td><input type="text" name="user_id"></td>
</tr>
<tr>
<td>密码</td>
<td><input type="password" name="passwd"></td>
</tr>
<tr>
<td colspan="" align="center"><input type="submit" value="登录"></td>
</tr> <tr>
<td colspan="" align="right">
<a href="register.jsp">注册</a>
</td>
</tr>
</table>
</form> </body>
</html>
do_login.jsp
<%@ page import="register.user.User"%>
<%@ page import="register.user.SqlUser"%>
<%@ page import="register.Factory"%>
<%
String user_id = request.getParameter("user_id");
String passwd = request.getParameter("passwd"); SqlUser sqlUser = Factory.getInstance().initSqlUser();
int index = sqlUser.checkUser(user_id, passwd);
if( index != - )
{
if(index == )
{
response.sendRedirect("login.jsp?info=1");
}else if(index == )
{
response.sendRedirect("login.jsp?info=2");
}else{
session.setAttribute("user_id", user_id);
response.sendRedirect("index.jsp");
}
}else{
response.sendRedirect("login.jsp");
}
%>
register.jsp
<%@ page language="java" contentType="text/html; charset=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=ISO-8859-1">
<title>register</title>
</head>
<body> <form action="do_register.jsp" method="post">
<table> <tr>
<td colspan="" align="center">注册</td>
</tr>
<tr>
<td>用户名</td>
<td><input type="text" name="user_id"></td>
</tr>
<tr>
<td>姓名</td>
<td><input type="text" name="name"></td>
</tr>
<tr>
<td>密码</td>
<td><input type="password" name="passwd"></td>
</tr>
<tr>
<td>确认密码</td>
<td><input type="password" name="rpasswd"></td>
</tr>
<tr>
<td>性别</td>
<td>
<input type="radio" value="" name="sex">男
<input type="radio" value="" name="sex">女
</td>
</tr>
<tr>
<td>生日</td>
<td>
年
<select name="year">
<%
int i=;
for(i=; i < ; i++)
{
%>
<option value="<%=i%>"><%=i %></option>
<%
}
%>
</select> 月
<select name="month">
<%
for(i=; i < ; i++)
{
%>
<option value="<%=i %>"><%=i %></option>
<%
}
%>
</select>
日
<select name="day">
<%
for(i=; i < ; i++)
{
%>
<option value="<%=i%>"><%=i%></option>
<%
}
%>
</select>
</td>
</tr>
<tr>
<td>自我介绍</td>
<td><input type="text" name="description"></td>
</tr>
<tr>
<td colspan=""><input type="submit" value="注册"></td>
</tr>
<tr>
<td colspan="" align="right"><a href="login.jsp">登录</a></td>
</tr> </table>
</form> </body>
</html>
do_register.jsp
<%@ page import="register.DateFormat"%>
<%@ page import="register.user.User"%>
<%@ page import="register.user.SqlUser"%>
<%@ page import="register.Factory"%>
<%
//获取传递过来的参数
String user_id = request.getParameter("user_id");
String passwd = request.getParameter("passwd");
String rpasswd = request.getParameter("rpasswd");
String sex = request.getParameter("sex");
String name = request.getParameter("name"); String year = request.getParameter("year");
String month = request.getParameter("month");
if(month.length() ==)month = ""+month;
String day = request.getParameter("day");
if(day.length() ==)day = ""+day;
String date = year+"-"+month+"-"+day; String description = request.getParameter("description"); //初始化user实例
User user = Factory.getInstance().initUser();
//初始化sqlUser实例
SqlUser sqlUser = Factory.getInstance().initSqlUser(); //将日期转为Long型
long birth = DateFormat.getDate(date);
if( sqlUser.checkRPwd(passwd, rpasswd) )
{ user.setUser_id(user_id);
user.setPassword(passwd);
user.setName(name);
user.setSex(sex);
user.setBirth(birth);
user.setDescription(description); if(sqlUser.saveUser(user))
{
session.setAttribute("user_id", user_id);
response.sendRedirect("index.jsp"); }else{
response.sendRedirect("register.jsp");
} }else{
response.sendRedirect("register.jsp");
} %>
logout.jsp
<%
session.removeAttribute("user_id");
response.sendRedirect("index.jsp");
%>
最新文章
- win7 去快捷箭头
- C# 基础知识总结
- VMware Workstation安装MAC OS X系统
- LightOJ1017 Brush (III)（DP）
- 【iCore3 双核心板】DEMO 1.0 测试程序发布
- 详解Adorner Layer(zz)
- c#中的反射
- centos x86_64--------------------------------系统调用
- 追踪CM_CONTROLCHANGE消息的产生和执行过程，可以较好的领会VCL的思想（就是到处通知，但耦合性很弱）
- Thinking in C++: 第1章 为什么C++会成功（改进了C的缺点，可复用C的知识与库，执行效率相当）
- SQL Server无法连接到(local)问题的解决的方法
- 使用jenkins实现持续集成
- 时间序列数据库rrd启动
- H5下拉刷新和上拉加载实现原理浅析
- 转载：深入浅出Zookeeper
- JavaScript：jklyDB
- am335x 10.1"电容touch 不能识别
- JavaScript基础知识笔记
- URL 生成带文字二维码
- Educational Codeforces Round 37-G.List Of Integers题解