import
java.sql.
*
;
public class UsePreparedStatement {
public static void main(String[] args) {
String url = " jdbc:mysql://localhost/sql_test " ;
String userName = " root " ;
String password = " root " ;
Connection conn = null ;
try {
Class.forName( " com.mysql.jdbc.Driver " );
} catch (ClassNotFoundException e) {
System.out.println( " 加载驱动器类时出现异常 " );
}
try {
conn = DriverManager.getConnection(url, userName, password);
// 创建PreparedStatement语句
PreparedStatement pstmtDelete = conn.prepareStatement(
" DELETE FROM student WHERE stu_id>=? " );
PreparedStatement pstmtInsert = conn.prepareStatement(
" INSERT INTO student VALUES(?, ?, ?, ?) " );
PreparedStatement pstmtSelect = conn.prepareStatement(
" SELECT * FROM student WHERE stu_id>=? " +
" ORDER BY stu_id " );
int Integer.toString(id));
// 多次执行同一语句
for ( int i = 0 ; i < 3 ; i ++ , id ++ ) {
// 使用setXXX方法设置IN参数
pstmtDelete.setString( 1 , Integer.toString(id));
pstmtInsert.setString( 1 , Integer.toString(id));
pstmtInsert.setString( 2 , " name " + id);
pstmtInsert.setString( 3 , " city " + id);
pstmtInsert.setDate( 4 , new Date( 78 , 2 , id));
// 执行PreparedStatement语句
pstmtDelete.executeUpdate();
pstmtInsert.executeUpdate();
ResultSet rs = pstmtSelect.executeQuery();
System.out.println( "" );
System.out.println( " 第 " + (i + 1 ) + " 次循环后的结果集为: " );
// 显示返回的结果集
while (rs.next()) {
String stuID = rs.getString( 1 );
String String address = rs.getString( 3 );
String birthday = rs.getString( 4 );
System.out.println(stuID + " " +
name + " " + address + " " + birthday);
}
}
pstmtDelete.close();
pstmtInsert.close();
pstmtSelect.close();
} catch (SQLException e) {
System.out.println( " 出现SQLException异常 " );
} finally {
// 关闭语句和数据库连接
try {
if (conn != null ) conn.close();
} catch (SQLException e) {
System.out.println( " 关闭数据库连接时出现异常 " );
}
}
}
}
public class UsePreparedStatement {
public static void main(String[] args) {
String url = " jdbc:mysql://localhost/sql_test " ;
String userName = " root " ;
String password = " root " ;
Connection conn = null ;
try {
Class.forName( " com.mysql.jdbc.Driver " );
} catch (ClassNotFoundException e) {
System.out.println( " 加载驱动器类时出现异常 " );
}
try {
conn = DriverManager.getConnection(url, userName, password);
// 创建PreparedStatement语句
PreparedStatement pstmtDelete = conn.prepareStatement(
" DELETE FROM student WHERE stu_id>=? " );
PreparedStatement pstmtInsert = conn.prepareStatement(
" INSERT INTO student VALUES(?, ?, ?, ?) " );
PreparedStatement pstmtSelect = conn.prepareStatement(
" SELECT * FROM student WHERE stu_id>=? " +
" ORDER BY stu_id " );
int Integer.toString(id));
// 多次执行同一语句
for ( int i = 0 ; i < 3 ; i ++ , id ++ ) {
// 使用setXXX方法设置IN参数
pstmtDelete.setString( 1 , Integer.toString(id));
pstmtInsert.setString( 1 , Integer.toString(id));
pstmtInsert.setString( 2 , " name " + id);
pstmtInsert.setString( 3 , " city " + id);
pstmtInsert.setDate( 4 , new Date( 78 , 2 , id));
// 执行PreparedStatement语句
pstmtDelete.executeUpdate();
pstmtInsert.executeUpdate();
ResultSet rs = pstmtSelect.executeQuery();
System.out.println( "" );
System.out.println( " 第 " + (i + 1 ) + " 次循环后的结果集为: " );
// 显示返回的结果集
while (rs.next()) {
String stuID = rs.getString( 1 );
String String address = rs.getString( 3 );
String birthday = rs.getString( 4 );
System.out.println(stuID + " " +
name + " " + address + " " + birthday);
}
}
pstmtDelete.close();
pstmtInsert.close();
pstmtSelect.close();
} catch (SQLException e) {
System.out.println( " 出现SQLException异常 " );
} finally {
// 关闭语句和数据库连接
try {
if (conn != null ) conn.close();
} catch (SQLException e) {
System.out.println( " 关闭数据库连接时出现异常 " );
}
}
}
}