selectdata.java

《Java程序设计与应用》-张仕斌-源程序 《Java程序设计与应用》-张仕斌-源程序

import java.sql.*;
public class selectdata{
	public static void main(String args[]){	
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			Connection con1=DriverManager.getConnection("jdbc:odbc:JavaDB","Admin","");	
			Statement	smt1=con1.createStatement();		
			ResultSet rs1=smt1.executeQuery("select eid,ename from employee");
			System.out.println("工号     姓名");
			while (rs1.next()){				
				System.out.println(rs1.getString(1)+"      " +rs1.getString(2));}
			rs1.close();
			smt1.close();
			con1.close();}	
		catch (Exception e){
			e.printStackTrace();}			
	}
}