数据库问题?

CMIC CMIC 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
错误提示:[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。
...全文

相关推荐

评论 2
收藏 已收藏
分享
返回顶部
CMIC
Java EE 67,535 成员 225,843 内容