jsp连接MS SQL server2000老出错(tomcat服务器),sql server2000打了sp3补丁bean:
//使用JDBC调用ODBC数据源JSP
package opendb;
import java.sql.*;
public class opendb
{
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:JSP";
Connection conn = null;
ResultSet rs = null;
public opendb()
{
try
{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("opendb():"+e.getMessage());
}
} public ResultSet executeQuery(String sql)
{
rs = null;
try
{
conn = DriverManager.getConnection(sConnStr,"abc","123456");
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println("aq.executeQuery:"+ex.getMessage());
}
return rs;
}
}jsp内容:
<%@ page language="java" import="java.sql.*"%>
<jsp:useBean id="db" scope="page" class="opendb.opendb"/>
<%String uid=request.getParameter("uid");
String sql="select * from custom where uid="+uid+"";
//rs为返回结果的ResultSet对象
ResultSet rs = db.executeQuery(sql);报错:说class 的属性值:"opendb.opendb" 无效
//使用JDBC调用ODBC数据源JSP
package opendb;
import java.sql.*;
public class opendb
{
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:JSP";
Connection conn = null;
ResultSet rs = null;
public opendb()
{
try
{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("opendb():"+e.getMessage());
}
} public ResultSet executeQuery(String sql)
{
rs = null;
try
{
conn = DriverManager.getConnection(sConnStr,"abc","123456");
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println("aq.executeQuery:"+ex.getMessage());
}
return rs;
}
}jsp内容:
<%@ page language="java" import="java.sql.*"%>
<jsp:useBean id="db" scope="page" class="opendb.opendb"/>
<%String uid=request.getParameter("uid");
String sql="select * from custom where uid="+uid+"";
//rs为返回结果的ResultSet对象
ResultSet rs = db.executeQuery(sql);报错:说class 的属性值:"opendb.opendb" 无效
解决方案 »
- 请高手指点,jetty7嵌入式启动不支持EL表达式
- java 开发中可以使用权的免费的报表有哪些?
- jsp filter 中如何过滤a.jsp 和b.jsp 而其他的 页面不过滤
- ajax(xmlHttpRequest)+struts 输出的全是html代码
- 求,二手房信息网站的设计与开发程序或者论文!
- FRAMESET标签 如何同步显示
- 急,高手救命!getOutputStream() Exception
- javaBean 的问题》》(在线等)
- birt在tomcat7服务器中出现未定义字符
- Springboot项目打包War包部署tomcat运行报错怎么解决
- 域名解析隐藏IP地址的问题
- 一个关于TOMCAT发布的简单问题
有问题,你把SQL的包解压了看看路径对不对,
<jsp:useBean id="db" scope="page" class="opendb.*"/>
试试!寒!没人一个人的JSP是用标签写的!!!!!!!难道我落后了!?