//JDBC-数据库几种连接方式.txt1、JDBC-ODBC连接//:SqlServerJdbcOdbc.java
import java.sql.*;public class SqlServerJdbcOdbc {
public static void main(String[] args){
//CheDui是ODBC中的数据源名称,需要自己在控制面板中定义
String dbUrl = "jdbc:odbc:CheDui";
Connection con;
Statement stmt;
String user;
ResultSet result=null;
try{
//使用JDBC-ODBC桥
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException ex){
ex.printStackTrace();
} try{
//简单的使用,当然数据库中要有Course表
con = DriverManager.getConnection(dbUrl);
stmt=con.createStatement();
result=stmt.executeQuery("select * from Course");
while (result.next()){
String id=result.getString(1);
System.out.println(id);
}
con.close();
}catch(SQLException ex){
System.err.println("SQLException: " + ex.getMessage());
}
}
}
2、直接连接,要JDBC库//:SqlServerJdbcDirect.java
import java.sql.*;public class SqlServerJdbcDirect {
public static void main(String[] args){
String dbUrl="jdbc:microsoft:sqlserver://tsc:1433;user=sa;password=mdzly109;DatabaseName=CheDui";
Connection con;
Statement stmt;
String user;
ResultSet result=null;
try{
//使用MS提供的JDBC类。需要下载SQL Server的JDBC库。
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}catch(ClassNotFoundException ex){
ex.printStackTrace();
} try{
//简单的使用,当然数据库中要有Course表
con = DriverManager.getConnection(dbUrl);
stmt=con.createStatement();
result=stmt.executeQuery("select * from Course");
while (result.next()){
String id=result.getString(1);
System.out.println(id);
}
con.close();
}catch(SQLException ex){
System.err.println("SQLException: " + ex.getMessage());
}
}
}3、直接连接,不要JDBC库//:SqlServerJdbcDirectNoJar.java
import java.sql.*;public class SqlServerJdbcDirectNoJar {
public static void main(String[] args){
//所谓直接连接,实际上还是使用了ODBC,只不过不用设ODBC数据源了
//注意,写法和下行的差异。database=CheDui不能改成DatabaseName=CheDui!!!
String dbUrl="jdbc:odbc:driver={SQL Server};SERVER=tsc;uid=sa;pwd=mdzly109;database=CheDui";
//String dbUrl="jdbc:microsoft:sqlserver://tsc:1433;user=sa;password=mdzly109;DatabaseName=CheDui";
Connection con;
Statement stmt;
String user;
ResultSet result=null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException ex){
ex.printStackTrace();
} try{
con = DriverManager.getConnection(dbUrl);
stmt=con.createStatement();
result=stmt.executeQuery("select * from RenYuan");
while (result.next()){
String id=result.getString(2);
System.out.println(id);
}
con.close();
}catch(SQLException ex){
System.err.println("SQLException: " + ex.getMessage());
}
}
}
import java.sql.*;public class SqlServerJdbcOdbc {
public static void main(String[] args){
//CheDui是ODBC中的数据源名称,需要自己在控制面板中定义
String dbUrl = "jdbc:odbc:CheDui";
Connection con;
Statement stmt;
String user;
ResultSet result=null;
try{
//使用JDBC-ODBC桥
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException ex){
ex.printStackTrace();
} try{
//简单的使用,当然数据库中要有Course表
con = DriverManager.getConnection(dbUrl);
stmt=con.createStatement();
result=stmt.executeQuery("select * from Course");
while (result.next()){
String id=result.getString(1);
System.out.println(id);
}
con.close();
}catch(SQLException ex){
System.err.println("SQLException: " + ex.getMessage());
}
}
}
2、直接连接,要JDBC库//:SqlServerJdbcDirect.java
import java.sql.*;public class SqlServerJdbcDirect {
public static void main(String[] args){
String dbUrl="jdbc:microsoft:sqlserver://tsc:1433;user=sa;password=mdzly109;DatabaseName=CheDui";
Connection con;
Statement stmt;
String user;
ResultSet result=null;
try{
//使用MS提供的JDBC类。需要下载SQL Server的JDBC库。
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}catch(ClassNotFoundException ex){
ex.printStackTrace();
} try{
//简单的使用,当然数据库中要有Course表
con = DriverManager.getConnection(dbUrl);
stmt=con.createStatement();
result=stmt.executeQuery("select * from Course");
while (result.next()){
String id=result.getString(1);
System.out.println(id);
}
con.close();
}catch(SQLException ex){
System.err.println("SQLException: " + ex.getMessage());
}
}
}3、直接连接,不要JDBC库//:SqlServerJdbcDirectNoJar.java
import java.sql.*;public class SqlServerJdbcDirectNoJar {
public static void main(String[] args){
//所谓直接连接,实际上还是使用了ODBC,只不过不用设ODBC数据源了
//注意,写法和下行的差异。database=CheDui不能改成DatabaseName=CheDui!!!
String dbUrl="jdbc:odbc:driver={SQL Server};SERVER=tsc;uid=sa;pwd=mdzly109;database=CheDui";
//String dbUrl="jdbc:microsoft:sqlserver://tsc:1433;user=sa;password=mdzly109;DatabaseName=CheDui";
Connection con;
Statement stmt;
String user;
ResultSet result=null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException ex){
ex.printStackTrace();
} try{
con = DriverManager.getConnection(dbUrl);
stmt=con.createStatement();
result=stmt.executeQuery("select * from RenYuan");
while (result.next()){
String id=result.getString(2);
System.out.println(id);
}
con.close();
}catch(SQLException ex){
System.err.println("SQLException: " + ex.getMessage());
}
}
}
2、直接连接,要JDBC库
Exception in thread "main" java.lang.NoClassDefFoundError: com/sun/tools/javac/M
ain
拷进行保存为.java文件,但用javac 编译后出现了上面的错误