JDBC為什么查詢語句使用StringBuilder
JDBC為什么查詢語句使用StringBuilder，
StringBuilder sb=new StringBuilder();
sb.append("select * from imooc_goddess ?");
sb.append(" where user_name like ? and mobile like ? and email like ?");
PreparedStatement ptmt=conn.prepareStatement(sb.toString());
必須使用StringBuilder嗎？可不可以直接像增刪改類似的
String sql="" +
"insert into imooc_goddess" +
"(user_name,sex,age,birthday,email,mobile," +
"create_user,create_date,update_user,update_date,isdel)" +
"values(" +
"?,?,?,?,?,?,?,current_date(),?,current_date(),?)";
PreparedStatement ptmt=conn.prepareStatement(sql);
寫成
String sql="" +
" select * from imooc_goddess " +
" where user_name like ? and mobile like ? and email like ? ";
PreparedStatement ptmt=conn.prepareStatement(sql);
有什么講究嗎？
2018-02-22
試著寫了一下，兩種都對的。
String sql="" +
" select * from imooc_goddess" +
" where user_name like ? and mobile like ? and email like ? ";
System.out.println("sql:"+sql);
PreparedStatement ptmt=conn.prepareStatement(sql);