📄 denglu.jsp

📁 网上花店销售系统

💻 JSP

字号:

<BODY bgcolor="ffdcdc" >
<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");
	
	String DBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
	String ConnStr="jdbc:odbc:zhuce";
	String sql="select * from huiyuan 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);
				
				//out.print("<tr>"+"<td>"+username2+"<td>"+password2+"<td>"+sex+"+"</tr>");
		}
			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("index.jsp");
	  
	  session.setAttribute("username",username);}
		
	else
	   out.println("<p>"+"密码输入错误，登录失败!"+"<p>"+"请重新登录");
	   response.setHeader("Refresh","3;URL=index.htm");
%>
</div>
<p><a href="index.htm">返回登录页</a></p>
<p>您将在3秒钟后返回登录页</p>


</BODY>
</HTML>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -