import java.io.*; import javax.servlet.*; import javax.servlet.http.*; import java.util.Calendar; import java.sql.*; public class ScheduleView1 extends HttpServlet{ protected Connection conn = null; public void init() throws ServletException{ String url = "jdbc:mysql://localhost/servletschedule"; String user = "scheduleuser"; String password = "schedulepass"; try { Class.forName("com.mysql.jdbc.Driver").newInstance(); conn = DriverManager.getConnection(url, user, password); }catch (ClassNotFoundException e){ log("ClassNotFoundException:" + e.getMessage()); }catch (SQLException e){ log("SQLException:" + e.getMessage()); }catch (Exception e){ log("Exception:" + e.getMessage()); } } public void destory(){ try{ if (conn != null){ conn.close(); } }catch (SQLException e){ log("SQLException:" + e.getMessage()); } } public void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException{ res.setContentType("text/html;charset=Shift_Jis"); PrintWriter out = res.getWriter(); int year = -1; int month = -1; int day = -1; int currentscheduleid; String currentStartTime = ""; String currentEndTime = ""; String currentSchedule = ""; String currentMemo = ""; String param = req.getParameter("ID"); if (param == null || param.length() == 0){ currentscheduleid = -1; }else{ try{ currentscheduleid = Integer.parseInt(param); }catch (NumberFormatException e){ currentscheduleid = -1; } } /* パラメータが不正な場合はトップページへリダイレクト */ if (currentscheduleid == -1){ res.sendRedirect("/schedule/top.html"); } try { String sql = "SELECT * FROM schedule WHERE id = ?"; PreparedStatement pstmt = conn.prepareStatement(sql); pstmt.setInt(1, currentscheduleid); ResultSet rs = pstmt.executeQuery(); rs.next(); String scheduledate = rs.getString("scheduledate"); String yearStr = scheduledate.substring(0, 4); String monthStr = scheduledate.substring(5, 7); String dayStr = scheduledate.substring(8, 10); year = Integer.parseInt(yearStr); month = Integer.parseInt(monthStr) - 1; day = Integer.parseInt(dayStr); currentStartTime = rs.getString("starttime"); currentEndTime = rs.getString("endtime"); currentSchedule = rs.getString("schedule"); currentMemo = rs.getString("schedulememo"); rs.close(); pstmt.close(); }catch (SQLException e){ log("SQLException:" + e.getMessage()); } StringBuffer sb = new StringBuffer(); sb.append(""); sb.append(""); sb.append(""); sb.append(""); sb.append("スケジュール登録"); sb.append(""); sb.append(""); sb.append(""); sb.append("

"); sb.append("既存スケジュール確認  "); sb.append("[カレンダーへ戻る]"); sb.append("

"); String[] scheduleArray = new String[49]; int[] widthArray = new int[49]; for (int i = 0 ; i < 49 ; i++){ scheduleArray[i] = ""; widthArray[i] = 0; } try { String sql = "SELECT * FROM schedule WHERE userid = ? and scheduledate = ? ORDER BY starttime"; PreparedStatement pstmt = conn.prepareStatement(sql); String startDateStr = year + "-" + (month + 1) + "-" + day; pstmt.setInt(1, 1); pstmt.setString(2, startDateStr); ResultSet rs = pstmt.executeQuery(); while(rs.next()){ int id = rs.getInt("id"); String starttime = rs.getString("starttime"); String endtime = rs.getString("endtime"); String schedule = rs.getString("schedule"); if (starttime == null || endtime == null){ widthArray[0] = 1; StringBuffer sbSchedule = new StringBuffer(); sbSchedule.append(""); sbSchedule.append(schedule); sbSchedule.append(""); scheduleArray[0] = scheduleArray[0] + (new String(sbSchedule)) + "
"; }else{ String startTimeStr = starttime.substring(0, 2); String startMinuteStr = starttime.substring(3, 5); int startTimeNum = Integer.parseInt(startTimeStr); int index = startTimeNum * 2 + 1; if (startMinuteStr.equals("30")){ index++; } if (widthArray[index] == 0){ /* 既にデータが入っていた場合は異常な状態なので無視する */ String endTimeStr = endtime.substring(0, 2); String endMinuteStr = endtime.substring(3, 5); int endTimeNum = Integer.parseInt(endTimeStr); int width = (endTimeNum - startTimeNum) * 2; if (startMinuteStr.equals("30")){ width--; } if (endMinuteStr.equals("30")){ width++; } StringBuffer sbSchedule = new StringBuffer(); sbSchedule.append(startTimeStr); sbSchedule.append(":"); sbSchedule.append(startMinuteStr); sbSchedule.append("-"); sbSchedule.append(endTimeStr); sbSchedule.append(":"); sbSchedule.append(endMinuteStr); sbSchedule.append(" "); sbSchedule.append(""); sbSchedule.append(schedule); sbSchedule.append(""); scheduleArray[index] = new String(sbSchedule); widthArray[index] = width; /* 同じスケジュールの先頭以外の箇所には「-1」を設定 */ for (int i = 1 ; i < width ; i++){ widthArray[index + i] = -1; } } } } rs.close(); pstmt.close(); }catch (SQLException e){ log("SQLException:" + e.getMessage()); } sb.append("
"); sb.append("
"); sb.append(""); sb.append(""); sb.append(""); sb.append(""); for (int i = 1 ; i < 49 ; i++){ if (i % 2 == 1){ sb.append(""); }else{ sb.append(""); } if (widthArray[i] != 0){ if (widthArray[i] != -1){ sb.append(""); } sb.append("
時刻予定
未定"); if (widthArray[0] == 1){ sb.append(scheduleArray[0]); } sb.append("
"); sb.append(i / 2); sb.append(":00
"); sb.append(scheduleArray[i]); } }else{ if (i % 2 == 1){ sb.append(""); }else{ sb.append(""); } } sb.append("
"); sb.append("
"); sb.append("
"); sb.append(""); sb.append(""); sb.append(""); sb.append(""); sb.append(""); sb.append("
日付"); sb.append(year); sb.append("年"); sb.append(month + 1); sb.append("月"); sb.append(day); sb.append("日"); sb.append("
時間"); if (currentStartTime == null){ sb.append("未定"); }else{ sb.append(currentStartTime.substring(0, 5)); sb.append(" - "); sb.append(currentEndTime.substring(0, 5)); } sb.append("
スケジュール"); sb.append(currentSchedule); sb.append("
メモ"); currentMemo = currentMemo.replaceAll("\r\n", "
"); sb.append(currentMemo); sb.append("
"); sb.append("

"); sb.append("[スケジュールの変更]"); sb.append("  "); sb.append("[スケジュールの削除]"); sb.append("

"); sb.append("
"); sb.append("
"); sb.append(""); sb.append(""); out.println(new String(sb)); } protected int getMonthLastDay(int year, int month, int day){ Calendar calendar = Calendar.getInstance(); /* 今月が何日までかを確認する */ calendar.set(year, month + 1, 0); int thisMonthlastDay = calendar.get(Calendar.DATE); return thisMonthlastDay; } }