📄 486297.xml
字号:
<?xml version='1.0' encoding='GB2312'?>
<?xml-stylesheet type='text/xsl' href='../csdn.xsl'?>
<Topic>
<Issue>
<PostUserNickName>大吊车</PostUserNickName>
<rank>二级(初级)</rank>
<ranknum>user2</ranknum>
<credit>110</credit>
<TopicId>486297</TopicId>
<TopicName>哪位给详细指导以下jdbc-odbc的连接问题</TopicName>
<PostUserId>150233</PostUserId>
<PostUserName>xchunyu</PostUserName>
<RoomName>JSP</RoomName>
<ReplyNum>11</ReplyNum>
<PostDateTime>2002-1-18 15:53:25</PostDateTime>
<Point>50</Point>
<ReadNum>67</ReadNum>
<RoomId>28</RoomId>
<EndState>2</EndState>
<Content>在下初学jsp但对asp已经有一定的应用经验，现在测试jsp数据库连接问题时
甚感迷惑，
问题详述如下：
本人欲做一测试连接，在本地建立odbc数据源名test
然后加载jdbc-odbc驱动程序时即出错，错误信息是不能编译该语句
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
运行环境jdk1.3+tomcat运行正常。java.sql.*也已经导入
有以下问题请教
是否配置好jsp的运行环境就可以连接数据库，与环境变量的配置是否有关
上述错误，其根源何在，应该如何订正？
还请各位不吝赐教，令愚弟早离苦海</Content>
</Issue>
<Replys>
<Reply>
<PostUserNickName>色子</PostUserNickName>
<rank>五级(中级)</rank>
<ranknum>user5</ranknum>
<credit>115</credit>
<ReplyID>3234015</ReplyID>
<TopicID>486297</TopicID>
<PostUserId>62789</PostUserId>
<PostUserName>zhjx_10</PostUserName>
<Point>0</Point>
<Content>String dbDriverName = "sun.jdbc.odbc.JdbcOdbcDriver";
        // Connection URL.
        String dbConnectionURL = "jdbc:odbc:test";
        // Connection object.
        Connection dbConnection = null;
        // Statement object.
        Statement dbStatement = null;
        // SQL statement to execute.
        String sqlStatement = "Select * from oneTable";
        // Result set object.
        ResultSet dbResultSet = null;
        // Start the servlet output.
        PrintWriter out = response.getWriter();
        response.setContentType("text/html");
        out.println("<html><head><title>DB Test</title></head><body>");
        out.println("<h1>Database Test</h1>");
         // Create JDBC driver instance.
          Class.forName(dbDriverName).newInstance();
       dbConnection = DriverManager.getConnection(dbConnectionURL);
      
          // Create Statement object.
          dbStatement = dbConnection.createStatement();
      
          // Execute the query.
          dbResultSet = dbStatement.executeQuery(sqlStatement);
</Content>
<PostDateTime>2002-1-18 15:58:26</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>色子</PostUserNickName>
<rank>五级(中级)</rank>
<ranknum>user5</ranknum>
<credit>115</credit>
<ReplyID>3234066</ReplyID>
<TopicID>486297</TopicID>
<PostUserId>62789</PostUserId>
<PostUserName>zhjx_10</PostUserName>
<Point>0</Point>
<Content>jdbc:odbc方式不需要其他设置了，你编译过java程序吗？不知道最起码的classpath是否正确
</Content>
<PostDateTime>2002-1-18 16:00:04</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>土地爷爷</PostUserNickName>
<rank>一级(初级)</rank>
<ranknum>user1</ranknum>
<credit>100</credit>
<ReplyID>3234124</ReplyID>
<TopicID>486297</TopicID>
<PostUserId>111016</PostUserId>
<PostUserName>weljava</PostUserName>
<Point>0</Point>
<Content>Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");这句没什么错啊，也import java.sql.*;啦？要不你把代码贴出来看看，其他的jsp都正常？CLASSPATH设置好了？</Content>
<PostDateTime>2002-1-18 16:02:44</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>紫龙</PostUserNickName>
<rank>五级(中级)</rank>
<ranknum>user5</ranknum>
<credit>100</credit>
<ReplyID>3234505</ReplyID>
<TopicID>486297</TopicID>
<PostUserId>79166</PostUserId>
<PostUserName>vdragon</PostUserName>
<Point>50</Point>
<Content>try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch (ClassNotFoundException e)
{
System.out.println(e);
}</Content>
<PostDateTime>2002-1-18 16:19:56</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>秋飞意</PostUserNickName>
<rank>四级(中级)</rank>
<ranknum>user4</ranknum>
<credit>100</credit>
<ReplyID>3234698</ReplyID>
<TopicID>486297</TopicID>
<PostUserId>136873</PostUserId>
<PostUserName>yun15291li</PostUserName>
<Point>0</Point>
<Content>把你的jdbc添加到classpath里。
然后在按楼上得楼上的楼上的楼上试试！！！！！！！！！</Content>
<PostDateTime>2002-1-18 16:28:48</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>凤凰一辉</PostUserNickName>
<rank>三级(初级)</rank>
<ranknum>user3</ranknum>
<credit>100</credit>
<ReplyID>3235348</ReplyID>
<TopicID>486297</TopicID>
<PostUserId>118364</PostUserId>
<PostUserName>restart2001</PostUserName>
<Point>0</Point>
<Content>//bean部分：Conn.java
//将下面的名为Conn的Bean封装在名为dbms包中
package DBMS;
//导入java.sql包中的类
import java.sql.*;
public class Conn{
	private String _username;	//数据库的用户名
	private String _password;	//该用户对应的密码
	private String _driver;		//JDBC连接数据库的驱动程序名   
	private String _dburl;		//数据库的URL
	private Connection _con;
	private Statement _stmt;
	//设置初始化，默认设置
	public Conn(){
		_dburl = "jdbc:odbc:power";
		_username = "12";
		_password = "sadf.kk3";
		_driver = "sun.jdbc.odbc.JdbcOdbcDriver";
	}
	//手动设置初始化
	public Conn(String driver,String dburl,String username,String password){
		_driver = driver;
		_dburl = dburl;
		_username = username;
		_password = password;
	}
	//获得数据集
	public ResultSet getDbResultSet(String sql){
		ResultSet rset=null;
		try{
			Class.forName(_driver);
			_con = DriverManager.getConnection(_dburl,_username,_password);
			_stmt = _con.createStatement();
			rset = _stmt.executeQuery(sql);
		}catch(Exception e){
			System.out.println("查询中读取数据库错误："+e);
		}
		return rset;
	}
	//修改、删除、插入
	public int updateDb(String sql){
		int flag=0;
		try{
			Class.forName(_driver);
			_con = DriverManager.getConnection(_dburl,_username,_password);
			_stmt = _con.createStatement();
			flag = _stmt.executeUpdate(sql);
		}catch(Exception e){
			System.out.println("更新中数据库操作错误："+e);
		}
		return flag;
	}
}
</Content>
<PostDateTime>2002-1-18 16:59:43</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>凤凰一辉</PostUserNickName>
<rank>三级(初级)</rank>
<ranknum>user3</ranknum>
<credit>100</credit>
<ReplyID>3235403</ReplyID>
<TopicID>486297</TopicID>
<PostUserId>118364</PostUserId>
<PostUserName>restart2001</PostUserName>
<Point>0</Point>
<Content>调用jsp文件：
<%@ page language="java" import="DBMS.Conn,java.sql.*"%>
<%@ page contentType="text/html;charset=gb2312" %>
<jsp:useBean id="clg" class="DBMS.Conn" scope="session"/>
<%
  Resultset rs=clg.getDbResultSet("select * from bbs");
%></Content>
<PostDateTime>2002-1-18 17:02:13</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>大吊车</PostUserNickName>
<rank>二级(初级)</rank>
<ranknum>user2</ranknum>
<credit>110</credit>
<ReplyID>3235405</ReplyID>
<TopicID>486297</TopicID>
<PostUserId>150233</PostUserId>
<PostUserName>xchunyu</PostUserName>
<Point>0</Point>
<Content>多谢各位，现该问题已经按如下方式解决：
以前仅导入java.sql.*
现导入：
<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.servlet.*"%>
<%@ page import="javax.servlet.http.*"%>
结果连接数据库ok.
是不是我的环境配置还是有问题，各位做数据库连接时是否也导入上述类包？
</Content>
<PostDateTime>2002-1-18 17:02:15</PostDateTime>
</Reply>
<Reply>
<PostUserNickName></PostUserNickName>
<rank>一级(初级)</rank>
<ranknum>user1</ranknum>
<credit>100</credit>
<ReplyID>3238186</ReplyID>
<TopicID>486297</TopicID>
<PostUserId>127591</PostUserId>
<PostUserName>tianyunchen</PostUserName>
<Point>0</Point>
<Content>learn</Content>
<PostDateTime>2002-1-18 19:37:23</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>足球小将</PostUserNickName>
<rank>三级(初级)</rank>
<ranknum>user3</ranknum>
<credit>100</credit>
<ReplyID>3249803</ReplyID>
<TopicID>486297</TopicID>
<PostUserId>99494</PostUserId>
<PostUserName>xddy</PostUserName>
<Point>0</Point>
<Content>??????????????????</Content>
<PostDateTime>2002-1-20 16:40:41</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>蓝天</PostUserNickName>
<rank>一级(初级)</rank>
<ranknum>user1</ranknum>
<credit>110</credit>
<ReplyID>3722646</ReplyID>
<TopicID>486297</TopicID>
<PostUserId>149828</PostUserId>
<PostUserName>gao256</PostUserName>
<Point>0</Point>
<Content>哪有jdbc:odbc:JdbcOdbcDriver???</Content>
<PostDateTime>2002-3-6 11:08:18</PostDateTime>
</Reply>
</Replys>
</Topic>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -