Question

如何查询mysql?在jsp中定义了字符串a,要怎么在jsp中写查询语句?

String sql="SELECT * FROM 表 where 段="a"";
ResultSet rs=stmt.executeQuery(sql);
这样不行?

Answer 1

String sql="SELECT * FROM 表 where 段='"+a+"'";

Answer 2

String sql="SELECT * FROM 表 where 段='a'";