连ODBC是这样的:
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
Connection cn = DriverManager.getConnection( "jdbc:odbc:" + databasename, sUsr, sPwd );
连mysql是这样的:
Class.forName( "org.gjt.mm.mysql.Driver" );
cn = DriverManager.getConnection( "jdbc:mysql://MyDbComputerNameOrIP:3306/my
DatabaseName", sUsr, sPwd );
"org.gjt.mm.mysql.Driver" 这个包请上网去下载
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
Connection cn = DriverManager.getConnection( "jdbc:odbc:" + databasename, sUsr, sPwd );
连mysql是这样的:
Class.forName( "org.gjt.mm.mysql.Driver" );
cn = DriverManager.getConnection( "jdbc:mysql://MyDbComputerNameOrIP:3306/my
DatabaseName", sUsr, sPwd );
"org.gjt.mm.mysql.Driver" 这个包请上网去下载
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
Connection conn = DriverManager.getConnection( "jdbc:odbc:" + 数据库名, 用户名,密码 );
mysql -u joke -pjohn web
(我的名字:JOKE,密码:JOHN,数据库名:WEB)
我安装的是 MyODBC-standard-3.51.8-win.exe
<%@ page language="java" %>
<%@ page import ="java.sql.*" %>
<%@ page contentType="text/html;charset=gb2312" %>
<html>
<head>
<title> 新增记录 </title>
</head>
<body>
<%
String driver ="sun.jdbc.odbc.JdbcOdbcDriver";
String url ="jdbc:odbc:web";
String user ="joke";
String password ="john";try{
Class.forName(driver);
}catch(Exception e)
{
out.println("无法加载驱动程序:"+driver);
e.printStackTrace();
}
/*try{
*/Connection con=DriverManager.getConnection(url,user,password);
Statement smt=con.createStatement();
smt.executeUpdate("use web");
out.print("beginning!<br>");
String sql2="select * from myqq";
ResultSet rst=smt.executeQuery(sql2);
%>
<table width="50%" border=2 bgcolor="#ff0000" >
<tr><td><input type=text value=submit name=sub></td></tr>
</table><p>
<%
//smt.close();
//con.close();
//}catch(SQLException e){e.printStackTrace();}%>
<p><h3>已经完成!</h3>
</body>
</html>
但:现在,在ODBC数据管理器中,我是将我的数据库放在‘系统DSN’中的,而当数据库在‘用户DSN’中时,TOMCAT报错。不知道为什么?