Java 資料庫操作

 

package SQLAction;import java.sql.*;import java.util.*;public class Mysql {private  static Connection conn;private static  java.sql.PreparedStatement stmtdel;public static void  connect() throws Exception {Class.forName("com.mysql.jdbc.Driver");String url = "jdbc:mysql://localhost/bbs";conn = DriverManager.getConnection(url,"root","");stmtdel = conn.prepareStatement("delete from news where id=?");}public static void showAll() throws Exception {String sql = "select * from news";Statement stmt = conn.createStatement();ResultSet result = stmt.executeQuery(sql);System.out.print("---- id ---- title ---- content ----\n");while(result.next()){System.out.print("|   "+result.getString("id")+"|   "+result.getString("title")+"|   "+result.getString("content")+"    |");System.out.println();}} public static void delete(int i ) throws Exception {stmtdel.setInt(1,i);System.out.println(stmtdel.executeUpdate());}public static void deleteAll(int array[]) throws Exception   //執行多個刪除處理  addBatch{for(int i =0;i<array.length;i++){stmtdel.setInt(1,array[i]);stmtdel.addBatch();}int result[]=stmtdel.executeBatch();System.out.println(Arrays.toString(result));}public static void main(String args[])throws Exception {connect();System.out.println("刪除前:");showAll();System.out.println("刪除後:");int array[] = {19,23,25,29,30,31,35};deleteAll(array);showAll();}}