📄 news_register_err_lhl.jsp
字号:
<%@ page language="java" pageEncoding="EUC-KR"%>
<%@ page import="java.io.*,java.text.*,java.util.Date,java.util.Vector, java.sql.*, com.entaz.lib.db.*, com.entaz.relay.net.* "%>
<%@ include file="../imgpath.jsp"%>
<%@ include file="../common_func.jsp"%>
<%@ include file="formatUtil.jsp"%>
<%
int idxNsNews = Integer.parseInt(request.getParameter("idxNsNews"));
int idxNsNewsRE = 0;//Integer.parseInt(request.getParameter("idxNsNewsRE"));
Object idxNsNewsREObj = request.getParameter("idxNsNewsRE");
if(idxNsNewsREObj != null) {
idxNsNewsRE = Integer.parseInt(request.getParameter("idxNsNewsRE"));
}
String mphone = request.getParameter("mphone");
String gphone = request.getParameter("gphone");
String text = request.getParameter("text");
String url = "other_news_view_top_lhl.jsp?idxNsNews=" + idxNsNews + "&mphone=" + mphone + "&gphone=" + gphone + "&text" + text;
Connection con = null;
PreparedStatement pstmt = null;
Statement stmt = null;
ResultSet rs = null;
%>
<%@ include file="../getConnection.jsp"%>
<%
try {
String nickname = "nickname";
String queryString = "select nickname from GT_user_info where phonenum=?";
pstmt = con.prepareStatement(queryString);
pstmt.setString(1, getStr(mphone));
rs = pstmt.executeQuery();
while(rs.next())
{
nickname = rs.getString("nickname");
}
if(text.length()<800) {
System.out.println("text.length=" + text.length());
if(idxNsNewsRE == 0) {
String insertString = "insert into GT_NsNewsRE (phonenum,nickname,text,ref_idx,takeFlag) values(?,?,?,?,?)";
pstmt = con.prepareStatement(insertString);
pstmt.setLong(1, getLong(mphone));
pstmt.setString(2, nickname);
pstmt.setString(3, text);
pstmt.setInt(4, idxNsNews);
pstmt.setInt(5, 0);
pstmt.executeUpdate();
}
else {
String queryNsNewsREString = "update gt_nsnewsre set text= ? where idx= ?";
pstmt = con.prepareStatement(queryNsNewsREString);
pstmt.setString(1, text);
pstmt.setInt(2, idxNsNewsRE);
pstmt.executeUpdate();
}
rs.close();
pstmt.close();
con.close();
request.getRequestDispatcher(url).forward(request,response);
} else {
//String
System.out.println("text.length=" + text.length());
%>
<html>
<head>
<title></title>
<link rel="stylesheet" href="../mobile.css" type="text/css"></link>
</head>
<body>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<!-- 鸥捞撇 矫累 -->
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr height="19">
<td width="8" bgcolor="#ff4d72"></td>
<td bgcolor="#ff4d72"><font color="#ffffff">舅覆芒</font></td>
</tr>
</table>
</td>
</tr>
<!-- 鸥捞撇 场 -->
<!-- 咯归 矫累 -->
<tr height="8">
<td></td>
</tr>
<!-- 咯归 场 -->
<!-- 冠胶 矫累 -->
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr height="3">
<td colspan="3" bgcolor="#dae6e8"></td>
</tr>
<tr height="18">
<td bgcolor="#dae6e8" width="3"></td>
<td></td>
<td bgcolor="#dae6e8" width="3"></td>
</tr>
<tr>
<td bgcolor="#dae6e8" width="3"></td>
<td align="center">
涝仿俊 坷幅啊 乐嚼聪促.<br>
促矫 涝仿秦林技夸.<br>
</td>
<td bgcolor="#dae6e8" width="3"></td>
</tr>
<tr height="18">
<td bgcolor="#dae6e8" width="3"></td>
<td></td>
<td bgcolor="#dae6e8" width="3"></td>
</tr>
<tr height="3">
<td colspan="3" bgcolor="#dae6e8"></td>
</tr>
</table>
</td>
</tr>
<!-- 冠胶 场 -->
<!-- 咯归 矫累 -->
<tr height="4">
<td></td>
</tr>
<!-- 咯归 场 -->
<!-- 滚瓢 矫累 -->
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr height="16">
<td></td>
<td width="72" bgcolor="#ff4d72" align="center" ><a href="#"><font color="#ffffff">犁涝仿</font></a></td>
<td width="2"></td>
<td width="72" bgcolor="#ff4d72" align="center" ><a href="#"><font color="#ffffff">迄乔春胶肺</font></a></td>
<td></td>
</tr>
</table>
</td>
</tr>
<!-- 滚瓢 场 -->
<!-- 咯归 矫累 -->
<tr height="53">
<td></td>
</tr>
<!-- 咯归 场 -->
<!--版肺钎矫 矫累-->
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr height="15">
<td width="8" bgcolor="#BBC7C8"></td>
<td bgcolor="#DAE6E8">
<a href="#">权</a>><a href="#">硅萍丛狼 迄乔</a>><a href="#">春胶</a>>舅覆芒
</td>
<td width="8" bgcolor="#BBC7C8"></td>
</tr>
</table>
</td>
</tr>
<!--版肺钎矫 场-->
</table>
<%
}
} catch(Exception e) {
e.printStackTrace();
}
%>
<%@ include file="../newbottom.jsp"%>
</body>
</html>
<%!
public String getTime()
{
java.text.SimpleDateFormat tempDate = new java.text.SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
String datetime = tempDate.format(new java.util.Date());
return datetime;
}
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -