📄 chexiao.java
字号:
package pp;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import pp.dbconn;
public class chexiao extends HttpServlet {
/**
* Constructor of the object.
*/
public chexiao() {
super();
}
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=gb2312");
PrintWriter out = response.getWriter();
dbconn conn=new dbconn();
ResultSet rs=null;
String accountNum=new String(request.getParameter("textfield").getBytes("ISO8859_1"));
String type=new String(request.getParameter("select").getBytes("ISO8859_1"));
String password=new String(request.getParameter("textfield2").getBytes("ISO8859_1"));
String sql="select PASSWORD,ACCOUNT_DISCRIM from Account where ACCOUNTNUMBER='"+accountNum+"'" ;
String sql1="select BALANCE from SAVINGSACCOUNT where ACCOUNTNUMBER='"+accountNum+"'" ;
//String sql0="select PASSWORD from BANKCUSTOMER where PASSWORD='"+password+"'" ;
String sql2="DELETE FROM SAVINGSACCOUNT WHERE ACCOUNTNUMBER='"+accountNum+"'";
String sql3="DELETE FROM ACCOUNT WHERE ACCOUNTNUMBER='"+accountNum+"'";
String sql4="DELETE FROM BANKCUSTOMER WHERE ACCOUNTNUMBER='"+accountNum+"'";
String sql5="DELETE FROM FDACCOUNT WHERE ACCOUNTNUMBER='"+accountNum+"'";
String sql9="DELETE FROM RDACCOUNT WHERE ACCOUNTNUMBER='"+accountNum+"'";
try {
rs=conn.executeQuery(sql);
if(rs.next()==true){
if(rs.getString("ACCOUNT_DISCRIM").equals(type)){
if(rs.getString("PASSWORD").equals(password)){
rs=conn.executeQuery(sql1);
rs.next();
double AA;
AA=rs.getDouble("BALANCE");
if(AA==0){
System.out.println("dsda");
if(type.equals("定期帐户")){
System.out.println("aaaa");
conn.executeUpdate(sql2);
conn.executeUpdate(sql3);
conn.executeUpdate(sql4);
conn.executeUpdate(sql5);
}else {
conn.executeUpdate(sql2);
conn.executeUpdate(sql3);
conn.executeUpdate(sql4);
conn.executeUpdate(sql9);
}
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE>");
out.println("</HEAD>");
out.println(" <BODY>");
out.println("操作已成功!<BR>");
out.println(" </BODY>");
out.println("</HTML>");
}else{
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE>");
out.println("</HEAD>");
out.println(" <BODY>");
out.println("该帐户尚有余额,请先提取所有余额!<BR>");
out.println(" </BODY>");
out.println("</HTML>");
}
}else{
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE>");
out.println("</HEAD>");
out.println(" <BODY>");
out.println("密码不正确!<BR>");
out.println(" </BODY>");
out.println("</HTML>");
}
}else{
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE>");
out.println("</HEAD>");
out.println(" <BODY>");
out.print("帐户类型与帐号不匹配!<BR>");
out.println(" </BODY>");
out.println("</HTML>");
}
}else{
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE>");
out.println("</HEAD>");
out.println(" <BODY>");
out.print("该帐户不存在<BR>");
out.println(" </BODY>");
out.println("</HTML>");
}
conn.closeConn();
}catch(Exception e){
e.printStackTrace();
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request,response);
}
public void init() throws ServletException {
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -