StringBuilder（）

StringBuilder

(1)用法:StringBuilder对象则代表一个字符序列可变的字符串，当一个StringBuilder被创建以后，通过StringBuilder提供的append()、insert()、reverse()、setCharAt()、setLength()等方法可以改变这个字符串对象的字符序列。一旦通过StringBuffer生成了最终想要的字符串，就可以调用它的toString()方法将其转换为一个String对象。

(2):示例

//示例
StringBuilder sql = new StringBuilder("SELECT i.type,i.video_image_url as videoImageUrl,i.published,i.id,common_problem as commonProblem,i.module_id as moduleId,i.description,i.created_time as createdTime,title,m.name as moduleName from help_information i left join help_module m on i.module_id=m.id ");
StringBuilder where = new StringBuilder();
where.append(" where common_problem = ?");
sql.append(where.toString());

另：补充几种join的方法

1.INNER JOIN

SELECT <select_list> FROM Table_A A INNER JOIN Table_B B ON A.Key = B.Key

（其中A,B是Table_A,Table_B的别名，<select_list>为要查询的字段，可以是一个，也可以是多个）

2.LEFT JOIN

SELECT <select_list> FROM Table_A A LEFT JOIN Table_B B ON A.Key = B.Key

3.RIGHT JOIN

SELECT <select_list> FROM Table_A A RIGHT JOIN Table_B B ON A.Key = B.Key

4.FULL JOIN

SELECT <select_list> FROM Table_A A FULL JOIN Table_B B ON A.Key = B.Key