aaa.jsp/存在D:\jakarta-tomcat-3.3.1\webapps\ROOT\test
<%@ page contentType="text/html; charset=gb2312"%>
<%@ page import="java.sql.*"%>
<jsp:useBean id="personbean" scope="session" class="person.personbean"/>
<%! String sql;%>
<%
sql="select * from Table1";
ResultSet RS=personbean.executeQuery(sql);
while (RS.next())
{
out.print(RS.getString("name"));
}
RS.close();%>
///////////////////////////////////////////////////////////
personbean.java/存在D:\jakarta-tomcat-3.3.1\webapps\ROOT\test\WEB-INF\classes下
package person;
import java.sql.*;public class personbean
{
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:ym";
Connection conn = null;
ResultSet rs = null; public personbean()
{
try
{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("personbean():" + 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("personbean.executeQuery:" + ex.getMessage());
}
return rs;
}
}
<%@ page contentType="text/html; charset=gb2312"%>
<%@ page import="java.sql.*"%>
<jsp:useBean id="personbean" scope="session" class="person.personbean"/>
<%! String sql;%>
<%
sql="select * from Table1";
ResultSet RS=personbean.executeQuery(sql);
while (RS.next())
{
out.print(RS.getString("name"));
}
RS.close();%>
///////////////////////////////////////////////////////////
personbean.java/存在D:\jakarta-tomcat-3.3.1\webapps\ROOT\test\WEB-INF\classes下
package person;
import java.sql.*;public class personbean
{
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:ym";
Connection conn = null;
ResultSet rs = null; public personbean()
{
try
{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("personbean():" + 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("personbean.executeQuery:" + ex.getMessage());
}
return rs;
}
}
解决方案 »
- HTML局部打印
- 难!超难!!重定向,共享session
- 请教个工厂模式产生UserManager的问题
- 照搬老紫竹的一个javabean计数器,我怎么调试不通过啊. 急啊!
- servlet传递初始参数的问题
- 各位大虾菜鸟,有谁会hibernate帮我进来看看这个异常,可能在那里出了错,谢谢各位
- 求JSP连接SQL SERVER 2000的语句.谢谢
- 如何在JSP站点里面传一个参数给asp.net的站点
- 关于jsp连接oracle8出现问题,请指点!
- tomcat 8中怎么安装struts2
- 一个意外错误,请高手回答
- 请问为什么我用dreamware中插入一个flash文件,大概1.2M,保存为index.jsp.在浏览器中打开这个网页为什么非常慢,都无法显示。如果我用fro
得到personbean.class
存在D:\jakarta-tomcat-3.3.1\webapps\ROOT\WEB-INF\classes\person目录下
注意目录不要弄错了