📄 modify_deal.jsp
字号:
.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");
String name=request.getParameter("customer_name");
name=new String(name.getBytes("ISO8859-1"),"gb2312");
String deal_no_string=request.getParameter("deal_no");
deal_no_string=new String(deal_no_string.getBytes("ISO8859-1"),"gb2312");
int deal_no=Integer.valueOf(deal_no_string);
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 deal_date="";
String product="";
String price="";
String amount="";
String remark="";
String fax="";
String sql1="select * from deal where c_id='"+c_id+"' and deal_no='"+deal_no+"'";
ResultSet rs=stmt.executeQuery(sql1);
while(rs.next())
{
deal_date=rs.getString(3);
product=rs.getString(4);
price=rs.getString(5);
amount=rs.getString(6);
remark=rs.getString(7);
}
rs.close();
stmt.close();
//stmt1.close();
conn.close();
%>
<form action="modify_deal1.jsp" method="post" name="deal_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%>" readonly="true">(只读)</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="deal_date" type="text" maxlength="300" value="<%=deal_date%>"></TH>
</tr>
<TR class=tcat>
<TH noWrap align=left width="34%"> 产 品: <input name="product" type="text" maxlength="300" value="<%=product%>"></TH>
<TH noWrap align=left width="33%"> 单 价 : <input name="price" type="text" maxlength="300" value="<%=price%>"></TH>
<TH noWrap align=left width="33%"> 数 量： <input name="amount" type="text" maxlength="300" value="<%=amount%>"></TH>
</tr>
<TR class=tcat>
<TH noWrap align=left width="34%"> 备 注： <textarea name="remark" cols="40" rows="2" ><%=remark%></textarea></TH>
<TH noWrap align=left width="33%"><input name="deal_no" type="hidden" value="<%=deal_no_string%>"></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 + -