import java.sql.*;
public class javaodbc2
{
public static void main(String[] args)
{
ResultSet rs=null;
Statement ps=null;
String url="jdbc:odbc:sample";
String usr="sa";
String pass="";
Connection c;
Statement stmt;
try
{
Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");
}catch (java.lang .ClassNotFoundException e)
{
System.err.print("ClassNotFoundException");
System.err .println (e.getMessage ());
}
try
{
c=DriverManager.getConnection (url,usr,pass);
c.setAutoCommit (false);
stmt=c.createStatement ();
int aaa=999;
//boolean flag=stmt.execute ("");
rs=stmt.executeQuery ("select * from account");
/* rs.moveToInsertRow();
rs.updateInt("accno",10001);
rs.updateString("customer","wangxiaoyi");
//rs.updateInt("balance",4000.00);
rs.insertRow();
*/
for (int i=0;i<7;i++)
rs.next();
ResultSetMetaData rsMetaData = rs.getMetaData();
System.out.println(rsMetaData.getColumnName(3));
System.out.println(rs.getFloat(3));
c.commit ();
c.setAutoCommit (true);
stmt.close ();
c.close();
}catch (SQLException e)
{
System.err.print("SQLException: ");
System.err.println(e.getMessage ());
} }
}
public class javaodbc2
{
public static void main(String[] args)
{
ResultSet rs=null;
Statement ps=null;
String url="jdbc:odbc:sample";
String usr="sa";
String pass="";
Connection c;
Statement stmt;
try
{
Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");
}catch (java.lang .ClassNotFoundException e)
{
System.err.print("ClassNotFoundException");
System.err .println (e.getMessage ());
}
try
{
c=DriverManager.getConnection (url,usr,pass);
c.setAutoCommit (false);
stmt=c.createStatement ();
int aaa=999;
//boolean flag=stmt.execute ("");
rs=stmt.executeQuery ("select * from account");
/* rs.moveToInsertRow();
rs.updateInt("accno",10001);
rs.updateString("customer","wangxiaoyi");
//rs.updateInt("balance",4000.00);
rs.insertRow();
*/
for (int i=0;i<7;i++)
rs.next();
ResultSetMetaData rsMetaData = rs.getMetaData();
System.out.println(rsMetaData.getColumnName(3));
System.out.println(rs.getFloat(3));
c.commit ();
c.setAutoCommit (true);
stmt.close ();
c.close();
}catch (SQLException e)
{
System.err.print("SQLException: ");
System.err.println(e.getMessage ());
} }
}
我没有用ODBC桥!!
只要直接用JDBC连MYSQL的例子
谢谢了!
import java.sql.*;
public class CreateCoffees { public static void main(String args[])
throws SQLException
{
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
String url = "jdbc:oracle:oci8:@";
Connection con;
String createString;
createString = "create table COFFEES " +
"(COF_NAME varchar(32), " +
"SUP_ID int, " +
"PRICE float, " +
"SALES int, " +
"TOTAL int)";
Statement stmt;
/*try {
Class.forName(" .ClassName"); } catch(java.lang.ClassNotFoundException e) {
System.err.print("ClassNotFoundException: ");
System.err.println(e.getMessage());
}
*/
try {
con = DriverManager.getConnection(url,"syt", "winsunyitao");
stmt = con.createStatement();
stmt.executeUpdate(createString);
stmt.close();
con.close();
} catch(SQLException ex) {
System.err.println("SQLException: " + ex.getMessage());
}
}
}
看看驱动程序的readme说明!
然后检查你的servlet服务器的log文件
看有什么问题