📄 db.pm
字号:
use DBI;#-----------------------------------------------------------------sub MysqlConnect($$$$) { my ($host, $port, $user, $pass) = @_; my $dsn = "DBI:mysql:host=$host;port=$port"; return DBI->connect($dsn, $user, $pass, { PrintError => 0 });}#-----------------------------------------------------------------sub MysqlQuery($$) { my ($dbh, $query) = @_; LogDebug("MYSQL QUERY: $query"); my $sth = $dbh->prepare($query); my $res = $sth->execute; return $res unless($res); my $row = $sth->fetchrow_hashref; $sth->finish; return $row;}#-----------------------------------------------------------------sub ExecuteQuery($$) { my ($dbh, $query) = @_; LogDebug("MYSQL EXEC: $query"); my $sth = $dbh->prepare($query); return $sth->execute;}1;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -