📄 main.jsp
字号:
<%
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 sql="";
%>
<%
if(CustomerId!=null)
{
type="id";
value=CustomerId;
}
if(type==null)
{
sql="select * from customer";
}
else
{
if(type.equals("id"))
{
sql="select * from customer where c_id like '%"+value+"%' ";
}
if(type.equals("name"))
{
sql="select * from customer where name like '%"+value+"%' ";
}
if(type.equals("card_id"))
{
sql="select * from customer where customer.card_id like '%"+value+"%' ";
}
}
ResultSet rs=stmt.executeQuery(sql);
%>
<TABLE class=navlink cellSpacing=0 cellPadding=0 width="97%" style="word-break:break-all">
<TBODY>
<TR>
<TD width="100%"><IMG alt=东盟化工---客户关系管理系统
src="ForumMainWebFile/nav.gif"
border=0> 东盟化工
» 客户名单 </TD>
<TD noWrap align=right></TD></TR></TBODY></TABLE>
<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="3%">助记码</TH>
<TH noWrap align=left width="5%">客户姓名</TH>
<TH noWrap align=middle width="2%">客户性别</TH>
<TH noWrap align=middle width="5%">积分卡卡号</TH>
<TH noWrap align=middle width="15%">地址</TH>
<TH noWrap align=middle width="10%">生日</TH>
<TH noWrap align=middle width="10%">电话</TH>
<TH noWrap align=middle width="10%">手机</TH>
<TH noWrap align=middle width="10%">传真</TH>
<TH noWrap align=middle width="10%">Email</TH>
<TH noWrap align=middle width="10%">其它</TH>
<TH noWrap align=middle width="10%">操作</TH>
</TR>
<%
while(rs.next())
{
String c_id=rs.getString(1);
//c_id=new String(c_id.getBytes("ISO8859-1"),"gb2312");
String name=rs.getString(2);
String sex=rs.getString(3);
String card_id=rs.getString(4);
String adress=rs.getString(5);
String birthday=rs.getString(6);
String phone=rs.getString(7);
String mobile_phone=rs.getString(8);
String fax=rs.getString(9);
String email=rs.getString(10);
String remark=rs.getString(11);
%>
<TR>
<TD class=row1 align=middle ><%=c_id%></TD>
<TD class=row1 align="center" ><a href="main.jsp?customer_id=<%=c_id%>" target="_self"><%=name%></a></TD>
<TD class=row2 align=middle> <%=sex%></TD>
<TD class=row2 align=middle> <%=card_id%></TD>
<TD class=row2 align=middle> <%=adress%></TD>
<TD class=row2 align=middle> <%=birthday%></TD>
<TD class=row2 align=middle> <%=phone%></TD>
<TD class=row2 align=middle> <%=mobile_phone%></TD>
<TD class=row2 align=middle> <%=fax%></TD>
<TD class=row2 align=middle> <%=email%></TD>
<TD class=row2 align=middle> <%=remark%></TD>
<TD class=row2 align=middle><a href="delete_customer.jsp?c_id=<%=c_id%>" >删除</a> <a href="modify_customer.jsp?c_id=<%=c_id%>" >修改</a></TD>
</TR>
<%
}%>
</TBODY></TABLE><BR>
<TABLE cellSpacing=0 cellPadding=0 width="100%">
<TBODY>
<TR>
<TD
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 5px; PADDING-TOP: 5px"
noWrap align=right> </TD>
</TR></TBODY></TABLE>
<%
String customer_id=request.getParameter("customer_id");
if(customer_id != null)
{
customer_id= new String(customer_id.getBytes("ISO8859-1"),"gb2312");
}
String customer_name="";
String sql1="select name from customer where c_id='"+customer_id+"'";
rs=stmt.executeQuery(sql1);
while(rs.next())
{
customer_name=rs.getString(1);
}
String sql2="select * from deal where c_id='"+customer_id+"'";
rs=stmt.executeQuery(sql2);
%>
<%if(customer_id != null)
{ %>
<TABLE class=navlink cellSpacing=0 cellPadding=0 width="98%">
<TBODY>
<TR>
<TD width="100%" height="14"><IMG alt=东盟化工---客户关系管理系统
src="ForumMainWebFile/nav.gif"
border=0> 东盟化工
» <a href="main.jsp?deal_add_check=yes&&customer_id=<%=customer_id%>">添加记录</a>» <a href="main.jsp?customer_id=<%=customer_id%>">取消添加</a></TD>
<TD noWrap align=right></TD></TR></TBODY></TABLE>
<%
} %>
<%
String deal_add_check=request.getParameter("deal_add_check");
if( (deal_add_check != null)&&(deal_add_check.length()!= 0 ) )
{
%>
<form action="add_deal.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>成交记录——新增: (客户名称——<%=customer_name%>) </TD>
</TR>
<TR class=tcat>
<TH noWrap align=left width="34%"> * 客户姓名: <input name="c_name" type="text" maxlength="300" value="<%=customer_name%>" readonly="true"> (只读)</TH>
<TH noWrap align=left width="33%"> * 助记码： <input name="c_id" type="text" maxlength="300" value="<%=customer_id%>" readonly="true"> (只读)</TH>
<TH noWrap align=left width="33%"> 成交日期：
<input name="deal_date" type="text" maxlength="300"></TH>
</tr>
<TR class=tcat>
<TH noWrap align=left width="34%"> 产品名称: <input name="product" type="text" maxlength="300"></TH>
<TH noWrap align=left width="33%"> 单 价 : <input name="price" type="text" maxlength="300"></TH>
<TH noWrap align=left width="33%"> 成交数量：
<input name="amount" type="text" maxlength="300"></TH>
</tr>
<TR class=tcat>
<TH noWrap align=left width="34%"> 备 注: <textarea name="remark" cols="40" rows="2"></textarea></TH>
<TH noWrap align=left width="33%"></th>
<TH noWrap align=left width="33%"></th>
</tr>
</table>
<table>
<tr>
<td width="25"></td>
<td width="50" align="center">
<input name="submit" type="submit" value="添加">
</td>
<td width="50" align="center">
<input name="reset" type="reset" value="清空">
</td>
</tr>
</table>
</form>
<%
}
%>
<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>
<TABLE id=ttable cellSpacing=1 cellPadding=3 width="97%" border=0>
<TBODY>
<TR>
<TD class=thead vAlign=center colSpan=7>
<DIV style="FLOAT: right"> </DIV><IMG
alt="" src="ForumMainWebFile/nav_m.gif"
border=0> 与客户 <%=customer_name%> 成交记录如下：</TD></TR>
<TR class=tcat>
<TH noWrap align=left width="5%">助记码</TH>
<TH noWrap align=middle width="5%">成交代号</TH>
<TH noWrap align=middle width="15%">成交日期</TH>
<TH noWrap align=middle width="20%">产品名称</TH>
<TH noWrap align=middle width="10%">单价</TH>
<TH noWrap align=middle width="10%">数量</TH>
<TH noWrap align=middle width="20%">备注</TH>
<TH noWrap align=middle width="15%">操作</TH>
</TR>
<%
while(rs.next())
{
String deal_no=rs.getString(2);
String deal_date=rs.getString(3);
String product=rs.getString(4);
String price=rs.getString(5);
String amount=rs.getString(6);
String remark=rs.getString(7);
%>
<TR>
<td class=row1 align="center"><%=customer_id%> </td>
<TD class=row1 align=middle><%=deal_no%></TD>
<TD class=row2 align=middle><%=deal_date%></TD>
<TD class=row1 title="" align="center"><%=product%></TD>
<TD class=row1 align="center"><%=price%> <STRONG></STRONG></SPAN></TD>
<TD class=row1 title="" align="center"><%=amount%></TD>
<TD class=row1 title="" align="center"><%=remark%></TD>
<TD class=row2 align=middle><a href="delete_deal.jsp?c_id=<%=customer_id%>&&deal_no=<%=deal_no%>" >删除</a> <a href="modify_deal.jsp?c_id=<%=customer_id%>&&deal_no=<%=deal_no%>&&customer_name=<%=customer_name%>" >修改</a></TD>
</TR>
<%
}
%>
</tbody>
</table>
<%
rs.close();
stmt.close();
conn.close();
%>
<TABLE cellSpacing=0 cellPadding=5 width="100%">
<TBODY>
<TR>
<TD align=right width="50%"> </TD></TR></TBODY></TABLE>
<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>
<br>
<br>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -