分别用java Application 及 JSP调用javaBean的例子

最新推荐文章于 2024-08-16 23:08:28 发布

ts2794

最新推荐文章于 2024-08-16 23:08:28 发布

阅读量364

点赞数

分类专栏： J2SE 文章标签： application java jsp string class jdbc

J2SE 专栏收录该内容

14 篇文章 0 订阅

订阅专栏

//java bean

//file name: faq.java

import java.sql.*;

public class faq {

    String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";

    String sConnStr = "jdbc:odbc:faq";

    Connection conn = null;

    ResultSet rs = null;

    public faq() {

    try {

        Class.forName(sDBDriver);

    }catch(java.lang.ClassNotFoundException e) {

        System.err.println("faq(): " + e.getMessage());
    }

}

    public ResultSet executeQuery(String sql) {

        rs = null;

        try {

            conn = DriverManager.getConnection(sConnStr);

            Statement stmt = conn.createStatement();

            rs = stmt.executeQuery(sql);

        }catch(SQLException ex) {

            System.err.println("aq.executeQuery: " + ex.getMessage());

        }

        return rs;

    }

}

//java Application

//file name: testfaq.java

import java.sql.*;

class getRs

{

    public static String Answer;

    public static String Subject;

    public static String[][] rsArray = new String[9][2];;

    public static int n = 0;

    getRs(){

        try    {

            faq workM = new faq();

            ResultSet oRs = workM.executeQuery("SELECT * FROM faq");

            //System.out.println(oRs.getCount());

            while (oRs.next()){

            System.out.println(oRs.getString("Answer"));

            System.out.println(oRs.getString("Subject"));

            n=n+1;

            }

        }catch (SQLException ex)

        {

            System.out.println("error:"+ex);

        }

    }

}

public class testfaq {

    public static void main(String[] args) {

        getRs aa = new getRs();

    }

}

//jsp

//file name: testfaq.jsp

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

<title>我的FAQ !</title>

</head>

<body>

<p><b>这是我的FAQ!</b></p>

<%@ page contentType="mimeType; charset=gb2312"%>

<%@ page language="java" import="java.sql.*" %>

<%

faq workM = new faq();

ResultSet RS = workM.executeQuery("SELECT * FROM faq");

String tt;

while (RS.next()) {

tt = RS.getString("Answer");

out.print("<LI>" + RS.getString("Subject") + "</LI>");

out.print("<pre>" + tt + "</pre>");

}

RS.close();

%>

</body>

</html>

ts2794

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
分别用java Application 及 JSP调用javaBean的例子

//java bean//file name: faq.javaimport java.sql.*;public class faq { String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; String sConnStr = "jdbc:odbc:faq"; Connection conn = null; ResultSet
复制链接

扫一扫

专栏目录