userkey_manager.jsp

JSP科技企业信息管理系统源码(MSSQL数据库)

 <%@ page contentType="text/html; charset=gb2312" %>
<%@ page language="java" import="java.sql.*"%>

<script language="javascript">
<!--
function check() {
var i,j,temp,sign;
sign="1"

if(form1.user_key.value.length==0)
{sign="0"
    alert("密码不能为空!")
}
if(form1.user_key.value.length>6)
   {sign="0"
    alert("密码是六位!")
   }
if(form1.user_key.value!=form1.user_key2.value)
   {sign="0"
    alert("确认密码错误!")
   }

if(sign==1)
{
  form1.submit();
}
}

//-->
</script>

<style TYPE="text/css">
<!--
body {font-size:10pt;color:#415161}
td {font-size:10pt;color:#415161}
th {font-size:10pt;color:#415161}
</style>


<jsp:useBean id="j" scope="application" class="jdbc.jdbc"/>

<%
String user_name=(String)session.getValue("username");
String enterprise_name=(String)session.getValue("enterprise_name");
try{
Connection con=j.getConnection();

Statement statement=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from user_info where user_name='"+user_name+"'";
ResultSet r=statement.executeQuery(sql);

while(r.next())
{
%>

 <form name="form1" method="post" action="userkey_amend.jsp">



  <table width="40%" border="1" align="center" bgcolor="#CCCCFF">
    <tr> 
      <td><div align="center">用户名<%=r.getString(1)%>
        </div></td>
    </tr>
    <tr> 
      <td><div align="center">密码 
          <input name="user_key" type="password" size="6">
        </div></td>
    </tr>
    <tr> 
      <td><div align="center">确认密码 
          <input name="user_key2" type="password" size="6">
        </div></td>
    </tr>
    <tr>
      <td><div align="center">
          <input type="button" name="Submit" value="修改提交" onClick="check()">
        </div></td>
    </tr>
  </table>
</form>
<%
}
}catch(SQLException ee){out.print("数据库连接失败！");}
%>