jsp访问java中数据_JSP中通过JavaBean访问数据库

-----------------faq.java

//java bean

//file name: faq.java

package Test;

import java.sql.*;

public class faq {

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

String sConnStr = "jdbc:odbc:wz";

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,"liuyz","liuyz1");

Statement stmt = conn.createStatement();

rs = stmt.executeQuery(sql);

}catch(SQLException ex) {

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

}

return rs;

}

}

----------------------Hello.java

//java bean

//file name: faq.java

package Test;

public class Hello {

String h="test";

public void setHello(String s)

{

h=s;

}

public String getHello()

{

return h;

}

public static void main (String[] args)

{

Hello ho= new Hello();

System.out.println(ho.h);

}

}

---------------------testfaq2.jsp

我的FAQ !

这是我的FAQ!

String str = "Hello,欢迎学习JSP！";

Hello1.setHello(str);

out.println(Hello1.getHello() + "
");

%>

ResultSet RS = mybean.executeQuery("SELECT * FROM  work_log");

String tt;

while (RS.next()) {

tt = RS.getString("proc_name");

out.print("

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

out.print("

" + tt + "

");

}

RS.close();

%>

1、javac -d . faq.java  ->faq.class

javac -d . Hello.java ->Hello.class

2、把faq.class,Hello.class放于Tomcat 6.0\webapps\ROOT\WEB-INF\classes\Test下

3、编辑testfaq2.jsp，调用javabean访问数据库