.Net 数据库连接定义
发布网友
发布时间：2022-04-08 09:27
我来回答
共4个回答
懂视网
时间：2022-04-08 13:48
opmysqli{
private $host = ‘127.0.0.1‘; //服务器地址
private $name = ‘root‘; //登录账号
private $pwd = ‘111‘; //登录密码
private $dBase = ‘db_blog‘; //数据库名称
private $conn = ‘‘; //数据库链接资源
private $result = ‘‘; //结果集
private $msg = ‘‘; //返回结果
private $fields; //返回字段
private $fieldsNum = 0; //返回字段数
private $rowsNum = 0; //返回结果数
private $filesArray = array(); //返回字段数组
private $rowsArray = array(); //返回结果数组
//初始化类
function __construct($host=‘‘,$name=‘‘,$pwd=‘‘,$dBase=‘‘){
if($host != ‘‘)
$this->host = $host;
if($name != ‘‘)
$this->name = $name;
if($pwd != ‘‘)
$this->pwd = $pwd;
if($dBase != ‘‘)
$this->dBase = $dBase;
$this->init_conn();
}
//链接数据库
function init_conn(){
$this->conn=mysqli_connect($this->host,$this->name,$this->pwd,$this->dBase);
mysqli_query($this->conn,"set names gb2312");
}
//查询结果
function mysqli_query_rst($sql){
if($this->conn == ‘‘){
$this->init_conn();
}
$this->result = @mysqli_query($this->conn,$sql);
}
//取得字段数
function getFieldsNum($sql){
$this->mysqli_query_rst($sql);
$this->fieldsNum = @mysqli_num_fields($this->result);
}
//取得查询结果数
function getRowsNum($sql){
$this->mysqli_query_rst($sql);
$this->rowsNum = @mysqli_num_rows($this->result);
return $this->rowsNum;
}
//取得记录数组（多条记录）
function getRowsArray($sql){
$this->mysqli_query_rst($sql);
while($row = mysqli_fetch_array($this->result,MYSQLI_ASSOC)) {
$this->rowsArray[] = $row;
}
return $this->rowsArray;
}
//更新、删除、添加记录数
function uidRst($sql){
if($this->conn == ‘‘){
$this->init_conn();
}
@mysqli_query($this->conn,$sql);
$this->rowsNum = @mysqli_affected_rows($this->conn);
return $this->rowsNum;
}
//获取对应的字段值
function getFields($sql,$fields){
$this->mysqli_query_rst($sql);
if(mysqli_num_rows($this->result) > 0){
$tmpfld = mysqli_fetch_row($this->result);
$this->fields = $tmpfld[$fields];
}
return $this->fields;
}
//错误信息
function msg_error(){
if(mysqli_errno() != 0) {
$this->msg = mysqli_error();
}
return $this->msg;
}
//释放结果集
function close_rst(){
//mysqli_free_result($this->result);
$this->msg = ‘‘;
$this->fieldsNum = 0;
$this->rowsNum = 0;
$this->filesArray = ‘‘;
$this->rowsArray = ‘‘;
}
//关闭数据库
function close_conn(){
$this->close_rst();
mysqli_close($this->conn);
$this->conn = ‘‘;
}
}
$conne = new opmysqli();
?>
<?php
define(‘PATH‘,$_SERVER[‘DOCUMENT_ROOT‘]); //服务器目录
define(‘ROOT‘,‘/TM/06/‘); //博客目录
define(‘ADMIN‘,‘admin/‘); //后台目录
define(‘PIC‘,‘center/pics/image/‘); //上传图片目录
define(‘BAK‘,‘sqlbak/‘); //备份目录
define(‘HEADGIF‘,‘headgif/‘); //头像目录
define(‘mysqliPATH‘,‘C:\AppServ\MySQL\bin\‘); //mysqli执行文件路径
define(‘mysqliHOST‘,‘localhost‘); //mysqli服务器ip
define(‘mysqliDATA‘,‘db_blog‘); //mysqli数据库
define(‘mysqliUSER‘,‘root‘); //mysqli账号
define(‘mysqliPWD‘,‘111‘); //mysqli密码
$picpostfix = array(‘image/gif‘,‘image/pjpeg‘,‘image/bmp‘); //允许上传的图片后缀
define(‘MAXSIZEPIC‘,500000); //允许上传的图片的最大字节数
?>
数据库连接和定义
标签：
热心网友
时间：2022-04-08 10:56
OleDbConnection cnn=new OleDbConnection("Provider=SQLOLEDB;Data Source=192.168.200.152;User ID=sa;Password=crs252;Initial Catalog=minyoun;");
这样写就行了
你那样属于执行语句，但这里只能放声明语句。
热心网友
时间：2022-04-08 12:14
将“cnn = new OleDbConnection(sql_connection); ”直接放入类范围是不允许的。这是一条语句。
但是改成这样就可以了
const string sql_connection = "Provider=SQLOLEDB;Data Source=192.168.200.152;User ID=sa;Password=crs252;Initial Catalog=minyoun;";
OleDbConnection cnn = new OleDbConnection(sql_connection);
热心网友
时间：2022-04-08 13:49
报什么错呀？
