java数据库连接 JDBC：ODBC

来源：互联网发布：mac系统作图软件编辑：程序博客网时间：2024/05/16 06:58

Code:

import java.sql.*;
import java.util.*;
/**
*
* @blacksapper
* java查询分析器
*
*/
public class selection {
public static void main(String args [])
{
String driverClass="sun.jdbc.odbc.JdbcOdbcDriver"; //申明连接
String url="jdbc:odbc:javadb";
String [] columnNames=new String[]{"EmployeeID","LastName","FirstName","Title","TitleOfCourtesy","BirthDate","HireDate","Address","City","Region","PostalCode","Country","HomePhone","Extension","Photo","Notes","ReportsTo","PhotoPath"};
String [] displayNames=new String[]{"EmployeeID","LastName","FirstName","Title","TitleOfCourtesy","BirthDate","HireDate","Address","City","Region","PostalCode","Country","HomePhone","Extension","Photo","Notes","ReportsTo","PhotoPathss"};
Connection con=null;
Statement stmt=null;
ResultSet rs=null;
Scanner input = new Scanner(System.in);
String a = input.nextLine();
//"select top 1 * from employees";
try{
//加载驱动程序
Class.forName(driverClass);
}
catch(ClassNotFoundException e){
System.out.println("驱动加载不成功");
System.exit(-1);
}//end try
try{
//获得jdbc连接
con = DriverManager.getConnection(url);
//创建satement对象
stmt=con.createStatement();
//得到查询结果集合
rs=stmt.executeQuery(a); //这里是字符串 select top 1 * from employees
//打印表头
for(int i=0;i<displayNames.length;i++)
{System.out.print(displayNames[i]+"/t");}
System.out.println() ;
//打印结果集
while (rs.next())
{
for (int i=0;i<columnNames.length;i++)
{System.out.print(rs.getString ( columnNames[i] ) + " /t ") ;}
System.out.println();
}
stmt.close();
}
catch(SQLException sqe)
{
sqe.printStackTrace ();
}
finally
{
//关闭数据库连接
try{
con.close();
}
catch(Exception e){}
//end try close
}//end finally
}
}

其实是书上的代码。我拿来改了一下。呵呵。连接的数据库是MSSQL2000自带的什么wind数据库。这个是JDBCODBC的使用。抛砖引玉了。

除了代码还有个需要声明的连接在控制面板，管理，数据源里面建立连接。顺便选择数据库。感谢下面朋友的补充