这是什么有关问题，求救啊，看在我是做毕业设计的份上，请高手帮忙啊！
日期：2014-05-18 浏览次数：20644 次
请问大家这是什么问题，求救啊，看在我是做毕业设计的份上，请高手帮忙啊！！！
login.config.jsp
<%@ page contentType= "text/html; charset=GBK " import= "java.sql.* "%>
<jsp:useBean id= "conndb " scope= "page " class= "dbconn.conndb ">
</jsp:useBean>
<html>
<head>
<title>
login.config
</title>
</head>
<body bgcolor= "#ffffff ">
<%
try{
ResultSet rs=conn.executeQuery( "select * from user_info where Username= ' "+Username+ " ' ");
if(rs.next()){
String Password=request.getParameter( "Password ");
if(Password.equals(rs.getString( "password "))){
session.setAttribute( "UserName ",Username);
response.sendRedirect( "index.jsp ");
}else{
out.println( " <script language= 'javascript '> alert( '您输入的用户名或密码错误，请与管理员联系! ');window.location.href= 'index.jsp '; </script> ");
}
}else{
out.println( " <script language= 'javascript '> alert( '您输入的用户名或密码错误，或您的帐户已经被冻结，请与管理员联系! ');window.location.href= 'index.jsp '; </script> ");
}
}catch(Exception e){
out.println( " <script language= 'javascript '> alert( '您的操作有误! ');window.location.href= 'index.jsp '; </script> ");
}
%>
</body>
</html>
javabean
package dbconn;
import java.sql.*;
import sun.jdbc.odbc.JdbcOdbcDriver;
public class conndb {
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
public conndb() {
try {
Class.forName( "sun:jdbc:odbc:JdbcOdbcDriver ");
} catch (java.lang.ClassNotFoundException e) {
System.err.print(e.getMessage());
}
}
public ResultSet executeQuery(String sql){
try {
conn = DriverManager.getConnection( "jdbc:odbc:mydb ", "sa ", "sa ");
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
} catch (SQLException ex) {
System.err.print(ex.getM
login.config.jsp
<%@ page contentType= "text/html; charset=GBK " import= "java.sql.* "%>
<jsp:useBean id= "conndb " scope= "page " class= "dbconn.conndb ">
</jsp:useBean>
<html>
<head>
<title>
login.config
</title>
</head>
<body bgcolor= "#ffffff ">
<%
try{
ResultSet rs=conn.executeQuery( "select * from user_info where Username= ' "+Username+ " ' ");
if(rs.next()){
String Password=request.getParameter( "Password ");
if(Password.equals(rs.getString( "password "))){
session.setAttribute( "UserName ",Username);
response.sendRedirect( "index.jsp ");
}else{
out.println( " <script language= 'javascript '> alert( '您输入的用户名或密码错误，请与管理员联系! ');window.location.href= 'index.jsp '; </script> ");
}
}else{
out.println( " <script language= 'javascript '> alert( '您输入的用户名或密码错误，或您的帐户已经被冻结，请与管理员联系! ');window.location.href= 'index.jsp '; </script> ");
}
}catch(Exception e){
out.println( " <script language= 'javascript '> alert( '您的操作有误! ');window.location.href= 'index.jsp '; </script> ");
}
%>
</body>
</html>
javabean
package dbconn;
import java.sql.*;
import sun.jdbc.odbc.JdbcOdbcDriver;
public class conndb {
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
public conndb() {
try {
Class.forName( "sun:jdbc:odbc:JdbcOdbcDriver ");
} catch (java.lang.ClassNotFoundException e) {
System.err.print(e.getMessage());
}
}
public ResultSet executeQuery(String sql){
try {
conn = DriverManager.getConnection( "jdbc:odbc:mydb ", "sa ", "sa ");
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
} catch (SQLException ex) {
System.err.print(ex.getM
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
