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;
}