📄 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 + -