1 public Task[] getTaskInfo(String a_id){ 2         Task[] task = null; 3         Connection conn = null; 4         Statement stmt = null; 5         ResultSet rs1 = null; 6         ResultSet rs2 = null; 7         try{ 8             Class.forName("com.mysql.jdbc.Driver"); 9             conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/p_note","root","root");10             stmt = conn.createStatement();11             String sql = "select count(*) from tasks";12             String sql2 = "select * from tasks" ;13             rs1 = stmt.executeQuery(sql);14             rs2 = stmt.executeQuery(sql2);15             int count = 0;16             while(rs1.next()){17                 count = rs1.getInt(1);18             }19             task = new Task[count];20             int i=0;21             while(rs2.next()){22                 task[i] = new Task();23                 task[i].setA_id(a_id);24                 task[i].setT_id(rs2.getString("t_id"));25                 task[i].setExecuteTime("t_time");26                 task[i].setExecuteSite(rs2.getString("t_site"));27                 task[i].setItemName(rs2.getString("t_items"));28                 task[i].setSetout(rs2.getString("t_setout"));29                 task[i].setT_createTime(rs2.getString("t_createTime"));30                 task[i].setT_stamp(rs2.getString("t_stamp"));31                 task[i].setT_stick(rs2.getString("t_stick"));32                 i++;33             }34             35         }catch(Exception ex){36             ex.printStackTrace();37             38         }finally{39             try{40                 if(conn != null){41                     conn.close();42                 }43                 if(stmt != null){44                     stmt.close();45                 }46                 if(rs1 != null){47                     rs1.close();48                 }49                 if(rs2 != null){50                     rs2.close();51                 }52             }catch(Exception ex){53                 ex.printStackTrace();54             }55         }56        57         return task;58     }