新手求救：用jsp+servlet完成一个用户管理及登陆功能

wulaozi 2010-02-05 08:59:40

对于稍有经验的程序员来说，这是道很简单的题目，可我是新手，但却急用这个程序，还望高手指点！
如果你有意可把源码以附件形式发送给我，最好是Eclipse开发的~

我的邮箱：137488335@qq.com

采用jsp+servlet完成一个用户管理及登陆功能，包括用户的增加、删除、修改以及登陆验证功能。
用户表结构如下：
Operater：
Operatorid 用户表的id
Userid 登陆用户名
Operatorname 用户名
Password 登陆密码
Email 邮件
Tel 电话

用户增加、修改时对邮件、电话进行简单的js判断
系统中用户登陆名不能重复
数据库以mysql、sqlserver、oracle 任何一种，数据库链接采用连接池方式进行。

...全文

374 14 打赏收藏转发到动态举报

写回复

用AI写文章

14 条回复

切换为时间正序

请发表友善的回复…

发表回复

Fairy_dy 2010-02-06

打赏
举报

在web.xml里面配置下LoginServlet，下面是LoginServlet的代码

import java.io.IOException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import com.szty.hllsys.DBConnectionManage;

public class LoginServlet extends HttpServlet
{
public LoginServlet()
{
super();
}

public void destroy()
{
}

public void init() throws ServletException
{
}

public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException
{
this.doPost(request, response);
}

public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException
{
response.setContentType("text/html; charset=gb2312");
RequestDispatcher rd;
String pwd = request.getParameter("pwd");
String loginname = request.getParameter("loginname");
loginname = new String(loginname.getBytes("ISO8859-1"), "GBK");

String password = request.getParameter("pwd");

UserBean user = new UserBean();
user.setUsername(loginname);
user.setPassword(password);

HttpSession session = request.getSession(true);

Connection conn = null;
String flag = "0";//0 成功 1 失败
try
{
if (checkUser(conn, loginname, password))
{
session.setAttribute("loginname", loginname);
session.setAttribute("password", password);

rd = request.getRequestDispatcher("/index.jsp");
rd.forward(request, response);
flag = "0";
return;
}
else
{
flag = "1";
request.setAttribute("flag", flag);

rd = request.getRequestDispatcher("/default.jsp");
rd.forward(request, response);

}
}
catch (Exception e)
{
e.printStackTrace();
}

}

public boolean checkUser(Connection conn, String username, String password)
throws Exception
{
ResultSet rs = null;
Statement stmt = null;
String sql = "select * from SystemUser where username='" + username
+ "' and password='" + password + "'";
// 获取数据库连接
conn = DBConnectionManage.getConnection();
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);

if (rs.next())
{
UserBean user = new UserBean();

rs.close();
stmt.close();
conn.close();
return true;
}
else
{
conn.close();
return false;
}

}

public int getUserIdByName(String username, String password)
throws Exception
{
ResultSet rs = null;
Statement stmt = null;
Connection conn=null;
String sql = "select userId from SystemUser where username='" + username
+ "' and password='" + password + "'";
// 获取数据库连接
conn = DBConnectionManage.getConnection();
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);

if (rs.next())
{
int userId=Integer.parseInt(rs.getString(1));
rs.close();
stmt.close();
conn.close();

return userId;
}
else
{
rs.close();
stmt.close();
conn.close();
return 0;
}

}

}

wulaozi 2010-02-06