chklog.jsp

一个 网上答疑系统 与大家分享 jsp+sql

<%@ page contentType="text/html; charset=GB2312" 
		language="java"
		import = "java.util.*, java.text.*"
		import = "java.sql.*,MyBean.dbcon"
		%>
<%
String userid=request.getParameter("userid");
String pwd=request.getParameter("pwd");
dbcon dbc=new dbcon();
String sql = "SELECT * FROM userinfo WHERE userid='"+userid+"' and userpwd='"+pwd+"'" ;

        ResultSet rs=dbc.executeQuery(sql);
              
		try
		{

			if(rs.next())
			{
				session.setAttribute("suserid",userid);
                session.setAttribute("username",rs.getString("username"));
                session.setAttribute("userq",rs.getString("userq"));
                
                            
			}
			else
			{
               %>
			   <script language = "JavaScript">alert("用户名和密码错误！");</script>
			   <%
			}
			rs.close() ;
	
		}
				catch(Exception e)
		{}

out.println("<script>location.href='index.jsp'</script>");
%>