validate1.jsp

这是我用JSP编写的登录界面 这是我用JSP编写的登录界面

<%@ page contentType="text/html;charset=GBK" %>
<%@ page import="java.sql.*,javax.swing.*,java.awt.*" %>
<%!
String name=new String();
String pass=new String();

%>

<%
name=request.getParameter("t1");
pass=request.getParameter("t2");
try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			Connection con=DriverManager.getConnection("jdbc:odbc:book");
			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())
			{
				response.sendRedirect("main.jsp");
            	
			}
			con.close();
			stmt.close();
		}
		catch(Exception o)
		{
		JOptionPane.showMessageDialog(null,o.getMessage());
        response.sendRedirect("hello.jsp");
		}
		
 %>