import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
/**
?*?任務1?將P171頁程序片段補充完整
?*?@author?lenovo
?*
?*/
public?class?MyJDBC?{


	?static?{?

????????????try?{?
????????????	Class.forName（“com.ibm.db2.jcc.DB2Driver“）;?
????????????}catch?（Exception?e）{?
????????????????e.printStackTrace（）;?
????????????}?
		}

public?static?void?main?（String?argv[]）{?

?????????????try?{?
????????????	?Connection?con?=?null;?

?????????????????String?url?=?“jdbc:db2:sample“;?

?????????????????if?（argv.length?==?0）?{?

????????????????	?con?=?DriverManager.getConnection（url）;?

?????????????????}else?if?（argv.length?==?2）{?

????????????????	?String?userid?=“LENOVO“;?
?????????????????????String?passwd?=?“qwe321“;?
?????????????????????con?=?DriverManager.getConnection（urluseridpasswd）;?
?????????????????}else{?
				
????????????????	?throw?new?Exception（“\n?Usage:?java?MyJDBC[usernamepassword]\n“）;
?????????????????}?

?????????????????????java.sql.Statement?stmt?=?con.createStatement（）;?

?????????????????????ResultSet?rs?=?stmt.executeQuery（“SELECT?EMPNO?LASTNAME?“?+?

???????????????????????????????????“?FROM?EMPLOYEE?“??+?

???????????????????????????????????“?WHERE?SALARY?>?40000?“?）;?

?????????????????????while?（?rs.next（）?）?{?

????????????????????????System.out.println（“empno?=?“?+?rs.getString（1）?+?

??????????????????????????????????????????????“lastname?=?“?+?rs.getString（2）?）;?

????????????????????}?

?????????????????????rs.close（）;?
??????????????????
?????????????????????stmt.close（）;?
??????????????????
?????????????????????con.close（）;?
??????????????????
?????????????????}?catch?（Exception?e）?{?

????????????????????????e.printStackTrace（）;?
??????????????????
?????????????????}?
		}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件?????2629120??2015-10-18?12:37??實驗報告_賈鋒.doc
?????目錄???????????0??2015-09-15?21:45??DB2_Task_01\
?????文件?????????476??2015-09-15?21:49??DB2_Task_01\.classpath
?????文件?????????387??2015-09-15?21:45??DB2_Task_01\.project
?????目錄???????????0??2015-09-15?21:45??DB2_Task_01\.settings\
?????文件?????????598??2015-09-15?21:45??DB2_Task_01\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2015-10-18?09:14??DB2_Task_01\bin\
?????文件????????2160??2015-10-18?09:14??DB2_Task_01\bin\MyJDBC.class
?????目錄???????????0??2015-09-15?21:45??DB2_Task_01\src\
?????文件????????1838??2015-09-15?21:52??DB2_Task_01\src\MyJDBC.java
?????目錄???????????0??2015-09-15?22:22??DB2_Task_02\
?????文件?????????476??2015-09-15?22:23??DB2_Task_02\.classpath
?????文件?????????387??2015-09-15?22:22??DB2_Task_02\.project
?????目錄???????????0??2015-09-15?22:22??DB2_Task_02\.settings\
?????文件?????????598??2015-09-15?22:22??DB2_Task_02\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2015-10-18?09:14??DB2_Task_02\bin\
?????文件????????3379??2015-10-18?09:14??DB2_Task_02\bin\labstaff.class
?????目錄???????????0??2015-09-15?22:25??DB2_Task_02\src\
?????文件????????6833??2015-09-16?10:15??DB2_Task_02\src\labstaff.java
?????目錄???????????0??2015-09-15?22:36??DB2_Task_03\
?????文件?????????476??2015-09-15?22:37??DB2_Task_03\.classpath
?????文件?????????387??2015-09-15?22:36??DB2_Task_03\.project
?????目錄???????????0??2015-09-15?22:36??DB2_Task_03\.settings\
?????文件?????????598??2015-09-15?22:36??DB2_Task_03\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2015-10-18?09:14??DB2_Task_03\bin\
?????文件????????3273??2015-10-18?09:14??DB2_Task_03\bin\labupdate.class
?????目錄???????????0??2015-09-15?22:37??DB2_Task_03\src\
?????文件????????2191??2015-09-21?16:22??DB2_Task_03\src\labupdate.java
?????目錄???????????0??2015-09-21?16:26??DB2_Task_04\
?????文件?????????476??2015-09-21?16:26??DB2_Task_04\.classpath
?????文件?????????387??2015-09-21?16:26??DB2_Task_04\.project
............此處省略140個文件信息