<
%@page import="com.sun.org.apache.bcel.internal.generic.Type"%>
<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="UTF-8"%>
<%
request.setCharacterEncoding("utf-8");
out.print("登陆处理页面!!");
//1.取得表单提交过来的数据
String name=request.getParameter("name");
String pwd=request.getParameter("pwd");
//2.加载jdbc驱动
Class.forName("com.mysql.jdbc.Driver");
//3.使用驱动管理类创建链接对象
String url="jdbc:mysql://127.0.0.1:3306/news?user=root&password=root";
DriverManager.getConnection(url);
Connection conn=DriverManager.getConnection(url);
//4.通过链接对象,创建执行对象
Statement stm=conn.createStatement();
//5.通过命令执行对象 执行sql脚本
String sql="select *from users where uname='"+name+"' and upwd='"+pwd+"'";
//6.执行查询语句 得到结果集
ResultSet rs=stm.executeQuery(sql);
//7.判断结果集是否有数据
if(rs.next()){
//out.print("alert("+name+"登陆成功!)");
session.setAttribute("NAME",name);
if( name.equals("admin")){
response.sendRedirect("admin.jsp");
}
%>
<script Type="text/javascript">
alert("登陆成功");
open("index.jsp")
</script>
<%
}else{
%>
<script Type="text/javascript">
alert("登陆失败!");
open("index.jsp")
</script>
<%
}
rs.close();
stm.close();
conn.close();
<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="UTF-8"%>
<%
request.setCharacterEncoding("utf-8");
out.print("登陆处理页面!!");
//1.取得表单提交过来的数据
String name=request.getParameter("name");
String pwd=request.getParameter("pwd");
//2.加载jdbc驱动
Class.forName("com.mysql.jdbc.Driver");
//3.使用驱动管理类创建链接对象
String url="jdbc:mysql://127.0.0.1:3306/news?user=root&password=root";
DriverManager.getConnection(url);
Connection conn=DriverManager.getConnection(url);
//4.通过链接对象,创建执行对象
Statement stm=conn.createStatement();
//5.通过命令执行对象 执行sql脚本
String sql="select *from users where uname='"+name+"' and upwd='"+pwd+"'";
//6.执行查询语句 得到结果集
ResultSet rs=stm.executeQuery(sql);
//7.判断结果集是否有数据
if(rs.next()){
//out.print("alert("+name+"登陆成功!)");
session.setAttribute("NAME",name);
if( name.equals("admin")){
response.sendRedirect("admin.jsp");
}
%>
<script Type="text/javascript">
alert("登陆成功");
open("index.jsp")
</script>
<%
}else{
%>
<script Type="text/javascript">
alert("登陆失败!");
open("index.jsp")
</script>
<%
}
rs.close();
stm.close();
conn.close();