newsmain_jsp.java

用手机浏览的一个类似于聊天室 博克 homepage 等 对这方面有 兴趣的朋友 有所帮助的

      out.write("\t\t\t\t\t\t\t\t<td width=\"2\"></td>\r\n");
      out.write("\t\t\t\t\t\t\t\t<td align=\"center\" width=\"70\" bgcolor=\"#efebd5\"><a href=\"");
      out.print(url_path);
      out.write("/news/");
      out.print(strJSPLink);
      out.write("?mphone=");
      out.print(mphone);
      out.write("&gphone=");
      out.print(gphone);
      out.write("\"><font color=\"#716e63\" size=\"3\">30문30답보기</font></a></td>\r\n");
      out.write("\t\t\t\t\t\t\t\t\r\n");
      out.write("\t\t\t\t\t\t\t\t<td></td>\r\n");
      out.write("\t\t\t\t\t\t\t\t\r\n");
      out.write("\t\t\t\t\t\t\t</tr>\r\n");
      out.write("\t\t\t\t\t\t</table>\r\n");
      out.write("\t\t\t\t\t</td>\r\n");
      out.write("\t\t\t\t</tr>\r\n");
      out.write("\t\t\t</table>\t\t\r\n");
      out.write("\t\t</td>\r\n");
      out.write("\t</tr>\r\n");
      out.write("\t<!-- 버튼 끝 -->\r\n");
      out.write("\r\n");
      out.write("\t<!-- 뉴스 컨텐츠 끝 -->\r\n");
      out.write("\r\n");
      out.write("\t<!-- 여백 시작 -->\r\n");
      out.write("\t<tr>\r\n");
      out.write("\t\t<td height=\"11\"></td>\r\n");
      out.write("\t</tr>\r\n");
      out.write("\t<!-- 여백 끝 -->\r\n");
      out.write("\t\r\n");
      out.write("\t<!-- 뉴스 리스트 시작 -->\r\n");
      out.write("\t<tr>\r\n");
      out.write("\t\t<td>\t\t\t\r\n");
      out.write("\t\t\t<table width=\"240\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n");
      out.write("\t\t\t\t<!-- 최근뉴스 타이틀 시작 -->\r\n");
      out.write("\t\t\t\t<tr height=\"17\">\r\n");
      out.write("\t\t\t\t\t<td width=\"10\" bgcolor=\"");
      out.print(mainBgColor);
      out.write("\"></td>\t\t\t\t\t\r\n");
      out.write("\t\t\t\t\t<td bgcolor=\"");
      out.print(mainBgColor);
      out.write("\"><font color=\"#ffffff\">::: ");
      out.print(nickName);
      out.write("님의 최근 뉴스</font></td>\r\n");
      out.write("\t\t\t\t</tr>\r\n");
      out.write("\t\t\t\t<tr height=\"4\">\r\n");
      out.write("\t\t\t\t\t<td width=\"10\"></td>\t\t\t\t\t\r\n");
      out.write("\t\t\t\t\t<td></td>\r\n");
      out.write("\t\t\t\t</tr>\r\n");
      out.write("\t\t\t\t<!-- 최근뉴스 타이틀 끝 -->\r\n");
      out.write("\t\t\t\t\r\n");
      out.write("\t\t\t\t<!-- 최근뉴스 컨텐츠 시작 -->\r\n");
      out.write("\t\t\t\t\r\n");
      out.write("\t\t\t\t\t");

						sql = "SELECT TOP 1 kind, title, reCnt, regdate FROM GT_NSNEWS WITH (READUNCOMMITTED) WHERE PHONENUM = " + Long.parseLong(gphone) + " ORDER BY regdate DESC"; 
						pstmt = con.prepareStatement(sql);
						rs = pstmt.executeQuery();
						
						if (rs.next())
						{
							iNewsKind		= rs.getInt("kind");
							strNewsTitle	= rs.getString("title");
							iNewsReCnt		= rs.getInt("reCnt");
							strRegdate		= rs.getString("regdate");
							if (iNewsKind == 1)
								strNewsKind = "[사건/사고]";
							else if (iNewsKind == 2)
								strNewsKind = "[지역]";
							else if (iNewsKind == 3)
								strNewsKind = "[연예/스포츠]";
							else if (iNewsKind == 4)
								strNewsKind = "[기타]";
							cStringTypeLength = 15 - strNewsKind.length();
							strPrintNewsTitle = cStringTypeLength < strNewsTitle.length() ? strNewsTitle.substring(0,cStringTypeLength) + "..." : strNewsTitle;
							strRegdate = strRegdate.replace("-", "/");
							strRegdate = strRegdate.substring(5,16);
							rs.close();
							pstmt.close();
							if (mphone.equals(gphone))
					 			strJSPLink = "my_news_list_lhl.jsp";
					 		else
					 			strJSPLink = "other_news_list_lhl.jsp";
							
      out.write("\r\n");
      out.write("\t\t\t\t\t\t\t<tr>\r\n");
      out.write("\t\t\t\t\t\t\t<td width=\"10\"></td>\r\n");
      out.write("\t\t\t\t\t\t\t<td>\r\n");
      out.write("\t\t\t\t\t\t\t\t<font color=\"");
      out.print(mainFontColor);
      out.write('"');
      out.write('>');
      out.print(strNewsKind);
      out.write(" </font><a href=\"");
      out.print(url_path);
      out.write("/news/");
      out.print(strJSPLink);
      out.write("?mphone=");
      out.print(mphone);
      out.write("&gphone=");
      out.print(gphone);
      out.write('"');
      out.write('>');
      out.print(strPrintNewsTitle);
      out.write("</a><font color=\"");
      out.print(mainFontColor);
      out.write("\"> [");
      out.print(iNewsReCnt);
      out.write("]</font><br>\r\n");
      out.write("\t\t\t\t\t\t\t\t&nbsp;&nbsp;<font color=\"#928279\" size=\"3\">");
      out.print(strRegdate);
      out.write("</font>\r\n");
      out.write("\t\t\t\t\t\t\t</td>\r\n");
      out.write("\t\t\t\t\t\t\t</tr>\r\n");
      out.write("\t\t\t\t\t\t\t");

						}
						else
						{
						
      out.write("\r\n");
      out.write("\t\t\t\t\t\t<tr>\r\n");
      out.write("\t\t\t\t\t\t<td width=\"10\"></td>\r\n");
      out.write("\t\t\t\t\t\t\t<td>\r\n");
      out.write("\t\t\t\t\t\t\t\t등록된 최신 뉴스가 없습니다.\r\n");
      out.write("\t\t\t\t\t\t\t</td>\r\n");
      out.write("\t\t\t\t\t\t</tr>\r\n");
      out.write("\t\t\t\t\t\t\t");
if (mphone.equals(gphone)) {
      out.write("\r\n");
      out.write("\t\t\t\t\t\t<tr>\r\n");
      out.write("\t\t\t\t\t\t\t<td width=\"10\"></td>\t\t\t\t\t\r\n");
      out.write("\t\t\t\t\t\t\t<td align=\"right\"><font color=\"#928279\" size=\"3\"><a href=\"");
      out.print(url_path);
      out.write("/news/my_news_register_lhl.jsp?mphone=");
      out.print(mphone);
      out.write("&gphone=");
      out.print(gphone);
      out.write("\">새글등록▶</a>&nbsp;&nbsp;</font></td>\r\n");
      out.write("\t\t\t\t\t\t</tr>\r\n");
      out.write("\t\t\t\t\t\t");
} 
						}
      out.write("\t\t\t\t\t\r\n");
      out.write("\t\t\t\t\t\r\n");
      out.write("\t\t\t\r\n");
      out.write("\t\t\t\t\r\n");
      out.write("\t\t\t\t<tr height=\"4\">\r\n");
      out.write("\t\t\t\t\t<td width=\"10\"></td>\t\t\t\t\t\r\n");
      out.write("\t\t\t\t\t<td></td>\r\n");
      out.write("\t\t\t\t</tr>\r\n");
      out.write("\t\t\t\t<!-- 최근뉴스 컨텐츠 끝 -->\r\n");
      out.write("\r\n");
      out.write("\t\t\t\t<!-- 퀴즈배티 타이틀 시작 -->\r\n");
      out.write("\t\t\t\t<tr height=\"17\">\r\n");
      out.write("\t\t\t\t\t<td width=\"10\" bgcolor=\"");
      out.print(mainBgColor);
      out.write("\"></td>\t\t\t\t\t\r\n");
      out.write("\t\t\t\t\t<td bgcolor=\"");
      out.print(mainBgColor);
      out.write("\"><font color=\"#ffffff\">::: 퀴즈!");
      out.print(nickName);
      out.write(" 이야기!</font></td>\r\n");
      out.write("\t\t\t\t</tr>\r\n");
      out.write("\t\t\t\t<tr height=\"4\">\r\n");
      out.write("\t\t\t\t\t<td width=\"10\"></td>\t\t\t\t\t\r\n");
      out.write("\t\t\t\t\t<td></td>\r\n");
      out.write("\t\t\t\t</tr>\r\n");
      out.write("\t\t\t\t<!-- 퀴즈배티 타이틀 끝 -->\r\n");
      out.write("\t\t\t\t\r\n");
      out.write("\t\t\t\t<!-- 퀴즈배티 컨텐츠 시작 -->\r\n");
      out.write("\t\t\t\t\t\r\n");
      out.write("\t\t\t\t\t");

						sql = "SELECT TOP 1 kind, title, reCnt, regdate FROM GT_NsQuiz WITH (READUNCOMMITTED) WHERE PHONENUM = " + Long.parseLong(gphone) + " ORDER BY regdate DESC"; 
						pstmt = con.prepareStatement(sql);
						rs = pstmt.executeQuery();
						
						if (rs.next())
						{
						
							iNewsKind		= rs.getInt("kind");
							strNewsTitle	= rs.getString("title");
							iNewsReCnt		= rs.getInt("reCnt");
							strRegdate		= rs.getString("regdate");
							
							if (iNewsKind == 1)
								strNewsKind = "[내취향]";
							else if (iNewsKind == 2)
								strNewsKind = "[내비밀]";
							else if (iNewsKind == 3)
								strNewsKind = "[내성향]";
							else if (iNewsKind == 4)
								strNewsKind = "[기타]";
							cStringTypeLength = 15 - strNewsKind.length();
							strPrintNewsTitle = cStringTypeLength < strNewsTitle.length() ? strNewsTitle.substring(0,cStringTypeLength) + "..." : strNewsTitle;	
							
							strRegdate = strRegdate.replace("-", "/");
							strRegdate = strRegdate.substring(5,16);
									
							rs.close();
							pstmt.close();
							strJSPLink = "myQuizList.jsp";
						
      out.write("\r\n");
      out.write("\t\t\t\t\t\t<tr>\r\n");
      out.write("\t\t\t\t\t\t<td width=\"10\"></td>\r\n");
      out.write("\t\t\t\t\t\t\t<td>\r\n");
      out.write("\t\t\t\t\t\t\t\t<font color=\"");
      out.print(mainFontColor);
      out.write('"');
      out.write('>');
      out.print(strNewsKind);
      out.write(" </font><a href=\"");
      out.print(url_path);
      out.write("/news/");
      out.print(strJSPLink);
      out.write("?mphone=");
      out.print(mphone);
      out.write("&gphone=");
      out.print(gphone);
      out.write('"');
      out.write('>');
      out.print(strPrintNewsTitle);
      out.write("</a><font color=\"");
      out.print(mainFontColor);
      out.write("\"> [");
      out.print(iNewsReCnt);
      out.write("]</font><br>\r\n");
      out.write("\t\t\t\t\t\t\t\t&nbsp;&nbsp;<font color=\"#928279\" size=\"3\">");
      out.print(strRegdate);
      out.write("</font>\r\n");
      out.write("\t\t\t\t\t\t\t</td>\r\n");
      out.write("\t\t\t\t\t\t</tr>\r\n");
      out.write("\t\t\t\t\t\t\t");

						}
						else
						{
						
      out.write("\r\n");
      out.write("\t\t\t\t\t\t<tr>\r\n");
      out.write("\t\t\t\t\t\t<td width=\"10\"></td>\r\n");
      out.write("\t\t\t\t\t\t\t<td>\r\n");
      out.write("\t\t\t\t\t\t\t\t 등록된 퀴즈가 없습니다.\r\n");
      out.write("\t\t\t\t\t\t\t</td>\r\n");
      out.write("\t\t\t\t\t\t</tr>\r\n");
      out.write("\t\t\t\t\t\t");
if (mphone.equals(gphone)) {
      out.write("\r\n");
      out.write("\t\t\t\t\t\t<tr>\r\n");
      out.write("\t\t\t\t\t\t\t<td width=\"10\"></td>\t\t\t\t\t\r\n");
      out.write("\t\t\t\t\t\t\t<td align=\"right\"><font color=\"#928279\" size=\"3\"><a href=\"");
      out.print(url_path);
      out.write("/news/myQuizAdd.jsp?mphone=");
      out.print(mphone);
      out.write("&gphone=");
      out.print(gphone);
      out.write("&backLinkFlag=1\">새글등록▶</a>&nbsp;&nbsp;</font></td>\r\n");
      out.write("\t\t\t\t\t\t</tr>\r\n");
      out.write("\t\t\t\t\t\t\t");
} 
						}						
					
      out.write("\t\t\t\t\t\r\n");
      out.write("\t\t\t\t\r\n");
      out.write("\t\t\t\t\r\n");
      out.write("\t\t\t\t<tr height=\"4\">\r\n");
      out.write("\t\t\t\t\t<td width=\"10\"></td>\t\t\t\t\t\r\n");
      out.write("\t\t\t\t\t<td></td>\r\n");
      out.write("\t\t\t\t</tr>\r\n");
      out.write("\t\t\t\t<!-- 퀴즈배티 컨텐츠 끝 -->\r\n");
      out.write("\r\n");
      out.write("\t\t\t\t<!-- 설문조사 타이틀 시작 -->\r\n");
      out.write("\t\t\t\t<tr height=\"17\">\r\n");
      out.write("\t\t\t\t\t<td width=\"10\" bgcolor=\"");
      out.print(mainBgColor);
      out.write("\"></td>\t\t\t\t\t\r\n");
      out.write("\t\t\t\t\t<td bgcolor=\"");
      out.print(mainBgColor);
      out.write("\"><font color=\"#ffffff\">::: ");
      out.print(nickName);
      out.write("님의 설문조사</font></td>\r\n");
      out.write("\t\t\t\t</tr>\r\n");
      out.write("\t\t\t\t<tr height=\"4\">\r\n");
      out.write("\t\t\t\t\t<td width=\"10\"></td>\t\t\t\t\t\r\n");
      out.write("\t\t\t\t\t<td></td>\r\n");
      out.write("\t\t\t\t</tr>\r\n");
      out.write("\t\t\t\t<!-- 퀴즈배티 타이틀 끝 -->\r\n");
      out.write("\t\t\t\t\r\n");
      out.write("\t\t\t\t<!-- 퀴즈배티 컨텐츠 시작 -->\r\n");
      out.write("\t\t\t\t\r\n");
      out.write("\t\t\t\t\t");

						sql = "SELECT TOP 1 title, (Provision1Cnt + Provision2Cnt + Provision3Cnt + Provision4Cnt + Provision5Cnt) reCnt, regdate FROM GT_NsResearch WITH (READUNCOMMITTED) WHERE PHONENUM = " + Long.parseLong(gphone) + " ORDER BY regdate DESC"; 
						pstmt = con.prepareStatement(sql);
						rs = pstmt.executeQuery();
						
						if (rs.next())
						{
							strNewsTitle	= rs.getString("title");
							iNewsReCnt		= rs.getInt("reCnt");
							strRegdate		= rs.getString("regdate");

							strNewsKind = "Q.";
							
							cStringTypeLength = 15 - strNewsKind.length();
							strPrintNewsTitle = cStringTypeLength < strNewsTitle.length() ? strNewsTitle.substring(0,cStringTypeLength) + "..." : strNewsTitle;			
							strRegdate = strRegdate.replace("-", "/");
							strRegdate = strRegdate.substring(5,16);
							rs.close();
							pstmt.close();
							strJSPLink = "ResearchList.jsp";
						
      out.write("\r\n");
      out.write("\t\t\t\t\t<tr>\r\n");
      out.write("\t\t\t\t\t<td width=\"10\"></td>\t\t\t\t\t\r\n");
      out.write("\t\t\t\t\t<td>\r\n");
      out.write("\t\t\t\t\t\t<a href=\"");
      out.print(url_path);
      out.write("/news/");
      out.print(strJSPLink);
      out.write("?mphone=");
      out.print(mphone);
      out.write("&gphone=");
      out.print(gphone);
      out.write('"');
      out.write('>');
      out.print(strNewsKind);
      out.write(' ');
      out.print(strPrintNewsTitle);
      out.write("</a><font color=\"");
      out.print(mainFontColor);
      out.write("\"> [");
      out.print(iNewsReCnt);
      out.write("]</font><br>\r\n");
      out.write("\t\t\t\t\t\t&nbsp;&nbsp;<font color=\"#928279\" size=\"3\">");
      out.print(strRegdate);
      out.write("</font>\r\n");
      out.write("\t\t\t\t\t</td>\r\n");
      out.write("\t\t\t\t\t</tr>\r\n");
      out.write("\t\t\t\t\t");

						}
						else
						{
						
      out.write("\r\n");
      out.write("\t\t\t\t\t\t<tr>\r\n");
      out.write("\t\t\t\t\t\t\t<td width=\"10\"></td>\r\n");
      out.write("\t\t\t\t\t\t\t<td>\r\n");
      out.write("\t\t\t\t\t\t\t\t 등록된 설문조사가 없습니다.\r\n");
      out.write("\t\t\t\t\t\t\t</td>\r\n");
      out.write("\t\t\t\t\t\t</tr>\r\n");
      out.write("\t\t\t\t\t\t\t");
if (mphone.equals(gphone)) {
      out.write("\r\n");
      out.write("\t\t\t\t\t\t<tr>\r\n");
      out.write("\t\t\t\t\t\t\t<td width=\"10\"></td>\t\t\t\t\t\r\n");
      out.write("\t\t\t\t\t\t\t<td align=\"right\"><font color=\"#928279\" size=\"3\"><a href=\"");
      out.print(url_path);
      out.write("/news/ResearchRegister.jsp?mphone=");
      out.print(mphone);
      out.write("&gphone=");
      out.print(gphone);
      out.write("&backLinkFlag=1\">새글등록▶</a>&nbsp;&nbsp;</font></td>\r\n");
      out.write("\t\t\t\t\t\t</tr>\r\n");
      out.write("\t\t\t\t\t\t");
} 
						}						
					
      out.write("\t\r\n");
      out.write("\t\t\t\t\r\n");
      out.write("\t\t\t\t\r\n");
      out.write("\t\t\t\t<tr height=\"4\">\r\n");
      out.write("\t\t\t\t\t<td width=\"10\"></td>\t\t\t\t\t\r\n");
      out.write("\t\t\t\t\t<td></td>\r\n");
      out.write("\t\t\t\t</tr>\r\n");
      out.write("\t\t\t\t<!-- 퀴즈배티 컨텐츠 끝 -->\r\n");
      out.write("\t\t\t\t\r\n");
      out.write("\t\t\t\t<!-- 친구뉴스 타이틀 시작 -->\r\n");
      out.write("\t\t\t\t<tr height=\"17\">\r\n");
      out.write("\t\t\t\t\t<td width=\"10\" bgcolor=\"");
      out.print(mainBgColor);
      out.write("\"></td>\t\t\t\t\t\r\n");
      out.write("\t\t\t\t\t<td bgcolor=\"");
      out.print(mainBgColor);