importjava.sql.Connection;
importjava.sql.Date;
importjava.sql.DriverManager;
importjava.sql.ResultSet;
importjava.sql.SQLException;
importjava.sql.Statement;
publicclassExample14_1
{
publicstaticvoidmain(String[]args)
{
//TODOAuto-generatedmethodstub
Connectioncon;
Statementsql;
ResultSetrs;
try{
Class.forName("com.hxtt.sql.access.AccessDriver").newInstance();
}
catch(Exceptione){
System.out.println(e);
}
Stringurl="jdbc:Access:D://javacode//Example14_1//Database1.mdb";
try{
con=DriverManager.getConnection(url,"","");
sql=con.createStatement();
rs=sql.executeQuery("SELECT*FROMemployeeWHEREsalary>1900");
while(rs.next()){
Stringnumber=rs.getString(1);
Stringname=rs.getString(2);
Datedate=rs.getDate("birthday");
doublesalary=rs.getDouble("salary");
System.out.printf("%-4s",number);
System.out.printf("%-6s",name);
System.out.printf("%-15s",date.toString());
System.out.printf("%-6s\n",salary);
}
con.close();
}
catch(SQLExceptione){
System.out.println(e.getNextException());
}
}
}
分 -->
|
