- 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的使用。抛砖引玉了。
除了代码还有个需要声明的连接在控制面板,管理,数据源里面建立连接。顺便选择数据库。感谢下面朋友的补充