📄 customerlist.jsp
字号:
<%@page import ="java.sql.*"%>
<%@page import ="java.util.*"%>
<%@page import ="COM.cloudscape.core.*"%>
<HTML>
<Title>Music On-line</Title>
<BODY>
<TABLE align="left">
<TR>
<TD><H2><IMG src="musicStore.gif"/>Music OnLine (The right tunez at the right place)</H2></TD>
</TR>
</TABLE>
<BR/><BR/><BR/><BR/><BR/><BR/><BR/><BR/><BR/><HR/>
<P>
<FONT size="3">Welcome to Music OnLine's Customer Address Maintenance Application. Please select the customers whose
address you want to edit by clicking on their customer id.
</FONT>
</P>
<HR/>
<H3>Customer Address List:</H3>
<TABLE border="1">
<TBODY>
<TR>
<TD align="center" bgcolor="#C0C0C0"><B>Customer Id</B></TD>
<TD align="center" bgcolor="#C0C0C0"><B>Customer Name and Address</B></TD>
</TR>
<%
/*CALLOUT #1*/
String JDBCURL = "jdbc:cloudscape:C://wrox4370.db";
String JDBCDRIVER = "COM.cloudscape.core.JDBCDriver";
StringBuffer sql = new StringBuffer("");
sql.append("SELECT ");
sql.append(" customers.CustomerId , ");
sql.append(" customers.CustomerFirstName , ");
sql.append(" customers.CustomerLastName , ");
sql.append(" customers.CustomerAddress1 , ");
sql.append(" customers.CustomerAddress2 , ");
sql.append(" customers.CustomerCity , ");
sql.append(" postalcodes.StateProv , ");
sql.append(" postalcodes.postalcode , ");
sql.append(" countries.CountryName ");
sql.append("FROM ");
sql.append(" customers , ");
sql.append(" postalcodes , ");
sql.append(" countries ");
sql.append("WHERE ");
sql.append(" customers.customerpostalcode=postalcodes.postalcode " );
sql.append("AND ");
sql.append(" postalcodes.countryid=countries.countryid ");
/******Step 1 - Making my JDBC Connection to Cloudscape******/
Class.forName(JDBCDRIVER);
Connection conn= DriverManager.getConnection(JDBCURL);
Statement statement = conn.prepareStatement(sql.toString());
/*Executing the results*/
ResultSet rs = statement.executeQuery(sql.toString());
while (rs.next()){
%>
<TR>
<TD align="center">
<a href="customer.jsp?customerid="<%=rs.getString("customerid")%>">
<%=rs.getString("CustomerId")%></a>
</TD>
<TD align="left">
<%=rs.getString("CustomerFirstName")%>
<%=rs.getString("CustomerLastName")%><BR/>
   <%=rs.getString("CustomerAddress1")%><BR/>
<%if (rs.getString("CustomerAddress2")!=null){%>
   <%=rs.getString("CustomerAddress2")%><BR/>
<%}%>
   <%=rs.getString("CustomerCity")%>, 
<%=rs.getString("StateProv")%> 
<%=rs.getString("postalCode")%><BR/>
   <%=rs.getString("CountryName")%>
</TD>
</TR>
<%
}
rs.close();
%>
</TBODY>
</TABLE>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -