public class myerrorcontext
{
public static class myerror
{
int errno;
string szerrordesc;
public myerror(int errno, string errordesc)
{
this.errno = errno;
this.szerrordesc = errordesc;
}
public int geterrorno()
{
return errno;
}
public string geterrordesc()
{
return szerrordesc;
}
}
public static final int db_er_cant_create_table = 1005; //创建表失败
public static final int db_er_cant_create_db = 1006; //创建数据库失败
public static final int db_er_db_create_exists = 1007; //数据库已存在，创建数据库失败
public static final int db_er_db_drop_exists = 1008; //数据库不存在，删除数据库失败
public static final int db_er_db_drop_delete = 1009; //不能删除数据库文件导致删除数据库失败
public static final int db_er_db_drop_rmdir = 1010; //不能删除数据目录导致删除数据库失败
public static final int db_er_cant_delete_file = 1011; //删除数据库文件失败
public static final int db_er_cant_find_system_rec = 1012; //不能读取系统表中的记录
public static final int db_er_checkread = 1020; //记录已被其他用户修改
public static final int db_er_disk_full = 1021; //硬盘剩余空间不足，请加大硬盘可用空间
public static final int db_er_dup_key = 1022; //关键字重复，更改记录失败
public static final int db_er_error_on_close = 1023; //关闭时发生错误
public static final int db_er_error_on_read = 1024; //读文件错误
public static final int db_er_error_on_rename = 1025; //更改名字时发生错误
public static final int db_er_error_on_write = 1026; //写文件错误
public static final int db_er_key_not_found = 1032; //记录不存在
public static final int db_er_open_as_readonly = 1036; //数据表是只读的，不能对它进行修改
public static final int db_er_outofmemory = 1037; //系统内存不足，请重启数据库或重启服务器
public static final int db_er_out_of_sortmemory = 1038; //用于排序的内存不足，请增大排序缓冲区
public static final int db_er_con_count_error = 1040; //已到达数据库的最大连接数，请加大数据库可用连接数
public static final int db_er_out_of_resources = 1041; //系统内存不足
public static final int db_er_bad_host_error = 1042; //无效的主机名
public static final int db_er_handshake_error = 1043; //无效连接
public static final int db_er_dbaccess_denied_error = 1044; //当前用户没有访问数据库的权限
public static final int db_er_access_denied_error = 1045; //不能连接数据库，用户名或密码错误
public static final int db_er_bad_null_error = 1048; //字段不能为空
public static final int db_er_bad_db_error = 1049; //数据库不存在
public static final int db_er_table_exists_error = 1050; //数据表已存在
public static final int db_er_bad_table_error = 1051; //数据表不存在
public static final int db_er_bad_field_error = 1054; //字段不存在
public static final int db_er_empty_query = 1065; //无效的sql语句，sql语句为空
public static final int db_er_ipsock_error = 1081; //不能建立socket连接
public static final int db_er_record_file_full = 1114; //数据表已满，不能容纳任何记录
public static final int db_er_too_many_tables = 1116; //打开的数据表太多
public static final int db_er_host_is_blocked = 1129; //数据库出现异常，请重启数据库
public static final int db_er_host_not_privileged = 1130; //连接数据库失败，没有连接数据库的权限
public static final int db_er_password_no_match = 1133; //数据库用户不存在
public static final int db_er_nonexisting_grant = 1141; //当前用户无权访问数据库
public static final int db_er_tableaccess_denied_error = 1142; //当前用户无权访问数据表
public static final int db_er_columnaccess_denied_error = 1143; //当前用户无权访问数据表中的字段
public static final int db_er_no_such_table = 1146; //数据表不存在
public static final int db_er_nonexisting_table_grant = 1147; //未定义用户对数据表的访问权限
public static final int db_er_syntax_error = 1149; //sql语句语法错误
public static final int db_er_net_read_error = 1158; //网络错误，出现读错误，请检查网络连接状况
public static final int db_er_net_read_interrupted = 1159; //网络错误，读超时，请检查网络连接状况
public static final int db_er_net_error_on_write = 1160; //网络错误，出现写错误，请检查网络连接状况
public static final int db_er_net_write_interrupted = 1161; //网络错误，写超时，请检查网络连接状况
public static final int db_er_dup_entry = 1062; //字段值重复，入库失败
public static final int db_er_dup_unique = 1169; //字段值重复，更新记录失败
public static final int db_er_check_no_such_table = 1177; //打开数据表失败
public static final int db_er_error_during_commit = 1180; //提交事务失败
public static final int db_er_error_during_rollback = 1181; //回滚事务失败
public static final int db_er_too_many_user_connections = 1203; //当前用户和数据库建立的连接已到达数据库的最大连接数，请增大可用的数据库连接数或重启数据库
public static final int db_er_lock_wait_timeout = 1205; //加锁超时
public static final int db_er_no_permission_to_create_user = 1211; //当前用户没有创建用户的权限
public static final int db_er_no_referenced_row = 1216; //外键约束检查失败，更新子表记录失败
public static final int db_er_row_is_referenced = 1217; //外键约束检查失败，删除或修改主表记录失败
public static final int db_er_user_limit_reached = 1226; //当前用户使用的资源已超过所允许的资源，请重启数据库或重启服务器
public static final int db_er_specific_access_denied_error = 1227; //权限不足，您无权进行此操作
public static final int db_er_not_supported_yet = 1235; //mysql版本过低，不具有本功能
private static final myerror[] errormap =
{
new myerror(db_er_cant_create_table ,"创建表失败"),
new myerror(db_er_cant_create_db ,"创建数据库失败"),
new myerror(db_er_db_create_exists ,"数据库已存在，创建数据库失败"),
new myerror(db_er_db_drop_exists ,"数据库不存在，删除数据库失败"),
new myerror(db_er_db_drop_delete ,"不能删除数据库文件导致删除数据库失败"),
new myerror(db_er_db_drop_rmdir ,"不能删除数据目录导致删除数据库失败"),
new myerror(db_er_cant_delete_file ,"删除数据库文件失败"),
new myerror(db_er_cant_find_system_rec ,"不能读取系统表中的记录"),
new myerror(db_er_checkread ,"记录已被其他用户修改"),
new myerror(db_er_disk_full ,"硬盘剩余空间不足，请加大硬盘可用空间"),
new myerror(db_er_dup_key ,"关键字重复，更改记录失败"),
new myerror(db_er_error_on_close ,"关闭时发生错误"),
new myerror(db_er_error_on_read ,"读文件错误"),
new myerror(db_er_error_on_rename ,"更改名字时发生错误"),
new myerror(db_er_error_on_write ,"写文件错误"),
new myerror(db_er_key_not_found ,"记录不存在"),
new myerror(db_er_open_as_readonly ,"数据表是只读的，不能对它进行修改"),
new myerror(db_er_outofmemory ,"系统内存不足，请重启数据库或重启服务器"),
new myerror(db_er_out_of_sortmemory ,"用于排序的内存不足，请增大排序缓冲区"),
new myerror(db_er_con_count_error ,"已到达数据库的最大连接数，请加大数据库可用连接数"),
new myerror(db_er_out_of_resources ,"系统内存不足"),
new myerror(db_er_bad_host_error ,"无效的主机名"),
new myerror(db_er_handshake_error ,"无效连接"),
new myerror(db_er_dbaccess_denied_error ,"当前用户没有访问数据库的权限"),
new myerror(db_er_access_denied_error ,"不能连接数据库，用户名或密码错误"),
new myerror(db_er_bad_null_error ,"字段不能为空"),
new myerror(db_er_bad_db_error ,"数据库不存在"),
new myerror(db_er_table_exists_error ,"数据表已存在"),
new myerror(db_er_bad_table_error ,"数据表不存在"),
new myerror(db_er_bad_field_error ,"字段不存在"),
new myerror(db_er_empty_query ,"无效的sql语句，sql语句为空"),
new myerror(db_er_ipsock_error ,"不能建立socket连接"),
new myerror(db_er_record_file_full ,"数据表已满，不能容纳任何记录"),
new myerror(db_er_too_many_tables ,"打开的数据表太多"),
new myerror(db_er_host_is_blocked ,"数据库出现异常，请重启数据库"),
new myerror(db_er_host_not_privileged ,"连接数据库失败，没有连接数据库的权限"),
new myerror(db_er_password_no_match ,"数据库用户不存在"),
new myerror(db_er_nonexisting_grant ,"当前用户无权访问数据库"),
new myerror(db_er_tableaccess_denied_error ,"当前用户无权访问数据表"),
new myerror(db_er_columnaccess_denied_error ,"当前用户无权访问数据表中的字段"),
new myerror(db_er_no_such_table ,"数据表不存在"),
new myerror(db_er_nonexisting_table_grant ,"未定义用户对数据表的访问权限"),
new myerror(db_er_syntax_error ,"sql语句语法错误"),
new myerror(db_er_net_read_error ,"网络错误，出现读错误，请检查网络连接状况"),
new myerror(db_er_net_read_interrupted ,"网络错误，读超时，请检查网络连接状况"),
new myerror(db_er_net_error_on_write ,"网络错误，出现写错误，请检查网络连接状况"),
new myerror(db_er_net_write_interrupted ,"网络错误，写超时，请检查网络连接状况"),
new myerror(db_er_dup_entry ,"字段值重复，入库失败"),
new myerror(db_er_dup_unique ,"字段值重复，更新记录失败"),
new myerror(db_er_check_no_such_table ,"打开数据表失败"),
new myerror(db_er_error_during_commit ,"提交事务失败"),
new myerror(db_er_error_during_rollback ,"回滚事务失败"),
new myerror(db_er_too_many_user_connections ,"当前用户和数据库建立的连接已到达数据库的最大连接数，请增大可用的数据库连接数或重启数据库"),
new myerror(db_er_lock_wait_timeout ,"加锁超时"),
new myerror(db_er_no_permission_to_create_user ,"当前用户没有创建用户的权限"),
new myerror(db_er_no_referenced_row ,"外键约束检查失败，更新子表记录失败"),
new myerror(db_er_row_is_referenced ,"外键约束检查失败，删除或修改主表记录失败"),
new myerror(db_er_user_limit_reached ,"当前用户使用的资源已超过所允许的资源，请重启数据库或重启服务器"),
new myerror(db_er_specific_access_denied_error ,"权限不足，您无权进行此操作"),
new myerror(db_er_not_supported_yet ,"mysql版本过低，不具有本功能"),
};
public static string geterrorinfo(int errno)
{
for(int i=0; i<errormap.length; i++)
{
if(errno == errormap[i].geterrorno())
{
return errormap[i].geterrordesc();
}
}
return "";
}
public string  geterrormessage(int errorcode)
{
  string error=null;
for(int i=0; i<errormap.length; i++)
{
  if(errormap[i].geterrorno()==errorcode)
  {
    error = errormap[i].geterrorno() + "：" + errormap[i].geterrordesc();
    break;
  }
}
return error;
}
}