创建表oracle二进制要用Blob类型
create table DOWNLOADIMAGE
(
IMAGE_ID VARCHAR2(50) not null,
IMAGE_TIME DATE,
IMAGE_DATA BLOB
)
create table DOWNLOADIMAGE
(
IMAGE_ID VARCHAR2(50) not null,
IMAGE_TIME DATE,
IMAGE_DATA BLOB
)
oracle、Ado.net访问通用类
public int InsertImage(string uid, DateTime dt, byte[] by)
{
//写进数据库
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into downloadimage(");
strSql.Append("image_id,image_time,image_data)");
strSql.Append(" values (");
strSql.Append(":image_id,:image_time,:image_data)");
OracleParameter[] parameters = {
new OracleParameter(":image_id", OracleType.VarChar,50),
new OracleParameter(":image_time", OracleType.DateTime),
new OracleParameter(":image_data", OracleType.Blob)
};
parameters[0].Value = uid;
parameters[1].Value = dt;
parameters[2].Value = by;
return DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
}
{
//写进数据库
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into downloadimage(");
strSql.Append("image_id,image_time,image_data)");
strSql.Append(" values (");
strSql.Append(":image_id,:image_time,:image_data)");
OracleParameter[] parameters = {
new OracleParameter(":image_id", OracleType.VarChar,50),
new OracleParameter(":image_time", OracleType.DateTime),
new OracleParameter(":image_data", OracleType.Blob)
};
parameters[0].Value = uid;
parameters[1].Value = dt;
parameters[2].Value = by;
return DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
}
添加完相应的函数代码后,从代码视图切换到设计视图,点鼠标右键选择“添加安装程序”
在设计模式下右键-->添加安装程序-->设置serviceProcessInstaller1的Account为LocalSystem,设置serviceInstaller1的StartType为Automatic。
在设计模式下右键-->添加安装程序-->设置serviceProcessInstaller1的Account为LocalSystem,设置serviceInstaller1的StartType为Automatic。
Window注册和卸载服务cmd命令行
移除服务:
cd C:\Windows\Microsoft.NET\Framework\v4.0.30319
InstallUtil.exe /u E:\VsProject\DownloadImage\DownloadService\bin\Release\DownloadService.exe
安装服务:
cd C:\Windows\Microsoft.NET\Framework\v4.0.30319
InstallUtil.exe E:\VsProject\DownloadImage\DownloadService\bin\Release\DownloadService.exe
net start 天气预报服务
移除服务:
cd C:\Windows\Microsoft.NET\Framework\v4.0.30319
InstallUtil.exe /u E:\VsProject\DownloadImage\DownloadService\bin\Release\DownloadService.exe
安装服务:
cd C:\Windows\Microsoft.NET\Framework\v4.0.30319
InstallUtil.exe E:\VsProject\DownloadImage\DownloadService\bin\Release\DownloadService.exe
net start 天气预报服务