计数器!”又错了“ 高分请解
<%@ page contentType="text/html;charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>文字计数器</title>
</head>
<body>
<%
String DBName = "test";
String Table = "counter";
String driver= "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url = "jdbc:microsoft:sqlserver://localhost:1433"+DBName;
String userID="sa";
String passwd="";
int OldCNT;
int UserCNT;
try
{
Class.forName(driver).newInstance();
}
catch(Exception e)
{
out.println("无法栽入"+driver+"驱动程序");
e.printStackTrace();
}
try
{
Connection con = DriverManager.getConnection(url,userID,passwd);
Statement stmt = con.createStatement();
String query = "SELECT * FROM counter;";
ResultSet QRes = stmt.executeQuery(query);
while(QRes.next())
{
OldCNT = QRes.getInt("times");
UserCNT = OldCNT+1;
out.println("您是第"+UserCNT+"位");
QRes.close();
query = "UPDATE counter SET times ="+UserCNT+" WHERE times ="+OldCNT+";";
stmt.executeQuery(query);
}
con.close();
}
catch(SQLException e)
{
e.printStackTrace();
out.print("又错了!");
}
%>
</body>
</html>