usernm_amend.jsp

JSP.net环境下开发的科技企业信息管理系统 适用于科研开发单位

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

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

<%
String old_user_name=(String)session.getValue("username");
String user_name=new String(request.getParameter("name").getBytes("ISO8859_1"), "GBK");

int count=0;

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())
{count++;}

if(count!=0)
{
out.print("对不起，该用户名已经存在！");
}
else
{
String upsql="update user_info set user_name='"+user_name+"' where user_name='"+old_user_name+"'";

statement.executeUpdate(upsql);

session.putValue("username",user_name);
}

j.releaseConnection(con);



}


catch(SQLException ee){out.print("数据库连接失败！");}

out.print("用户名修改成功！");
%>