/*
** For user change TMD password
** Class: ChangePasswd
** Author: Yuping Zhu
** Date: 11-03-1999
*/
package ascdb.users;
import java.sql.*;
import java.io.*;
import javax.servlet.http.*;
import javax.servlet.*;
import oracle.html.*;
import ascdb.conf;
public class ChangePasswd extends HttpServlet
{
public void doGet(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException
{
res.setContentType("text/html");
PrintWriter out = res.getWriter();
if ((req.getParameter("passwd")) == null)
{
out.println(InputForm());
return;
}
conf dbconf = new conf(req);
String uid = req.getParameter("uid");
String passwd = req.getParameter("passwd");
String ssan = req.getParameter("ssan");
String passwd1 = req.getParameter("passwd1");
String passwd2 = req.getParameter("passwd2");
try {
//load JDBC driver
Class.forName(dbconf.JdbcDriver);
//create a connection
Connection conn =
DriverManager.getConnection(dbconf.ConnectStr,dbconf.DBName,dbconf.DBPassword);
//create a statement
Statement stmt = conn.createStatement();
ResultSet rset = stmt.executeQuery("select oracle_uid from user_info where oracle_uid='" + uid + "' and tmd_password='" + passwd + "' and ssan_last4='" + ssan + "'");
out.println("");
int count;
if (rset.next())
{
count = stmt.executeUpdate("update addl_users set tmd_password ='" + passwd1 + "' where oracle_uid='" + uid +"'");
if (count == 1)
out.println("Your password has been changed!");
else
out.println("Can not change your password!");
}
else
out.println("Your oracle_uid, or old password, or 4-digit number is wrong!");
out.println(BackHome() + "");
}
catch (ClassNotFoundException e) {
out.println("Can not load JDBC Driver!");
}
catch (SQLException e) {
out.println(e.getMessage());
}
}
private HtmlStringBuffer InputForm()
{
HtmlStringBuffer HTMLStr = new HtmlStringBuffer();
HTMLStr.appendln("");
HTMLStr.appendln("User Change Password");
HTMLStr.appendln("");
HTMLStr.appendln("");
HTMLStr.appendln("You can change your TMD password now ...");
HTMLStr.appendln("");
return HTMLStr;
}
private HtmlStringBuffer BackHome()
{
HtmlStringBuffer HTMLBuf = new HtmlStringBuffer();
HTMLBuf.appendln("");
return HTMLBuf;
}
public void doPost(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException
{
doGet(req,res);
}
}