package JDBCDemo;

?import java.sql.DriverManager;
?import java.sql.PreparedStatement;
?import java.sql.ResultSet;
?import java.sql.SQLException;
?import java.sql.PreparedStatement;
?import java.sql.Connection;
?import java.util.ArrayList;
?import java.util.List;

??
?public class JDBCDemo1 {
??
??public static String url="jdbc:mysql://localhost:3306/demo1";
??public static String username="root";
??public static String password="1234";
??
??public static void main(String[] args) {
???
???System.out.println(deletestudent(1));
???
??}
??
??public static int deletestudent(int StuNum){?
???//因?yàn)檫@些變量在try方法中，屬于局部變量，而要在之后的finally語(yǔ)句中再使用，因此將它們定義為全局變量。先讓他們?yōu)閚ull
???Connection connection=null;
???ResultSet resultSet=null;
???PreparedStatement pStatement=null;
???
???int row =0;
???
???
????try {
?????
?????//第一步：注冊(cè)驅(qū)動(dòng) 類,反射：通過(guò)類名把它加載進(jìn)來(lái)
?????Class.forName("com.mysql.jdbc.Driver");
?????//第二步：通過(guò)驅(qū)動(dòng)管理類打開(kāi)一個(gè)連接
?????connection=DriverManager.getConnection(url, username,password);
?????/*//第三步：通過(guò)connection 創(chuàng)建一個(gè)statement對(duì)象（statement：用來(lái)引用sql語(yǔ)句 并執(zhí)行SQL語(yǔ)句）
?????statement = connection.createStatement();*/
?????//sql語(yǔ)句的執(zhí)行
?????String sql="delate from student where StuNum=?";//預(yù)編譯執(zhí)行
?????
?????pStatement=connection.prepareStatement(sql);
?????pStatement.setInt(1,StuNum);
????
?????//執(zhí)行sql語(yǔ)句，返回結(jié)果影響行數(shù)
?????row=pStatement.executeUpdate();
?????
?????
????} catch (ClassNotFoundException e) {
?????// TODO Auto-generated catch block
?????e.printStackTrace();
????} catch (SQLException e) {
?????// TODO Auto-generated catch block
?????e.printStackTrace();
????}finally{
?????
??????try {
???????if(resultSet!=null){
????????resultSet.close();
???????}
???????if(pStatement!=null){
????????pStatement.close();
???????}
???????if(connection!=null){
????????connection.close();
???????}
??????} catch (SQLException e) {
???????// TODO Auto-generated catch block
???????e.printStackTrace();
??????}
?????}
????return row;
??}
?}