📄 systemset.jsp
字号:
<%--
模块名称：
模块功能：
版 本：V1.0
著 作 人：谢永刚(ui) SIMM(java)
著作日期：2001-12-28
该模块所需的文件：
使用说明：
主要技术说明：
参考文献：法律事务设计书
修改历史：= = = = = = = = = = = = = = = = = = = = = = = = = =
修改日期：
修 改 人：
修改理由：
修改出处：
= = = = = = = = = = = = = = = = = = = = = = = = = =
--%>
<%@ page contentType= "text/html; charset=gb2312" %>
<%@ page language="java" import="java.sql.*" %>
<%@ page import="system.*" %>
<jsp:useBean id="db" class="dbconnection.DbConnection" scope="page" />
<%
ResultSet rs = null;
String sql = "",
settingName = "",
deptName = "", //单位名称
telephone = "",
email = "";
int num = 0;
String str = request.getParameter("btnSave");
if(str != null)
{
deptName = request.getParameter("txtDeptName");
deptName = new String(deptName.getBytes("ISO8859_1"));
telephone = request.getParameter("txtTelephone");
telephone = new String(telephone.getBytes("ISO8859_1"));
email = request.getParameter("txtEmail");
email = new String(email.getBytes("ISO8859_1"));
sql = "update t_sysset set setting_value='" + deptName;
sql = sql + "' where setting_name='deptname' ";
num = db.executeUpdate(sql);
sql = " update t_sysset set setting_value='" + telephone;
sql = sql + "' where setting_name='telephone' ";
num = db.executeUpdate(sql);
sql = " update t_sysset set setting_value='" + email;
sql = sql + "' where setting_name='email' ";
num = db.executeUpdate(sql);
if(num <= 0) { %>
<script language="javascript>
alert("系统参数修改失败！");
</script>
<%}
}else
{
sql = "select setting_name,setting_value from t_sysset";
rs = db.executeQuery("select setting_name,setting_value from t_sysset");
while(rs.next()){
settingName = rs.getString("setting_name");
if(settingName.equals("deptname"))
deptName = rs.getString("setting_value");
else if(settingName.equals("telephone"))
telephone = rs.getString("setting_value");
else if(settingName.equals("email"))
email = rs.getString("setting_value");
}
if(deptName == null) deptName = "";
if(telephone == null) telephone = "";
if(email == null) email = "";
}
%>
<html>
<head>
<%@ include file="../inc/config.jsp" %>
<title>系统参数设定</title>
</head>
<script language="JavaScript">
function checkForm() {
if (document.thisForm.txtEmail.value != "") {
var pattern = /^([a-zA-Z0-9_-])+@([a-zA-Z0-9_-])+/;
flag = pattern.test(document.thisForm.txtEmail.value);
if (!flag) {
alert("email输入非法！");
document.thisForm.txtEmail.focus();
return false;
}
}
return true;
}
</script>
<body class=page>
<table width="98%" align="center" cellspacing="0" border="0" cellpadding="0">
<tr>
<td> </td>
<td align="center" width="108" height="30" background="../images/title_bg.gif">
<script language=JavaScript>
document.write("<span class=\"title\">"+document.title+"</span>");
</script>
</td>
</tr>
</table>
<table width="98%" background="../images/line.gif" border="0" cellspacing="0" cellpadding="0" height="12" align="center">
<tr>
<td> </td>
</tr>
</table>
<form name="thisForm" method="post" action="SystemSet.jsp">
<table width="70%" cellspacing="1" cellpadding="10" height="25" align="center" border="0" class="table_bg">
<tr>
<td class="title_bg" width="11%" align="right">单位名称：</td>
<td class="tr_bg1" width="41%" >
<input type="text" name="txtDeptName" size="50" class="input" maxlength="70" value="<%=deptName%>">
</td>
</tr>
<tr>
<td class="title_bg" width="11%" align="right">联系电话：</td>
<td class="tr_bg1" width="41%" >
<input type="text" name="txtTelephone" size="50" class="input" maxlength="70" value="<%=telephone%>">
</td>
</tr>
<tr >
<td class="title_bg" width="11%" align="right"> 电子邮箱：</td>
<td class="tr_bg1" width="41%">
<input type="text" name="txtEmail" size="50" class="input" maxlength="70" value="<%=email%>">
</td>
</tr>
</table>
<div align="center">
<input type="submit" value="保 存" name="btnSave" class="button" onClick="return checkForm()">
<input type="reset" value="取 消" name="cancel" class="button">
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -