?? userqurylog.jsp
字號:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>無標題文檔</title>
</head>
<body>
<%
response.setCharacterEncoding("gb2312");
String target_id=request.getParameter("target_id");
String custom_id=request.getParameter("custom_id");
String ukinds;
if(custom_id==null||target_id==null)out.print("<script>alert('target_id can not be non,please fill it');window.location.href='userqury.jsp'</script>");
else{
try{
String driver= "sun.jdbc.odbc.JdbcOdbcDriver";
Class.forName(driver).newInstance();
String ConURL = "jdbc:odbc:login";
Connection con = null;
con = DriverManager.getConnection(ConURL,"sa","453558337");
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs = null;
String sqlquerystring="SELECT * FROM customtable ";
sqlquerystring+=" "+"WHERE custom_id LIKE"+""+"'"+custom_id+"'";
rs = stmt.executeQuery(sqlquerystring);
if((rs!=null)){
if(rs.getString("custom_property").equals(1)) ukinds="政府招標";
else if(rs.getString("custom_property").equals(2)) ukinds="重要客戶";
else if(rs.getString("custom_property").equals(3)) ukinds="其他客戶";
else ukinds="其他";
out.print("<script>alert('good');</script>");
%>
<jsp:include flush="true" page="header.jsp" />
<table align="center" width="40%">
<tr align="center">
<td colspan="2" align="center"> <font size="+2" >查詢結果 <br></td>
</tr>
<tr>
<td>
<div align="center">客 戶 號:</div></td><td><label><%=rs.getString("custom_id") %></label></td>
</tr>
<tr>
<td>
<div align="center">標 的 號:</div></td><td><label><%=rs.getString("target_id") %></label></td>
<tr>
<td>
<div align="center">聯系人號:</div></td><td><label><%=rs.getString("person_id") %></label></td>
</tr>
<tr>
<td>
<div align="center">客戶性質:</div></td>
<td><label><%=ukinds %></label>
</td>
</tr>
<tr>
<td>
<div align="center">客戶名稱:</div></td><td><label><%=rs.getString("custom_name") %></label></td>
</tr>
<tr>
<td>
<div align="center">客戶地址:</div></td><td><label><%=rs.getString("custom_address") %></label></td>
</tr>
<tr><td><div align="center">初登日期</div></td>
<td><label><%=rs.getString("year1") %></label>-<label><%=rs.getString("month1") %>-</label><label><%=rs.getString("day1") %></label></td>
<tr>
<td>
<div align="center">電話號碼:</div></td><td><label><%=rs.getString("phone") %></label>—<label><%=rs.getString("number") %></label>
</td>
</tr>
<tr><td><div align="center">移動電話:</div></td><td><label><%=rs.getString("mobile_phone") %></label></td></tr>
<tr>
<td>
<div align="center">傳真號碼:</div></td><td><label><%=rs.getString("fax") %></label>—<label><%=rs.getString("number") %></label>
</td>
</tr>
<tr><td><div align="center">登記人:</div></td><td><label><%=rs.getString("booker") %></label></td></tr>
<tr>
<td><div align="center">法人代表:</div></td><td><label><%=rs.getString("leader") %></label></td>
</tr>
<tr>
<td>
<div align="center">法人組織機構代碼:</div></td><td><label><%=rs.getString("custom_remark") %></label></td>
</tr>
<tr><td></td><td><a href="usermodify.jsp?target_id=<%=rs.getString("target_id") %>">修改</a> <a href="userdelete.jsp?target_id=<%=rs.getString("target_id") %>">刪除</a></td></tr>
</table>
<%
out.print("<script>alert('操作成功!');</script>");
}
else out.print("<script>alert('custom_id is not exist,please fill in correct custom_id');window.location.href='userqury.jsp'</script>");
rs.close();
stmt.close();
con.close();
}catch(SQLException ex) {
out.println("SQLException caught");
out.println("<br>");
while(ex!=null){
out.println("Message:"+ex.getMessage());
out.println("<br>");
out.println("SQLState:"+ex.getSQLState());
out.println("<br>");
out.println("ErrorCode:"+ex.getErrorCode());
out.println("<br>");
ex=ex.getNextException();
}
}
}
%>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -