sql 生成类

今天开通，来写点啥

网上看到一sql 生成类，只是不知如何使用

另外一个更方便使用的类，引用了SqlClause

public class SqlSelectStatement{public SqlSelectStatement(){m_Select=new SqlClause("SELECT ","",",");m_From=new SqlClause(" FROM ","",",");m_Where=new SqlClause(" WHERE ",""," AND ");m_Group=new SqlClause(" GROUP BY ","",",");m_Having=new SqlClause(" HAVING ",""," AND ");m_Order=new SqlClause(" ORDER BY ","",",");}

public SqlClause Select{get{return(m_Select);}}

public SqlClause From{get{return(m_From);}}

public SqlClause Where{get{return(m_Where);}}

public SqlClause Group{get{return(m_Group);}}

public SqlClause Having{get{return(m_Having);}}

public SqlClause Order{get{return(m_Order);}}

public override String ToString(){return(m_Select.ToString()+m_From.ToString()+m_Where.ToString()+m_Group.ToString()+m_Having.ToString()+m_Order.ToString());}

private SqlClause m_Select;private SqlClause m_From;private SqlClause m_Where;private SqlClause m_Group;private SqlClause m_Having;private SqlClause m_Order;}