usernm_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.name.value.length>6)
   {sign="0"
    alert("用户名要在6个字符内!")
   }
if(form1.name.value.length==0)
   {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="usernm_amend.jsp">



  <table width="40%" border="1" align="center" bgcolor="#CCCCFF">
    
    <tr> 
      <td><div align="center">用户名 
          <input name="name" type="text" size="10" value=<%=r.getString(1)%>>
        </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("数据库连接失败！");}
%>