📄 profilemodify.jsp.svn-base
字号:
<!--------------------------------------------------------------------------------------------------------------
*@橇肺鞘 荐沥
*@Author : 弥眠岿 (2008-6-23)
--------------------------------------------------------------------------------------------------------------->
<%@ page import='java.io.*,java.text.*,java.util.Date,java.util.Vector, javax.servlet.http.HttpSession,java.sql.*, com.entaz.lib.db.*, com.entaz.relay.net.*' contentType='text/html;charset=euc-kr'%>
<%@ include file="../imgpath.jsp"%>
<%@ include file="../common_func.jsp"%>
<%@ include file="../makeKOR.jsp"%>
<%@ include file="appConstants.jsp"%>
<%@ include file="formatUtil.jsp"%>
<%
/*------------------------------------------------------------------------------------------------------
+ 扁夯 颇扼固磐
-------------------------------------------------------------------------------------------------------*/
String mphone= request.getParameter("mphone");
String gphone= request.getParameter("gphone");
mphone = getStrPhone(getLong(mphone));
gphone = getStrPhone(getLong(gphone));
String toolTip = "";
if(request.getParameter("toolTip")!=null){toolTip=java.net.URLDecoder.decode(makeKOR(request.getParameter("toolTip")));};
String toDo = "";
if(request.getParameter("toDo")!=null){toDo=java.net.URLDecoder.decode(makeKOR(request.getParameter("toDo")));}
String motto = "";
if(request.getParameter("motto")!=null){motto=java.net.URLDecoder.decode(makeKOR(request.getParameter("motto")));};
String friend = "";
if(request.getParameter("friend")!=null){friend=java.net.URLDecoder.decode(makeKOR(request.getParameter("friend")));};
String wish = "";
if(request.getParameter("wish")!=null){wish=java.net.URLDecoder.decode(makeKOR(request.getParameter("wish")));};
String interest = "";
if(request.getParameter("interest")!=null){interest=java.net.URLDecoder.decode(makeKOR(request.getParameter("interest")));};
String food = "";
if(request.getParameter("food")!=null){food=java.net.URLDecoder.decode(makeKOR(request.getParameter("food")));};
String music = "";
if(request.getParameter("music")!=null){music=java.net.URLDecoder.decode(makeKOR(request.getParameter("music")));};
String agony = "";
if(request.getParameter("agony")!=null){agony=java.net.URLDecoder.decode(makeKOR(request.getParameter("agony")));};
String lookMan = "";
if(request.getParameter("lookMan")!=null){lookMan=java.net.URLDecoder.decode(makeKOR(request.getParameter("lookMan")));};
String fault = "";
if(request.getParameter("fault")!=null){fault=java.net.URLDecoder.decode(makeKOR(request.getParameter("fault")));};
int face= 0;
if(request.getParameter("face")!=null && !request.getParameter("face").equals("") ){face = Integer.parseInt(request.getParameter("face"));}
/*------------------------------------------------------------------------------------------------------
+ 傈开 函荐
-------------------------------------------------------------------------------------------------------*/
String nickname = "";
String toolTip1 = "";
String toDo1 = "";
String motto1 = "";
String friend1 = "";
String wish1 = "";
String interest1 = "";
String food1 = "";
String music1 = "";
String agony1 = "";
String lookMan1 = "";
String fault1 = "";
int face1 =0;
/*------------------------------------------------------------------------------------------------------
+ DB 包访 函荐
-------------------------------------------------------------------------------------------------------*/
PreparedStatement pstmt = null;
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
String query1 = null;
try
{
/*------------------------------------------------------------------------------------------------
* DB 目池记
-------------------------------------------------------------------------------------------------*/
%><%@ include file="../getConnection.jsp"%><%@ include file="bgColor.jsp"%><%
/*------------------------------------------------------------------------------------------------
* 橇肺鞘 nickname
-------------------------------------------------------------------------------------------------*/
query1 = "SELECT nickname FROM gt_user_info WITH (READUNCOMMITTED) WHERE phonenum = ?";
pstmt = con.prepareStatement(query1);
pstmt.setString(1,gphone);
rs = pstmt.executeQuery();
if(rs.next())
{
nickname = rs.getString("nickname");
}
rs.close();
pstmt.close();
/*------------------------------------------------------------------------------------------------
* 橇肺鞘 select
-------------------------------------------------------------------------------------------------*/
query1="SELECT toolTip,toDo,motto,friend,wish,interest,food,music,agony,lookMan,fault,face FROM GT_NsProfile WITH (READUNCOMMITTED) WHERE phonenum=? AND "
+" CONVERT(char(20),regdate,110)= CONVERT(char(20),getdate(),110)";
pstmt = con.prepareStatement(query1);
pstmt.setLong(1,getLong(mphone));
rs = pstmt.executeQuery();
if(rs.next())
{
toolTip1 = rs.getString("toolTip");
toDo1 = rs.getString("toDo");
motto1 = rs.getString("motto");
friend1 = rs.getString("friend");
wish1 = rs.getString("wish");
interest1 = rs.getString("interest");
food1 = rs.getString("food");
music1 = rs.getString("music");
agony1 = rs.getString("agony");
lookMan1 = rs.getString("lookMan");
fault1 = rs.getString("fault");
face1 = rs.getInt("face");
}
rs.close();
pstmt.close();
/*------------------------------------------------------------------------------------------------
* 橇肺鞘 update
-------------------------------------------------------------------------------------------------*/
if(request.getParameter("flag")!=null&&request.getParameter("flag").equals("1"))
{
query1="UPDATE GT_NsProfile SET toolTip=?,toDo=?,motto=?,friend=?,wish=?,interest=?,food=?,music=?,agony=?,lookMan=?,fault=?,face=?"
+" WHERE phonenum=? AND CONVERT(char(20),regdate,110)= CONVERT(char(20),getdate(),110)";
pstmt = con.prepareStatement(query1);
pstmt.setString(1,toolTip);
pstmt.setString(2,toDo);
pstmt.setString(3,motto);
pstmt.setString(4,friend);
pstmt.setString(5,wish);
pstmt.setString(6,interest);
pstmt.setString(7,food);
pstmt.setString(8,music);
pstmt.setString(9,agony);
pstmt.setString(10,lookMan);
pstmt.setString(11,fault);
pstmt.setInt(12,face);
pstmt.setLong(13,getLong(mphone));
pstmt.executeUpdate();
pstmt.close();
response.sendRedirect("NewsMain.jsp?mphone="+mphone+"&gphone="+gphone);
}
/*------------------------------------------------------------------------------------------------
* 橇肺鞘 delete
-------------------------------------------------------------------------------------------------*/
if(request.getParameter("flag")!=null&&request.getParameter("flag").equals("2"))
{
query1 ="DELETE FROM GT_NsProfile WHERE phonenum=? AND CONVERT(char(20),regdate,110)= CONVERT(char(20),getdate(),110)";
pstmt = con.prepareStatement(query1);
pstmt.setLong(1,getLong(mphone));
pstmt.executeUpdate();
pstmt.close();
response.sendRedirect("NewsMain.jsp?mphone="+mphone+"&gphone="+gphone);
}
%>
<html>
<head>
<title></title>
<link href="http://entaz.mugeta.com/client/mugeta_v2_test/web/user/mobile.css" rel="stylesheet" type="text/css">
</head>
<body>
<form name="form1" action="ProfileModify.jsp" method="post">
<table width="240" border="0" cellspacing="0" cellpadding="0">
<!-- 鸥捞撇 矫累 -->
<tr>
<td>
<table width="240" border="0" cellspacing="0" cellpadding="0">
<tr height="19">
<td width="8" bgcolor="<%=mainBgColor %>">
<input type="hidden" name="mphone" value="<%=mphone%>">
<input type="hidden" name="gphone" value="<%=gphone%>">
<input type="hidden" name="nickname" value="<%=nickname%>">
<input type="hidden" name="flag" value="1">
</td>
<td bgcolor="<%=mainBgColor %>"><font color="#ffffff">迄乔春胶橇肺鞘荐沥</font></td>
</tr>
</table>
</td>
</tr>
<!-- 鸥捞撇 场 -->
<!-- 牧刨明 矫累 -->
<tr>
<!-- 坷疵狼茄付叼 矫累 -->
<td>
<table width="240" border="0" cellspacing="0" cellpadding="0">
<tr height="8">
<td width="20"></td>
<td></td>
<td width="20"></td>
</tr>
<tr>
<td width="20"></td>
<td>
<font color="#716e63">富浅急俊 焊咯龙 坷疵狼 茄付叼甫<br>殿废窍技夸. </font>
<font color="<%=btnFontColor %>" size="3">(60byte 茄臂 30磊 鳖瘤)</font>
</td>
<td width="20"></td>
</tr>
<tr height="6">
<td width="20"></td>
<td></td>
<td width="20"></td>
</tr>
<tr>
<td width="20"></td>
<td><input type="text" name="toolTip" width="200" defaultimemode="1" imemode="0" maxlength="60" value="<%=toolTip1%>"></td>
<td width="20"></td>
</tr>
<tr height="6">
<td width="20"></td>
<td></td>
<td width="20"></td>
</tr>
</table>
</td>
<!-- 坷疵狼茄付叼 场 -->
</tr>
<tr>
<!-- 痢急 矫累 -->
<td>
<table width="240" border="0" cellspacing="0" cellpadding="0">
<tr height="1">
<td width="4"></td>
<td bgcolor="#efebd5"></td>
<td width="4"></td>
</tr>
</table>
</td>
<!-- 痢急 场 -->
</tr>
<tr>
<!-- 坷疵狼且老 矫累 -->
<td>
<table width="240" border="0" cellspacing="0" cellpadding="0">
<tr height="6">
<td width="20"></td>
<td></td>
<td width="20"></td>
</tr>
<tr>
<td width="20"></td>
<td><font color="#716e63">+ 坷疵狼 且老</font></td>
<td width="20"></td>
</tr>
<tr height="6">
<td width="20"></td>
<td></td>
<td width="20"></td>
</tr>
<tr>
<td width="20"></td>
<td><input type="text" name="toDo" width="200" defaultimemode="1" imemode="0" maxlength="60" value="<%=toDo1%>"></td>
<td width="20"></td>
</tr>
<tr height="6">
<td width="20"></td>
<td></td>
<td width="20"></td>
</tr>
</table>
</td>
<!-- 坷疵狼且老 场 -->
</tr>
<tr>
<!-- 痢急 矫累 -->
<td>
<table width="240" border="0" cellspacing="0" cellpadding="0">
<tr height="1">
<td width="4"></td>
<td bgcolor="#efebd5"></td>
<td width="4"></td>
</tr>
</table>
</td>
<!-- 痢急 场 -->
</tr>
<tr>
<!-- 坷疵狼谅快疙 矫累 -->
<td>
<table width="240" border="0" cellspacing="0" cellpadding="0">
<tr height="6">
<td width="20"></td>
<td></td>
<td width="20"></td>
</tr>
<tr>
<td width="20"></td>
<td><font color="#716e63">+ 坷疵狼 谅快疙</font></td>
<td width="20"></td>
</tr>
<tr height="6">
<td width="20"></td>
<td></td>
<td width="20"></td>
</tr>
<tr>
<td width="20"></td>
<td><input type="text" name="motto" width="200" defaultimemode="1" imemode="0" maxlength="60" value="<%=motto1%>"></td>
<td width="20"></td>
</tr>
<tr height="6">
<td width="20"></td>
<td></td>
<td width="20"></td>
</tr>
</table>
</td>
<!-- 坷疵狼谅快疙 场 -->
</tr>
<tr>
<!-- 痢急 矫累 -->
<td>
<table width="240" border="0" cellspacing="0" cellpadding="0">
<tr height="1">
<td width="4"></td>
<td bgcolor="#efebd5"></td>
<td width="4"></td>
</tr>
</table>
</td>
<!-- 痢急 场 -->
</tr>
<tr>
<!-- 坷疵狼模备 矫累 -->
<td>
<table width="240" border="0" cellspacing="0" cellpadding="0">
<tr height="6">
<td width="20"></td>
<td></td>
<td width="20"></td>
</tr>
<tr>
<td width="20"></td>
<td><font color="#716e63">+ 坷疵狼 模备</font></td>
<td width="20"></td>
</tr>
<tr height="6">
<td width="20"></td>
<td></td>
<td width="20"></td>
</tr>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -