📄 login.java

📁 网上银行 JSP开发~JAVASript貌似有点多

💻 JAVA

字号:

package pp;


import java.io.IOException;
import java.io.PrintWriter;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.mail.Session;
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 javax.servlet.http.HttpSessionEvent;

public class login extends HttpServlet {
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		response.setContentType("text/html;charset=gb2312");
		PrintWriter out = response.getWriter();
		dbconn conn=new dbconn();
        String cardnumber=request.getParameter("cardnumber");
       // Statement stmt=conn.getCon();
        ResultSet rs=null;
        boolean f=false;
        String sql="select * from BANKCUSTOMER where username='"+cardnumber+"'";
      
        try {
			rs=conn.executeQuery(sql);
			while(rs.next()){
				if(request.getParameter("password").equals(rs.getString("PASSWORD"))){
					f=true;
					break;
				}
				}
			if(f){
				HttpSession session=request.getSession();
				
	            session.setAttribute("username",rs.getString(2));
	            session.setAttribute("accountnum",rs.getString(1));
	            response.sendRedirect("yonghu.jsp");
			}
			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("登录失败!"+cardnumber+"<BR>");
				out.println("  </BODY>");
				out.println("</HTML>");
			}
			conn.closeConn();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
	}
}

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -