数据库问题？

CMIC 2003-12-10 10:49:00

错误提示：[Microsoft][SQLServer JDBC Driver]The specified SQL type is not supported by this driver.

代码：
package oa.DataAccess;
import java.sql.*;
public class User {
private Connection _Cn=null;
private ResultSet _Users=null;
private String _UserID="";
private String _LoginName="";
private String _UserName="";
private String _AllName="";
private String _PassWord="60FD7DD82EA95B91";//默认为空
private byte _Verify=3;//默认值3
private String _State="1";
private String _Note="";//备注
private java.util.Date _UpDateTime;
private String _UpUserID="";
private String _ErrMsg="";
public User() {
_Cn=new jdbcCn().getCn();
}

public ResultSet getUsers()
{
try
{
Statement mStmt=_Cn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
_Users=mStmt.executeQuery(" select * from PubSystemUser ");
}
catch(Exception ex)
{
ex.getStackTrace();
System.out.print("User is Nothing!!!");
}
return _Users;
}
public void Close()
{
try
{
if(_Users!=null)
{
_Users.close();
}
if (_Cn.isClosed() == false) {
_Cn.close();
}
}
catch(Exception ex)
{
ex.getStackTrace();
System.out.print("Close is Fail!!!");
}
}
//设置登录ID
public void setLoginName(String value)
{
_LoginName=value;
}
//设置用户真实姓名
public void setAllName(String value)
{
_AllName=value;
}
//设置备注
public void setNote(String value)
{
_Note=value;
}
public void setUpUserID(String value)
{
_UpUserID=value;
}
private boolean getUserID()
{
try
{
String mSql = "select max(UserID) " +
" from PubSystemUser ";
Statement mStmt = _Cn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
ResultSet mRs = mStmt.executeQuery(mSql);
mRs.last();
if(mRs.getRow()==0)
{
_UserID="001";
}
else
{
int mID=Integer.parseInt(mRs.getString("UserID"))+1;
}
return true;
}
catch(Exception ex)
{
ex.getStackTrace();
System.out.print("Insert is Fail!!!");
return false;
}
}
public boolean Insert()
{
try
{
if(getUserID())
{
throw new Exception("Get UserID is fail!");
}
String strSql = "INSERT INTO PubSystemUser " +
"(UserID, LoginName, UserName, AllName, PassWord, Verify, State, Note, "+
"UpDateTime, UpDateUserID)"+
"VALUES (?,?,?,?,?,?,?,?,?,)";
PreparedStatement pstmt = _Cn.prepareStatement(strSql);
if(_UpUserID.trim()=="")
{
_UpUserID=_UserID;
}
pstmt.setString(1,_UserID);
pstmt.setString(2,_LoginName);
pstmt.setString(3,_UserName);
pstmt.setString(4,_AllName);
pstmt.setString(5,_PassWord);
pstmt.setByte(6,_Verify);
pstmt.setString(7,_State);
pstmt.setString(8,_Note);
pstmt.setObject(9,_UpDateTime);
pstmt.setString(10,_UpUserID);
pstmt.executeUpdate();
pstmt.close();
_Cn.close();
return true;
}
catch(Exception ex)
{
ex.getStackTrace();
_ErrMsg=ex.getMessage();
System.out.print("Insert is fail!!!");
return false;
}
}
public String GetErrMsg()
{
return _ErrMsg;
}
}
执行Insert()函数出现错误，数据库是SQL 2000,Note类型是Text。

...全文