给你个例子:
在classpath中加入classes12.jar的绝对路径就可以<%@ page contentType="text/html;charset=gb2312" %>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=gb2312">
<title>登录验证</title>
<link rel="stylesheet" href="bbs.css" type="text/css">
</head>
<body>
<%@ page language="java" import="java.sql.*"%>
<%
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@192.168.1.41:1521:AddrBook";
//AddrBook为你的数据库的SID
String user="system";
String pwd="manager1";
Connection conn= DriverManager.getConnection(url,user,pwd);
String name1=request.getParameter("username");
name1= new String(name1.getBytes("ISO8859-1"),"GBK");
//String nowtime=trim(left(replace(replace(replace(now(),":","")," ",""),"-",""),10))
session.setAttribute("username",name1);
String password=request.getParameter("password");
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from IM_Users where UserName='"+name1+"' and Password='"+password+"'";
ResultSet rs=stmt.executeQuery(sql);
if (rs.next()){
response.sendRedirect("rootok.jsp?username="+name1+"");
rs.close();
%>
<%}
else{
rs.close();
//session.setAttribute("root_message","<font color=red>用户名或密码错误!</font>");
response.sendRedirect("pwerror.htm");
%>
<%}%>
</body>
</html>
在classpath中加入classes12.jar的绝对路径就可以<%@ page contentType="text/html;charset=gb2312" %>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=gb2312">
<title>登录验证</title>
<link rel="stylesheet" href="bbs.css" type="text/css">
</head>
<body>
<%@ page language="java" import="java.sql.*"%>
<%
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@192.168.1.41:1521:AddrBook";
//AddrBook为你的数据库的SID
String user="system";
String pwd="manager1";
Connection conn= DriverManager.getConnection(url,user,pwd);
String name1=request.getParameter("username");
name1= new String(name1.getBytes("ISO8859-1"),"GBK");
//String nowtime=trim(left(replace(replace(replace(now(),":","")," ",""),"-",""),10))
session.setAttribute("username",name1);
String password=request.getParameter("password");
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from IM_Users where UserName='"+name1+"' and Password='"+password+"'";
ResultSet rs=stmt.executeQuery(sql);
if (rs.next()){
response.sendRedirect("rootok.jsp?username="+name1+"");
rs.close();
%>
<%}
else{
rs.close();
//session.setAttribute("root_message","<font color=red>用户名或密码错误!</font>");
response.sendRedirect("pwerror.htm");
%>
<%}%>
</body>
</html>
1:ORACLE我不会配啊,我装了,但不会配,有个SQL PLUS像查询分析器,有个DBA Studio的但是链不上,不是有SYSTEM,MANAGER这个用户的吗?交我怎么配啊
2:应该还有一个页面吗?输入用户名和密码的啊,这只是处理的啊,在数据库中找有没有这个用户,能不能把那个页面的代码也贴一下啊
3:response.sendRedirect("pwerror.htm");这样行吗?我想问一下response与HttpServerltResponse的关系?