alterpwd.java

J2EE平台是一种比较 优秀的开发平台 此为其上一个比较大的案例开发

package UserAdmin;
/**
功能：注册用户修改密码
*/
import java.io.FileInputStream;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Properties;

import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
/**
 * @version 	1.0
 * @author
 */
public class AlterPwd extends HttpServlet
{
	/**
	* @see javax.servlet.http.HttpServlet#void (javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse)
	*/
	public void doGet(HttpServletRequest req, HttpServletResponse res)
		throws ServletException, IOException
	{
		res.setContentType("text/html;charset=gb2312");
		HttpSession session = req.getSession();
		ServletContext sc = session.getServletContext();
		PrintWriter out = res.getWriter();
		//获取提交信息；由于编码问题，不能直接将取得的信息存入数据库，必须先将其编码转换成数据库能识别的编码；
		String username = (String) session.getAttribute("user");
		//在用户输入用户名的时候最好能将输入的前后空格消去*
		String oldpassword =
			new String(req.getParameter("oldpassword").getBytes(), "ISO8859-1");
		String newpassword =
			new String(req.getParameter("newpassword").getBytes(), "ISO8859-1");
		//获取服务器信息；
		Properties properties = new Properties();
		properties.load(new FileInputStream(sc.getRealPath("conn.properties")));
		String DriverName = properties.getProperty("DriverName");
		String BaseName = properties.getProperty("BaseName");
		String ServerName=properties.getProperty("ServerName");
		String port = properties.getProperty("port");
		String uName = properties.getProperty("username");
		String psd = properties.getProperty("password");
		try
		{
			//建立数据库连接；
			DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
			//建立数据库连接；
			String url =
				"jdbc:oracle:thin:@" + ServerName + ":" + port + ":" + BaseName;
			Class.forName(DriverName);
			Connection jbc = DriverManager.getConnection(url, uName, psd);
			String search =
				"select * from USER_REG where USER_NAME=? and USER_PWD=?";
			PreparedStatement ps;
			ps = jbc.prepareStatement(search);
			ps.setString(1, username);
			ps.setString(2, oldpassword);
			ResultSet rs = ps.executeQuery();
			boolean isEmpty = !rs.next();
			if (!isEmpty)
			{
				//用户名和密码正确，将新密码写入数据库；
				PreparedStatement psp;
				psp =
					jbc.prepareStatement(
						"update USER_REG set (USER_PWD)=? where USER_NAME=?");
				psp.setString(1, newpassword);
				psp.setString(2, username);
				psp.executeUpdate();
				psp.close();
				//返回修改成功信息；
				res.sendRedirect(res.encodeURL("./UserAdmin/alterpwdok.jsp"));
			}
			else
			{
				//提示用户用户名或密码不正确；
				res.sendRedirect(
					res.encodeURL("./UserAdmin/alterpwderror.jsp"));
			}
			ps.close();
			jbc.close();
		}
		catch (Exception ex)
		{
			throw new ServletException(ex.getMessage());
		}
	}
	/**
	* @see javax.servlet.http.HttpServlet#void (javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse)
	*/
	public void doPost(HttpServletRequest req, HttpServletResponse resp)
		throws ServletException, IOException
	{
	}
}