📄 modify_customer.jsp
字号:
}
.row3 {
PADDING-RIGHT: 3px; PADDING-LEFT: 3px; PADDING-BOTTOM: 3px; MARGIN: 3px; PADDING-TOP: 3px; BACKGROUND-COLOR: #f3f3f3
}
.row4 {
COLOR: #ffffff; BACKGROUND-COLOR: #84b5e3
}
.row5 {
BACKGROUND-COLOR: #f6f6f6
}
.row1shaded {
BACKGROUND-COLOR: #e3dfe7
}
.row2shaded {
BACKGROUND-COLOR: #dedbe4
}
.tablepad {
PADDING-RIGHT: 6px; PADDING-LEFT: 6px; PADDING-BOTTOM: 6px; PADDING-TOP: 6px; BACKGROUND-COLOR: #ffffff
}
.pagelinks {
FLOAT: left; WIDTH: 35%; LINE-HEIGHT: 1.2em
}
.highlight {
FONT-WEIGHT: bold; COLOR: #f00; BACKGROUND-COLOR: #ff0
}
.editinfo {
FONT-WEIGHT: bold; COLOR: #4685c4; BACKGROUND-COLOR: #e9f1f8
}
.time {
FONT-SIZE: 11px
}
.button {
BORDER-RIGHT: #b7c0c7 1px solid; PADDING-RIGHT: 3px; BORDER-TOP: #b7c0c7 1px solid; PADDING-LEFT: 3px; PADDING-BOTTOM: 0px; MARGIN: 0px; VERTICAL-ALIGN: middle; BORDER-LEFT: #b7c0c7 1px solid; PADDING-TOP: 1px; BORDER-BOTTOM: #b7c0c7 1px solid; BACKGROUND-COLOR: #f3f4f5
}
.quotetop {
FONT-WEIGHT: bold; MARGIN: 0px auto; WIDTH: 85%; COLOR: #000000
}
.quotemain {
BORDER-RIGHT: #dddddd 1px inset; PADDING-RIGHT: 5px; BORDER-TOP: #dddddd 1px inset; PADDING-LEFT: 5px; PADDING-BOTTOM: 5px; MARGIN: 0px auto 8px; BORDER-LEFT: #dddddd 1px inset; WIDTH: 85%; COLOR: #465584; PADDING-TOP: 5px; BORDER-BOTTOM: #dddddd 1px inset; BACKGROUND-COLOR: #e9f1f8
}
.codetop {
FONT-WEIGHT: bold; MARGIN: 0px auto; WIDTH: 85%; COLOR: #000000
}
.codemain {
BORDER-RIGHT: #dddddd 1px inset; PADDING-RIGHT: 5px; BORDER-TOP: #dddddd 1px inset; PADDING-LEFT: 5px; PADDING-BOTTOM: 5px; MARGIN: 0px auto 8px; BORDER-LEFT: #dddddd 1px inset; WIDTH: 85%; COLOR: #465584; PADDING-TOP: 5px; BORDER-BOTTOM: #dddddd 1px inset; FONT-FAMILY: Courier, Tahoma, Serif, Simsun; BACKGROUND-COLOR: #e9f1f8
}
.colorpreview {
BORDER-RIGHT: #000000 1px inset; BORDER-TOP: #000000 1px inset; BORDER-LEFT: #000000 1px inset; CURSOR: hand; BORDER-BOTTOM: #000000 1px inset
}
#colorPicker {
BACKGROUND: black; LEFT: 0px; WIDTH: 253px; POSITION: absolute; TOP: 0px
}
.colorBg {
BORDER-RIGHT: 2px outset; BORDER-TOP: 2px outset; BACKGROUND: #eef0f2; BORDER-LEFT: 2px outset; COLOR: #001f30; BORDER-BOTTOM: 2px outset
}
#colorFeedback {
BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; WIDTH: 253px; BORDER-BOTTOM: black 1px solid
}
#colorFeedback BUTTON {
WIDTH: 19px; HEIGHT: 19px
}
#txtColor {
BORDER-RIGHT: 1px inset; BORDER-TOP: 1px inset; BORDER-LEFT: 1px inset; WIDTH: 70px; BORDER-BOTTOM: 1px inset
}
#colorSurround {
BORDER-RIGHT: 1px inset; BORDER-TOP: 1px inset; BORDER-LEFT: 1px inset; WIDTH: 66px; BORDER-BOTTOM: 1px inset; WHITE-SPACE: nowrap; HEIGHT: 15px
}
#colorSurround TD {
WIDTH: 33px; BORDER-TOP-STYLE: none; BORDER-RIGHT-STYLE: none; BORDER-LEFT-STYLE: none; HEIGHT: 15px; BORDER-BOTTOM-STYLE: none
}
#swatches {
WIDTH: 253px
}
#swatches TD {
BACKGROUND: black; WIDTH: 11px; BORDER-TOP-STYLE: none; BORDER-RIGHT-STYLE: none; BORDER-LEFT-STYLE: none; HEIGHT: 11px; BORDER-BOTTOM-STYLE: none
}
.editor {
BORDER-RIGHT: 1px ridge; BORDER-TOP: 1px ridge; BORDER-LEFT: 1px ridge; BORDER-BOTTOM: 1px ridge; BACKGROUND-COLOR: #f0f0ee
}
.editorbar {
BORDER-RIGHT: #cccccc 1px solid; BORDER-TOP: #cccccc 1px solid; BACKGROUND: #f0f0ee; BORDER-LEFT: #cccccc 1px solid; BORDER-BOTTOM: #cccccc 1px solid
}
.editortext {
FONT-SIZE: 9pt
}
.editorbutton {
BORDER-RIGHT: #4c77b6 1px solid; BORDER-TOP: #4c77b6 1px solid; FONT-SIZE: 10px; VERTICAL-ALIGN: middle; BORDER-LEFT: #4c77b6 1px solid; BORDER-BOTTOM: #4c77b6 1px solid; FONT-FAMILY: Sans-Serif; BACKGROUND-COLOR: #ffffff
}
.loanwarn {
FONT-WEIGHT: bold; COLOR: #cc0000
}
.posttop {
FONT-SIZE: 10px; FONT-FAMILY: Verdana, Simsun
}
.reputation {
BORDER-RIGHT: #000000 1px dashed; PADDING-RIGHT: 5px; BORDER-TOP: #000000 1px dashed; PADDING-LEFT: 5px; PADDING-BOTTOM: 5px; MARGIN: 5px; BORDER-LEFT: #000000 1px dashed; PADDING-TOP: 5px; BORDER-BOTTOM: #000000 1px dashed; BACKGROUND-COLOR: #e9f1f8; TEXT-ALIGN: center
}
.hidetop {
FONT-WEIGHT: bold; MARGIN: 0px auto; WIDTH: 70%; COLOR: #000000
}
.hidemain {
BORDER-RIGHT: #666666 1px inset; PADDING-RIGHT: 4px; BORDER-TOP: #666666 1px inset; PADDING-LEFT: 4px; PADDING-BOTTOM: 4px; MARGIN: 0px auto 8px; BORDER-LEFT: #666666 1px inset; WIDTH: 70%; COLOR: #465584; PADDING-TOP: 4px; BORDER-BOTTOM: #666666 1px inset; BACKGROUND-COLOR: #fafcfe
}
</STYLE>
<META content="MSHTML 6.00.2900.2802" name=GENERATOR></HEAD>
<BODY>
<SCRIPT src="ForumMainWebFile/global.js"
type=text/javascript></SCRIPT>
<TABLE cellSpacing=0 cellPadding=0>
<TBODY>
<TR>
<TD width="50%"><embed
pluginspage=http://www.macromedia.com/go/getflashplayer
src=ForumMainWebFile/effect24.swf width=1005 height=190
type=application/x-shockwave-flash quality="high"></embed></TD>
<TD width="50%"
background="ForumMainWebFile/top_bg.jpg"></TD></TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width="100%" align=center>
<TBODY>
<TR>
<TD><IMG
src="ForumMainWebFile/main_left.gif"></TD>
<TD width="100%"
background="ForumMainWebFile/main_bg.gif"></TD>
<TD><IMG
src="ForumMainWebFile/main_right.gif"></TD></TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width="100%" align=center>
<TBODY>
<TR>
<TD
background="ForumMainWebFile/main_left_bg.gif"><IMG
src="ForumMainWebFile/main_left_bg.gif"></TD>
<TD style="BACKGROUND: url(images/style_4/main_bgs.gif) repeat-x"
width="100%">
</td></tr>
<tr>
</tr></tbody></table>
<TABLE cellSpacing=0 cellPadding=0 width="98%" align=center>
<TBODY>
<TR>
<TD><IMG
src="ForumMainWebFile/menu_left.gif"></TD>
<TD id=menu width="100%"
background="ForumMainWebFile/menu.gif"
height=25>
<DIV align=left>您好，欢迎您使用本系统！
</DIV></TD>
<TD><IMG
src="ForumMainWebFile/menu_right.gif"></TD></TR></TBODY></TABLE>
<BR>
<TABLE class=navlink cellSpacing=0 cellPadding=0 width="98%">
<TBODY>
<TR>
<TD width="100%"><IMG alt=东盟化工---客户关系管理系统
src="ForumMainWebFile/nav.gif"
border=0> 东盟化工---客户关系管理系统
» 修改客户信息 </TD>
<TD noWrap align=right></TD></TR></TBODY></TABLE>
<%
String c_id=request.getParameter("c_id");
c_id=new String(c_id.getBytes("ISO8859-1"),"gb2312");
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=dengfen";
String user="sa";
String password="123";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String name="";
String sex="";
String card_id="";
String adress="";
String birthday="";
String phone="";
String mobile_phone="";
String fax="";
String email="";
String remark="";
String male_or_not="";
String female_or_not="";
String sql1="select * from customer where c_id='"+c_id+"'";
ResultSet rs=stmt.executeQuery(sql1);
while(rs.next())
{
name=rs.getString(2);
sex=rs.getString(3);
if(sex.equals("男"))
{male_or_not="checked";}
else
{female_or_not="checked";}
card_id=rs.getString(4);
adress=rs.getString(5);
birthday=rs.getString(6);
phone=rs.getString(7);
mobile_phone=rs.getString(8);
fax=rs.getString(9);
email=rs.getString(10);
remark=rs.getString(11);
}
//String sql_insert="insert into customer values('"+c_id+"','"+c_name+"','"+sex+"','"+card_id+"','"+adress+"','"+birthday+"','"+phone+"','"+mobile_phone+"','"+fax+"','"+email+"','"+remark+"')";
//Statement stmt1=conn.createStatement();
//stmt1.executeUpdate(sql_insert);
rs.close();
stmt.close();
//stmt1.close();
conn.close();
%>
<form action="modify_customer1.jsp" onsubmit="return formcheck()" method="post" name="customer_form">
<TABLE id=ttable cellSpacing=1 cellPadding=4 width="97%" border=0>
<TBODY>
<TR>
<TD class=thead colSpan=6><IMG alt=""
src="ForumMainWebFile/nav_m.gif"
border=0>客户档案——修改:(请注意：带有“*”的项目必须填写。) </TD>
</TR>
<TR class=tcat>
<TH noWrap align=left width="34%"> * 客户姓名: <input name="c_name" type="text" maxlength="300" value="<%=name%>"></TH>
<TH noWrap align=left width="33%"> * 助记码： <input name="c_id" type="text" maxlength="300" value="<%=c_id%>" readonly="true">(只读)</TH>
<TH noWrap align=left width="33%"> 积分卡卡号： <input name="card_id" type="text" maxlength="300" value="<%=card_id%>"></TH>
</tr>
<TR class=tcat>
<TH noWrap align=left width="34%"> 地 址: <input name="adress" type="text" maxlength="300" value="<%=adress%>"></TH>
<TH noWrap align=left width="33%"> 邮 箱: <input name="email" type="text" maxlength="300" value="<%=email%>"></TH>
<TH noWrap align=left width="33%"> 生 日： <input name="birthday" type="text" maxlength="300" value="<%=birthday%>"></TH>
</tr>
<TR class=tcat>
<TH noWrap align=left width="34%"> 电 话: <input name="phone" type="text" maxlength="300" value="<%=phone%>"></TH>
<TH noWrap align=left width="33%"> 手 机： <input name="mobile_phone" type="text" maxlength="300" value="<%=mobile_phone%>"></TH>
<TH noWrap align=left width="33%"> 传 真： <input name="fax" type="text" maxlength="300" value="<%=fax%>"></TH>
</tr>
<TR class=tcat>
<TH noWrap align=left width="34%"> 性 别： <input name="sex" type="radio" value="male" <%=male_or_not%>>
男 <input name="sex" type="radio" value="female" <%=female_or_not%>>女</TH>
<TH noWrap align=left width="33%"> 其 它： <textarea name="remark" cols="40" rows="2" ><%=remark%></textarea></TH>
<TH noWrap align=left width="33%"></th>
</tr>
</table>
<table>
<tr>
<td width="480"></td>
<td width="50" align="center">
<input name="submit" type="submit" value="修改">
</td>
<td width="50" align="center">
</td>
</tr>
</table>
</form>
<BR>
<TABLE cellSpacing=3 cellPadding=0 width="100%">
<TBODY>
</TBODY></TABLE>
</BODY></HTML>
<jsp:useBean id="date1" scope="session" class="java.util.Date" />
<div align='center'><p>所有时间均为北京时间. 当前时间为: <%=date1%></p></div>
<TABLE cellSpacing=3 cellPadding=0 width="100%" height="200">
<TBODY>
</TBODY></TABLE>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -