We’ve found 95 results

netnr / pd-case-conversion.vbs vb
2021-01-11 21:24
PowerDesigner 表结构和字段大小写转换
Option Explicit  
ValidationMode = True  
InteractiveMode = im_Batch  
Dim mdl ' 当前模型  
' 获取当前模型  
Set mdl = ActiveModel  
If (mdl Is Nothing) Then  
   MsgBox "没有打开一个模型" 
ElseIf Not mdl.IsKindOf(PdPDM.cls_Model) Then  
   MsgBox "当前模型不是一个PDM" 
netnr / crontab.sh shell
2021-01-06 10:04
Linux 定时任务 crontab
crontab -l # 列表
crontab -e # 编辑
vi /etc/crontab # 编辑

crontab -h # 帮助
netnr / vscode-remote-ssh-no-login.sh shell
2020-12-17 06:20
vscode remote 免密码登录
# 客户端,cmd运行改命令,密码设为空可直接按Enter回车
ssh-keygen -t rsa -b 4096

# Enter file in which to save the key (/c/Users/Administrator/.ssh/id_rsa):
# Enter passphrase (empty for no passphrase):
# Enter same passphrase again:
# Your identification has been saved in /c/Users/Administrator/.ssh/id_rsa
# Your public key has been saved in /c/Users/Administrator/.ssh/id_rsa.pub

# 服务器端配置公钥,拷贝客户端公钥 id_rsa.pub 内容写入服务器
netnr / profile.sh shell
2020-10-28 15:38
环境变量
# 全局变量
vi /etc/profile # 编辑
PATH=$PATH:/package/app/node/bin
export PATH USER LOGNAME MAIL HOSTNAME HISTSIZE HISTCONTROL # 在该行前面加
source /etc/profile # 生效

# 局部变量
vi ~/.bash_profile # 编辑
alias nodejs=/package/app/node/bin
source ~/.bash_profile # 生效
netnr / win-install-mysql.md markdown
2020-10-21 17:42
Windows系统安装 MySQL
- 下载地址:https://dev.mysql.com/downloads/mysql
- 解压包,放置一个目录下(不含中文或空格的路径)
- 在 **bin** 同级目录创建 **my.ini** 文件和 **data** 文件夹
- my.ini 文件内容
```
[mysqld]
# 设置3306端口
port=3306
# 设置mysql的安装目录
basedir=E:\\mysql-8.0.22-winx64
netnr / oracle_expdp_impdp.sh shell
2020-10-14 09:56
Oracle数据库导入导出
# 按用户导出
expdp $USER/$PWD SCHEMAS=$USER DUMPFILE=$DBNAME.dmp LOGFILE=$DBNAME.log DIRECTORY=DATA_PUMP_DIR
# 按表名导出
expdp $USER/$PWD TABLES=($TABLE1,$TABLE2) DUMPFILE=$DBNAME.dmp LOGFILE=$DBNAME.log DIRECTORY=DATA_PUMP_DIR
# 按用户导入(表覆盖)
impdp $USER/$PWD SCHEMAS=$USER DUMPFILE=$DBNAME.dmp LOGFILE=$DBNAME.log DIRECTORY=DATA_PUMP_DIR TABLE_EXISTS_ACTION=REPLACE
# 按用户导入(转换空间)
impdp $USER/$PWD SCHEMAS=$USER TRANSFORM=segment_attributes:n DUMPFILE=$DBNAME.dmp LOGFILE=$DBNAME.log DIRECTORY=DATA_PUMP_DIR TABLE_EXISTS_ACTION=REPLACE

# 导入时包权限设置
netnr / netsh-http.bat bat
2020-09-18 14:13
netsh命令监听IP(可实现IIS、nginx共用80端口)
:: 显示监听的IP列表
netsh http show iplisten

:: 添加监听IP
netsh http add iplisten ipaddress=127.0.0.1

:: 删除监听IP
netsh http delete iplisten 127.0.0.1
netnr / aspnet_regiis.bat bat
2020-09-18 14:07
Framework注册IIS
@echo off
title .NET Framework Register IIS
color 5f

echo.---------- .NET Framework v2 Register IIS
echo.

%windir%\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i
%windir%\Microsoft.NET\Framework64\v2.0.50727\aspnet_regiis.exe -i
netnr / install-iis.bat bat
2020-09-18 14:05
一键安装IIS
@echo off
title Install IIS
color 5f

echo.---------- Install IIS about 3-5 Minutes
echo.

dism /Online /Enable-Feature /FeatureName:IIS-ApplicationDevelopment	/FeatureName:IIS-ASP	/FeatureName:IIS-ASPNET    /FeatureName:IIS-BasicAuthentication    /FeatureName:IIS-CGI    /FeatureName:IIS-ClientCertificateMappingAuthentication    /FeatureName:IIS-CommonHttpFeatures    /FeatureName:IIS-CustomLogging    /FeatureName:IIS-DefaultDocument    /FeatureName:IIS-DigestAuthentication   /FeatureName:IIS-DirectoryBrowsing   /FeatureName:IIS-FTPExtensibility   /FeatureName:IIS-FTPServer   /FeatureName:IIS-FTPSvc   /FeatureName:IIS-HealthAndDiagnostics   /FeatureName:IIS-HostableWebCore   /FeatureName:IIS-HttpCompressionDynamic   /FeatureName:IIS-HttpCompressionStatic   /FeatureName:IIS-HttpErrors   /FeatureName:IIS-HttpLogging   /FeatureName:IIS-HttpRedirect   /FeatureName:IIS-HttpTracing   /FeatureName:IIS-IIS6ManagementCompatibility   /FeatureName:IIS-IISCertificateMappingAuthentication   /FeatureName:IIS-IPSecurity   /FeatureName:IIS-ISAPIExtensions   /FeatureName:IIS-ISAPIFilter   /FeatureName:IIS-LegacyScripts   /FeatureName:IIS-LegacySnapIn   /FeatureName:IIS-LoggingLibraries   /FeatureName:IIS-ManagementConsole   /FeatureName:IIS-ManagementScriptingTools   /FeatureName:IIS-ManagementService   /FeatureName:IIS-Metabase   /FeatureName:IIS-NetFxExtensibility   /FeatureName:IIS-ODBCLogging   /FeatureName:IIS-Performance   /FeatureName:IIS-RequestFiltering   /FeatureName:IIS-RequestMonitor   /FeatureName:IIS-Security   /FeatureName:IIS-ServerSideIncludes   /FeatureName:IIS-StaticContent   /FeatureName:IIS-URLAuthorization   /FeatureName:IIS-WebDAV   /FeatureName:IIS-WebServer   /FeatureName:IIS-WebServerManagementTools   /FeatureName:IIS-WebServerRole   /FeatureName:IIS-WindowsAuthentication   /FeatureName:IIS-WMICompatibility   /FeatureName:WAS-ConfigurationAPI   /FeatureName:WAS-NetFxEnvironment   /FeatureName:WAS-ProcessModel   /FeatureName:WAS-WindowsActivationService
dism /online /enable-feature /featurename:IIS-ISAPIFilter
dism /online /enable-feature /featurename:IIS-ISAPIExtensions
netnr / locale.sh shell
2020-09-07 15:04
CentOS 修改语言环境为中文
locale # 当前语言包

locale -a # 系统拥有语言包(zh_CN.UTF-8是简体中文,如果没有zh_CN.UTF-8,就安装语言包,如果存在可以直接设置)

# CentOS 7
yum install kde-l10n-Chinese # 安装简体中文语言包

# CentOS 8
dnf search langpacks # 搜索语言包
dnf install langpacks-zh_CN.noarch # 安装中文语言
ˆ