/*
* testquery.java
*
* Created on 2006年11月3日, 下午4:09
* @author Newtown
*/
import java.sql.*;
public class testquery
{
static {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
System.out.println("success loading JDBC-ODBC Bridge Driver...");
}catch(Exception e){
System.out.println("Error loading JDBC-ODBC Bridge Driver...");
e.printStackTrace();
}
}
public static void main(String args[]){
try{
Connection con1=DriverManager.getConnection("jdbc:odbc:myodbc","root","19870323");//数据库无用户名
System.out.println("Success eastablishing the Connection...");
Statement stm1=con1.createStatement();
ResultSet rt=stm1.executeQuery("select * from student.s;");
System.out.println("Success select database...");
System.out.println("Result of selest database is...");
while(rt.next())
{
System.out.println(rt.getString(1));
}
con1.close();
}catch(Exception e){
e.printStackTrace();
}
}
}
FAQ:DriverManager.getConnection 中的URL指什么呀?
对于MySQL: jdbc:mysql:// IP : 3306/ DBNAME
其他:
jdbc:oracle:thin:@:: jdbc:idb: jdbc:mysql:/// jdbc:sybase:Tds::/ jdbc:db2:/// jdbc:cloudscape:rmi: jdbc:jdbc:rmi:/ jdbc:HypersonicSQL:hsql://: jdbc:postgresql:net