PreparedStatement

We have noticed that it's very inconvenient to use class Statement to execute aSQL statement.

So we have another solution which is PreparedStatement.

PreparedStatement ps=conn.prepareStatement("...... ");

ps.setInt(... , ...);

ps.setString(... , ....);

....then

ps.execute();

--->It's easy to use...

要查询数据,必须将类型写全,不能用select * from ....