我也刚学,你的程序我没有看懂。我把我自己的给你看一下。数据库是MS SQL。<%@ page import="java.lang.*, java.io.*,java.sql.*, java.util.*" contentType="text/html;charset=gb2312" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>认证</title>
</head>
<body>
<% String Name=request.getParameter("name");
String Password=request.getParameter("password");
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=muludengju";
String user="sa";
String password="151961404";
Connection conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from mima where name='"+Name+"' and password='"+Password+"'";
ResultSet rs=stmt.executeQuery(sql);
if(rs.next()){
out.print("恭喜你,登陆成功!");
}
else{
out.print("抱歉!登陆不成功!");
}
rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>认证</title>
</head>
<body>
<% String Name=request.getParameter("name");
String Password=request.getParameter("password");
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=muludengju";
String user="sa";
String password="151961404";
Connection conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from mima where name='"+Name+"' and password='"+Password+"'";
ResultSet rs=stmt.executeQuery(sql);
if(rs.next()){
out.print("恭喜你,登陆成功!");
}
else{
out.print("抱歉!登陆不成功!");
}
rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
解决方案 »
- window7旗舰版安装tomcat7.0.29启动没错,却打不开欢迎界面
- 今天面试被问到的一个问题,各位帮忙解决一下,在线等。
- struts2后台效验问题
- 新增jsp根目录
- struts写的web应用tomcat部署,是不是要用linux包?
- 呵呵 计算日期问题 知道周几计算今天是几号
- servlet类在浏览器中运行后如何用程序实现自动关闭本浏览器窗口啊??
- jrun下运行webservice出错咯,请高手指点啊~~急!
- 如何在TOMCAT5.5.1下显示自己的JSP网页?(不明白的朋友请不要随意回复,我看不过来啊)
- 急,weblogic配置好了,为什么运行不起来
- 北大青鸟ACCP4.0软件工程师登陆南京
- hibernate高手请进,exception setting property value with CGLIB 问题
select * from table where name='"+name+"'
然后再比对密码
"select id from userinfo where name='"+name+"' and password='"+password+"'";
<%@ page import="java.sql.*" contentType="text/html;charset=GB2312" %>
<%@ page language="java" import="java.sql.*" %>
<%@ include file="index.jsp"%>
<html>
<head>
<title>登录界面</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="ffffff"><jsp:useBean id="LoadBean" scope="page" class="db.DbConnection" />
<%
System.out.println(sql);
LoadBean.openConnection();
String name=request.getParameter("name");
String password=request.getParameter("password"); name=name.trim();
password=password.trim(); session.putValue("name",name);
session.putValue("password",password);
String sql="select * from userinfo where name='"+name+"' and password='"+password+"'";
ResultSet rs=LoadBean.executeQuery(sql);
if(rs.next()){
rs.close();
LoadBean.close();
response.sendRedirect("manager.jsp");
}
else
{
rs.close();
LoadBean.close();
response.sendRedirect("index.jsp");
}
%>
</body>
</html>
因为select count(*)一定会返回一条记录集,(即使数用户和密码错误,也会返回“0”),所以if(rs.next())永远会为true,不可能会返因到错误页面的