文章列表
execute
boolean execute()
throws SQLException
Executes the SQL statement in this PreparedStatement object, which may be any kind of SQL statement. Some prepared statements return multiple results; the execute method handles these complex statements as well as the simpler form of state ...
传送给数据库的 SQL 语句通过一个包含两个步骤的过程来返回结果。首先准备它们，然后处理它们。借助 Statement 对象，这两个阶段对应用程序而言变成一个阶段。
PreparedStatement 允许将这两个步骤分开。准备步骤在创建对象时发生，而处理步骤在对 PreparedStatement 对象调用 executeQuery、executeUpdate 或 execute 方法时发生。
prepareStatement
PreparedStatement prepareStatement(String sql,
...
java.sql
Interface Connection
All Superinterfaces:
Wrapper
----------------------------------------------------------------------
public interface Connection extends Wrapper
A connection (session) with a specific database. SQL statements are executed and results are returned within the context ...
1. 建立驱动
2. 连接数据库
3. 发送sql语句
4. 关闭连接
public static final String DBDRIVER = "oracle.jdbc.driver.OracleDriver";
public static final String DBURL = "jdbc:oracle:thin:@192.168.209.82:1521:mySID";
public static final String DBUSER = "scott";
public static final Strin ...