jsp bean使用范例

来源：互联网发布：阿里软件王涛编辑：程序博客网时间：2024/06/02 11:42

<%@ page contentType="text/html;charset=GBK" language="java" import="java.sql.*,java.util.Date" errorPage="" %>
<jsp:useBean id="mdb" class="ckstudio.db.faq" scope="page"/>
<%
boolean foundeer=false;
String user_name,user_pass;
if(!foundeer){

    if (session.getAttribute("user_name")==null){
    user_name=request.getParameter("user_name");
    user_pass=request.getParameter("user_pass");

if(user_name==null || user_pass==null){
 out.print("用户名和用户密码不能为空!");
 foundeer=true;
}

    String sql="select * from member where user_name='"+user_name+"'";
    ResultSet rs;
    rs=mdb.executeQuery(sql);

if(!rs.next()){
 out.print("你输入的用户不存在!");
 foundeer=true;
}
else{
 if(user_pass.equals(rs.getString("user_pass"))){
 session.setAttribute("user_name",""+rs.getString("user_name")+"");
 session.setAttribute("user_type","yes");
 String sql1="update member set user_lasttime='"+((new java.util.Date()).toLocaleString())+"',user_lastip='"+(String)request.getRemoteHost()+"' where user_name='"+user_name+"'";
 mdb.executeUpdate(sql1);
 response.sendRedirect("index.jsp");
 }
 else{
 out.print("你输入的密码错误!");
 foundeer=true;
}
}

}else response.sendRedirect("index.jsp");

}if(foundeer){
%> <a href="javascript:history.go(-1)">重新登陆</a><%
}

-----------------------------------------------------------------------------

// Decompiled by Jad v1.5.7g. Copyright 2000 Pavel Kouznetsov.
// Jad home page: http://www.geocities.com/SiliconValley/Bridge/8617/jad.html
// Decompiler options: packimports(3) fieldsfirst ansi
// Source File Name: faq.java

package ckstudio.db;

import java.io.PrintStream;
import java.sql.*;

public class faq
{

    String sDBDriver;
    String sConnStr;
    Connection conn;
    ResultSet rs;

    public faq()
    {
        sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
        sConnStr = "jdbc:odbc:shnxn";
        conn = null;
        rs = null;
        try
        {
            Class.forName(sDBDriver);
        }
        catch(ClassNotFoundException classnotfoundexception)
        {
            System.err.println("faq(): " + classnotfoundexception.getMessage());
        }
    }

    public void executeInsert(String s)
    {
        try
        {
            conn = DriverManager.getConnection(sConnStr);
            Statement statement = conn.createStatement();
            int i = statement.executeUpdate(s);
        }
        catch(SQLException sqlexception)
        {
            System.err.println("faq.executeUpdate:" + sqlexception.getMessage());
        }
    }

    public ResultSet executeQuery(String s)
    {
        rs = null;
        try
        {
            conn = DriverManager.getConnection(sConnStr);
            Statement statement = conn.createStatement(1004, 1008);
            rs = statement.executeQuery(s);
        }
        catch(SQLException sqlexception)
        {
            System.err.println("aq.executeQuery: " + sqlexception.getMessage());
        }
        return rs;
    }

    public void executeDelete(String s)
    {
        try
        {
            conn = DriverManager.getConnection(sConnStr);
            Statement statement = conn.createStatement();
            statement.executeUpdate(s);
        }
        catch(SQLException sqlexception)
        {
            System.err.println("faq.executeDelete: " + sqlexception.getMessage());
        }
    }

    public int executeUpdate(String s)
    {
        int i = 0;
        try
        {
            conn = DriverManager.getConnection(sConnStr);
            Statement statement = conn.createStatement();
            i = statement.executeUpdate(s);
        }
        catch(SQLException sqlexception)
        {
            System.err.println("faq.executeDelete: " + sqlexception.getMessage());
        }
        return i;
    }

    public void Close()
    {
        try
        {
            if(rs != null)
                rs.close();
            if(conn != null)
                conn.close();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("faq.executeDelete: " + sqlexception.getMessage());
        }
    }
}