<%@page contentType="text/html;charset=GBK"%>
<%@page import="java.util.*"%>
<%@page import="java.sql.*" %><html>
<head>
<title>用户升级</title>
</head>
<body>
<% String kickname = request.getParameter("kickname");String Name =(String) session.getValue("username");//out.println(Name);
String sDBDriver ="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String sConnStr = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=text";//text表示数据库名称;
Connection Con = null;
Statement Stmt = null;
try /*加载驱动程序*/
{
Class.forName(sDBDriver).newInstance();
}
catch(java.lang.ClassNotFoundException e)
{
out.print("Connect to Database error: " + e.getMessage());
}
try /*建立连接*/
{
Con = DriverManager.getConnection(sConnStr,"sa","");
}
catch(SQLException e)
{
out.print(e.toString());
}
Stmt = Con.createStatement(); /*创建JDBC声明*/
ResultSet rs=null;
String sqlstring = "select * from chatuser where USERNAME = '" + Name + "'";
out.println(sqlstring);
rs = Stmt.executeQuery(sqlstring); if(rs.next())
{
int exp= rs.getInt("EXPERIENCE");
if (exp>1000)
{
exp=exp - 50;
Stmt.executeUpdate("update chatuser set EXPERIENCE= '+exp' where USERNAME = '"+ Name +"'");
rs = Stmt.executeQuery("sqlstring");
// Stmt.executeQuery(sqlstring);
synchronized (application) {
Vector UserName=null;
UserName= (Vector)application.getAttribute("UserName");
UserName.remove(kickname);
}
}
else
{
out.println("no");
}
}
%>
</body>
</html>
现在传过来的是tam[会员]或tam[非会员]
我现在要去掉[会员]或[非会员]
要怎么才能实现啊~
麻烦大虾帮忙解决啊/`写详细点啊`我新手`谢谢
<%@page import="java.util.*"%>
<%@page import="java.sql.*" %><html>
<head>
<title>用户升级</title>
</head>
<body>
<% String kickname = request.getParameter("kickname");String Name =(String) session.getValue("username");//out.println(Name);
String sDBDriver ="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String sConnStr = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=text";//text表示数据库名称;
Connection Con = null;
Statement Stmt = null;
try /*加载驱动程序*/
{
Class.forName(sDBDriver).newInstance();
}
catch(java.lang.ClassNotFoundException e)
{
out.print("Connect to Database error: " + e.getMessage());
}
try /*建立连接*/
{
Con = DriverManager.getConnection(sConnStr,"sa","");
}
catch(SQLException e)
{
out.print(e.toString());
}
Stmt = Con.createStatement(); /*创建JDBC声明*/
ResultSet rs=null;
String sqlstring = "select * from chatuser where USERNAME = '" + Name + "'";
out.println(sqlstring);
rs = Stmt.executeQuery(sqlstring); if(rs.next())
{
int exp= rs.getInt("EXPERIENCE");
if (exp>1000)
{
exp=exp - 50;
Stmt.executeUpdate("update chatuser set EXPERIENCE= '+exp' where USERNAME = '"+ Name +"'");
rs = Stmt.executeQuery("sqlstring");
// Stmt.executeQuery(sqlstring);
synchronized (application) {
Vector UserName=null;
UserName= (Vector)application.getAttribute("UserName");
UserName.remove(kickname);
}
}
else
{
out.println("no");
}
}
%>
</body>
</html>
现在传过来的是tam[会员]或tam[非会员]
我现在要去掉[会员]或[非会员]
要怎么才能实现啊~
麻烦大虾帮忙解决啊/`写详细点啊`我新手`谢谢
这两个
就拿kickname来比啊~
麻烦了
这样就成了tam了
String Name =(String) session.getValue("username");
if (kickname.indexOf("[会员]")>-1)
kickname=kcikname.replace("[会员]","");
else if(kickname.indexOf("[非会员]")>-1)
kickname=kcikname.replace("[非会员]","");
if (Name.indexOf("[会员]")>-1)
Name=Name.replace("[会员]","");
else if(Name.indexOf("[非会员]")>-1)
Name=Name.replace("[非会员]","");
int index = splice.lastIndexOf("]");
String newStr = splice.substring(index+1);