login.jsp

asp做的的一个网站登录 连接数据库就可以直接使用了

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*" %>
<%
  Connection conn=null;
  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  String strConn="jdbc:odbc:sun";
  conn=DriverManager.getConnection(strConn,"","");
  Statement stmt=conn.createStatement();
  String name=request.getParameter("name");
  String pass=request.getParameter("pass");
  ResultSet rs=stmt.executeQuery("SELECT * FROM login where loginname='"+name+"' and loginpass='"+pass+"'");
  if(rs.next())
     {
	%>
     <jsp:forward page="book.jsp"/>
	<%
     }
  out.println("<script lanaguage='javascript'>alert('用户名或密码错误!请重新输入');window.location.href='login.html';</script>");
  rs.close();
  stmt.close();
  conn.close();
%>