📄 index.jsp

📁 一个小程序

💻 JSP

字号:

<BODY background="images/bg1.gif" text="#CC6600" >
<div align="center">
  <%@ page contentType="text/html; charset=gb2312" %>
  <%@page import="java.sql.*"%>
  <%!
	String username;
	String password;
	String username2;
	String password2;
	
%>
  <%
	username=request.getParameter("username");
	password=request.getParameter("password");
	
	request.getSession(true);
	session.putValue("name",username);
	
	String DBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
	String ConnStr="jdbc:odbc:index";
	String sql="select * from zhuce where username like ";
	try	
		{
			Class.forName(DBDriver);
		}
	catch(java.lang.ClassNotFoundException e)
		{
			System.err.println("database:"+e.getMessage());
		//	out.println("加载驱动失败!");
		}
	try
		{
			Connection conn=DriverManager.getConnection(ConnStr," "," ");
			ResultSet rs;
			Statement stmt=conn.createStatement();
			rs=stmt.executeQuery(sql+"'"+username+"'");

	while(rs.next())
			{
				username2=rs.getString(1);
				password2=rs.getString(2);
				
		}
			rs.close();
			stmt.close();
			conn.close();
		}
	catch(SQLException e)
		{
			System.err.println("executeQuery:"+e.getMessage());
			out.println("读出数据失败!");
		}
%>
  <%
	if(username.equals(username2) && password.equals(password2))
	  { response.sendRedirect("index1.htm");
	  
	}
		
	else
	  if(username.equals(username2) && !password.equals(password2))
	   {out.println("<p>"+"密码输入错误，登录失败!"+"<p>"+"请重新登录");
	   response.setHeader("Refresh","2;URL=index.htm");}
	   else
	   {out.print("<p>"+"对不起，您不是会员，请先注册后再登陆");
	  response.setHeader("Refresh","2;URL=zhuce.htm");}

%>
</div>




</BODY>
</HTML>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -