找到jdbc驱动程序,把那个驱动程序包包含进classpath里面就行了!
用jdbc-odbc桥就简单了
只要配置好数据源
然后连结和连接其他数据库一样
Connection ConDB=null;
Statement Stmt=null;
ResultSet Rs=null;
public OpenDb()
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
ConDB=DriverManager.getConnection("jdbc:odbc:Easy");
Stmt=ConDB.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
}catch(Exception e)
{}
用jdbc-odbc桥就简单了
只要配置好数据源
然后连结和连接其他数据库一样
Connection ConDB=null;
Statement Stmt=null;
ResultSet Rs=null;
public OpenDb()
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
ConDB=DriverManager.getConnection("jdbc:odbc:Easy");
Stmt=ConDB.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
}catch(Exception e)
{}
用jdbc-odbc桥就简单了
只要配置好数据源
然后连结和连接其他数据库一样
Connection ConDB=null;
Statement Stmt=null;
ResultSet Rs=null;
public OpenDb()
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
ConDB=DriverManager.getConnection("jdbc:odbc:Easy");
Stmt=ConDB.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
}catch(Exception e)
{}
是把包解开么?还是直接放进去?是c:\tomcat\common\classes 中么?
还是环境变量中?
小弟谢先!
是把包解开么?还是直接放进去?是c:\tomcat\common\classes 中么?
还是环境变量中?
小弟谢先!
我在try try !
还是不行 错误如下:
javax.servlet.ServletException: com.microsoft.jdbc.sqlserver.SQLServerDriver
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:471)
at org.apache.jsp.tryjdbc$jsp._jspService(tryjdbc$jsp.java:120)
...........
C:\Tomcat 4.0\common\lib\JDBC_SQL.zip
JDBC_SQL.zip为驱动程序
应该有3个JAR文件,把他门包含到CLASSPATH中去!
<%@ page contentType="text/html;charset=gb2312" %>
<HTML>
<HEAD>
<TITLE> 连接数据库 </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
</HEAD><BODY>
<%
String url=new String();
url="jdbc:odbc:tryjdbcodbc";Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");Connection con=DriverManager.getConnection(url);
Statement stmt=con.createStatement();String sql="select *from qxb";
ResultSet rs=stmt.executeQuery(sql);
while (rs.next()){out.println(rs.getString("qx_num")+"<br>");
out.println(rs.getString("qx_value")+"<br>");
}
%>
</BODY>
</HTML>
可以了,这段程序好用
<%@ page import="java.sql.*"%>
<%@ page contentType="text/html;charset=gb2312" %>
<%
String url=new String();
url="jdbc:odbc:tryjdbcodbc";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection(url);
Statement stmt=con.createStatement();
String sql="select *from qxb";
ResultSet rs=stmt.executeQuery(sql);
while (rs.next()){
out.println(rs.getString("qx_num")+"<br>");
out.println(rs.getString("qx_value")+"<br>");
}
%>