DB2数据库程序开发试验

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（“
 Usage: java MyJDBC[usernamepassword]
“）;
                 } 

                     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.settingsorg.eclipse.jdt.core.prefs
     目录           0  2015-10-18 09:14  DB2_Task_01in
     文件        2160  2015-10-18 09:14  DB2_Task_01inMyJDBC.class
     目录           0  2015-09-15 21:45  DB2_Task_01src
     文件        1838  2015-09-15 21:52  DB2_Task_01srcMyJDBC.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.settingsorg.eclipse.jdt.core.prefs
     目录           0  2015-10-18 09:14  DB2_Task_02in
     文件        3379  2015-10-18 09:14  DB2_Task_02inlabstaff.class
     目录           0  2015-09-15 22:25  DB2_Task_02src
     文件        6833  2015-09-16 10:15  DB2_Task_02srclabstaff.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.settingsorg.eclipse.jdt.core.prefs
     目录           0  2015-10-18 09:14  DB2_Task_03in
     文件        3273  2015-10-18 09:14  DB2_Task_03inlabupdate.class
     目录           0  2015-09-15 22:37  DB2_Task_03src
     文件        2191  2015-09-21 16:22  DB2_Task_03srclabupdate.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个文件信息