jsp application在java,分别用java Application 及 JSP调用jav

//java bean

//file name: faq.java

import java.sql.*;

public class faq {

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

http://www.gaodaima.com/40179.html分别用java Application 及 jsP调用jav

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

我的FAQ !

这是我的FAQ!

faq workM = new faq();

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

String tt;

while (RS.next()) {

tt = RS.getString("Answer");

out.print("

" + RS.getString("Subject") + "");

out.print("

" + tt + "

");

}

RS.close();

%>

欢迎大家阅读《分别用java Application 及 JSP调用jav》,跪求各位点评,若觉得好的话请收藏本文，by 搞代码

微信 赏一包辣条吧~

支付宝 赏一听可乐吧~