a.java

java 北大青鸟 java 北大青鸟

import javax.sql.*;
import java.sql.*;
////import java.rmi.server.*;
//import java.io;
//import java.util.*;
class A{

	public static void main(String []arg) throws SQLException{
		
	 Connection cn = null;
	 ResultSet rs = null ;
	 Statement stat;
	 
	 String DriverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
     
	 String DriverManagerURL = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=pubs";
	 String userName = "sa";
	 String userpassworld ="";
	 
	
//使用桥JDBC-ODBC加ODBC驱动	 String DriverManagerURL="jdbc:odbc:LocalServer";
	try{
		Class.forName(DriverName);
//使用桥JDBC-ODBC加ODBC驱动	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		cn = DriverManager.getConnection(DriverManagerURL,userName,userpassworld);
	}

	catch(java.lang.ClassNotFoundException e){
	 	System.err.println("ClassNotFoundException:");
		System.err.println(e.getMessage());
		}
		if (cn == null){
            System.err.println("Connection failed...");
            System.exit(0);			
			}
		stat = cn.createStatement();
		rs = stat.executeQuery("select * from authors");
		
		while(rs.next()){
			String name =rs.getString("au_lname");
			System.out.println(name);
			}
		rs.close();
		stat.close();
	/*	*/
		cn.close();	
				
			}
	}