现在发现写对数据库操作的语句很多都重复，有没有什么办法给它自动生成呢？

[yzxlyd]

大家在写sql语句的时候还是一个一个字敲进去的吗？还是用其它什么办法？

[yzxlyd]

框架能提供些什么给我们用呢？有哪些比较好一点的框架呢？

[gui0605]

推荐你用《动软.Net代码自动生成器》，只要导入表结构就可以自动生成常用的代码，包括存储过程。

[yzxlyd]

to gui0605() :
　　那个软件只能生成oracle/sql server，我要操作的数据库是mysql，请问还有什么软件可以生成吗？

[an9ryfr09]

我写的一个构造sql的类，不过我觉得还是不够灵活。

/**
* @package Database Class
* @author injection (mail:[e-mail])
* @version 1.0
*/

@ini_set( 'display_errors',0 );
class DataBase{
private $mDb_host,$mAb_user,$mAb_pwd,$mConn_No;

function DataBase( $Conn_Obj ){
$this->connectDb( $Conn_Obj );
}

function connectDb( $Conn_Obj ){
$this->mDb_host = $Conn_Obj->host;
$this->mAd_name = $Conn_Obj->user;
$this->mAd_pwd = $Conn_Obj->pwd;
$this->mConn_No = mysql_connect( $this->mDb_host, $this->mAd_name, $this->mAd_pwd );
}

function selectDb( $Conn_Obj ){
$this->mDb_name = $Conn_Obj->dbname;
mysql_select_db( $this->mDb_name );
}
}

/**
* @package Making Sqls Class exetends Database Class
* @author injection (mail:[e-mail])
* @version 1.0
*/
class MakeSql extends DataBase{
private $mSql;
function MakeSql( $type,$arr_colum_list, $arr_sql_choice ){
$this->MakeSqlType( $arr_colum_list, $arr_sql_choice );
}

#switch make list
function MakeSqlType( $type, $arr_colum_list, $arr_sql_choice ){
switch( $type ){
case 'insert':
return $this->makeInsert( $arr_colum_list, $arr_sql_choice );
case 'select':
return $this->makeSelect( $arr_colum_list, $arr_sql_choice );
case 'update':
return $this->makeUpdate( $arr_colum_list, $arr_sql_choice );
case 'delete':
return $this->makeDelete( $arr_colum_list, $arr_sql_choice );
}
}

#make insert
function makeInsert( $arr_colum_list,$arr_sql_choice ){
$colum_key = array_keys( $arr_colum_list );
$colum_value = array_values( $arr_colum_list );
$this->mSql = "INSERT INTO ".$arr_sql_choice["tbl_name"]."( ".join( ',' , $colum_key )." ) VALUES( '".join( "','" , $colum_value )."')";
return $this->mSql;
}

#making select
function makeSelect( $arr_colum_list = '*' , $arr_sql_choice ){
$colum_value = array_keys( $arr_colum_list );

foreach( $arr_sql_choice as $sql_key => $sql_value ){
if( strcmp( $sql_key, 'tbl_name' ) == 0 ){
if( strcmp($arr_colum_list, '*' ) !== 0 )
$this->mSql = "SELECT ".join( ',' , $colum_value )." FROM ".$sql_value;
else
$this->mSql = "SELECT * FROM ".$sql_value;
}
else
if( strcmp( $sql_value, '' ) !== 0 )
if(strcmp( $sql_key, 'WHERE' ) === 0 && strcmp( $sql_value, 'colum' ) === 0 ){
foreach($arr_colum_list As $colum_key => $colum_value )
$this->mSql .= "$colum_key = '$colum_value' AND ";
$this->mSql = rtrim( $this->mSql, " AND " );
}
else
$this->mSql .= " $sql_key ".$sql_value;
}
return $this->mSql;
}

#making update
function makeUpdate( $arr_colum_list, $arr_sql_choice ){
$this->mSql = "UPDATE ".$arr_sql_choice['tbl_name']." SET ";
foreach( $arr_colum_list as $colum_key => $colum_value )
$this->mSql .= "$colum_key = '$colum_value',";
$this->mSql = rtrim( $this->mSql , ',');
foreach( $arr_sql_choice as $sql_key => $sql_value ){
if( strcmp( $sql_value, '' ) !== 0 && strcmp( $sql_key, 'tbl_name' ) !==0 && strcmp( $sql_key, 'ORDER BY' ) !== 0 )
$this->mSql .= " $sql_key ".$sql_value;
}
return $this->mSql;
}

#making delete
function makeDelete( $arr_colum_list, $arr_sql_choice ){
$this->mSql = "DELETE FROM ".$arr_sql_choice['tbl_name'];
foreach( $arr_sql_choice as $sql_key => $sql_value ){
if( strcmp( $sql_key, 'tbl_name' ) !== 0 && strcmp( $sql_value, '' ) !== 0 ){
$this->mSql .= " $sql_key ".$sql_value;
}
}
return $this->mSql;
}
}

[an9ryfr09]

可以这样来调用:

require_once('Database.php');
class test{
var $host,$Dbname,$user,$pwd;
function test( $host,$Dbname,$user,$pwd ){
$this->host = $host;
$this->Dbname = $Dbname;
$this->user = $user;
$this->pwd = $pwd;
}
}

$conn = new test( 'localhost','test','root','root');

$colum = array(
"user" => "admin",
"pass" => "admin000",
"email" => "[e-mail]"
);

$choice = array(
"tbl_name" => "test",
"WHERE" => "user <> ''",
"ORDER BY" => "id desc",
"LIMIT" => "30"
);

$getSql = new MakeSql( $conn );
$getSql->selectDb( $conn );
echo $getSql->MakeSqlType( 'insert', $colum, $choice );

[xuzuning]

永远都不要期望用某个算法去覆盖整个宇宙
细微的差别可能产生相反的结果——正所谓“失之毫厘，谬之千里”

对于具体的项目，完全可以集中书写所需的sql语句

只在提供动态查询的系统中才需要动态构造查询串

[iasky]

写成一个类或者函数

[lantersen]

下面的可能你能用上：
http://www.pearchina.com/modules/webtrans/category.php?cat_id=6
--看来我们CODE前，需要更多的分析，便于节省维护时间与开销--题外话--

[yzxlyd]

to lantersen(蓝水仁--我们的选择是做或不做,但不做将永远没有机会) :
你指的是哪个？

[an9ryfr09]

现在的开发框架都会有一些生成sql语句的类或方法。
当然你也可以自己写一个，难度不是特别大。就是传一些参数进去，如表名，字段名。然后将一些固定形式的语句与这些参数连接起来。

[zysoft17]

http://zsss.blog.sohu.com/7966496.html
http://zsss.blog.sohu.com/7965210.html
http://zsss.blog.sohu.com/8254219.html

[PleaseDoTellMeWhy]

楼上的哥们的代码我收藏了,闲了研究下,谢谢啊!