validate.jsp

这是一个用JSP编写的登录页面 这是一个用JSP编写的登录页面

<%@ page contentType="text/html;charset=gb2312" language="java" import="java.sql.*,java.awt.*,java.awt.event.*,javax.swing.*" %>
<%!
String name="";
String pass="";

%>

<%

name=request.getParameter("t1");
pass=request.getParameter("t2");
if(name.equals("")||pass.equals(""))
 {
				JOptionPane.showMessageDialog(null,"对不起,用户名或密码不能为空请重新输入");
				response.sendRedirect("Login.jsp");				
}


 else{
try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			Connection con=DriverManager.getConnection("jdbc:odbc:zhao");
			Statement stmt=con.createStatement();
			String sql="select * from tb_user where e_name='"+name+"' and e_pass='"+pass+"'";
			ResultSet rs=stmt.executeQuery(sql);
			while(rs.next())
			{
			    String n=rs.getString("e_name");
            	String p=rs.getString("e_pass");
            	if(n.equals(name)&&p.equals(pass))
            	{
            			response.sendRedirect("welcome.jsp");
            	}
                else
            	{           	
                JOptionPane.showMessageDialog(null,"对不起,用户名或密码不正确");   
            	response.sendRedirect("Login.jsp");
            		
            	}
            	
            }
            
			con.close();
			stmt.close();
		}
	
		catch(Exception o)
		{
		JOptionPane.showMessageDialog(null,"1111111111");
        response.sendRedirect("Login.jsp");
		}
}
 %>