连接表，删除

来源：互联网发布：制作视频软件编辑：程序博客网时间：2024/05/18 00:49

package test.jdbc.one;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class DoDelete {
private Connection conn=null;
private Statement stmt=null;
private String driver="com.mysql.jdbc.Driver";
private String username="root";
private String password="1109";
private String sql="delete from student where id=30";

public boolean deleteStudent(){
boolean flag=false;
try{
  Class.forName(driver);
}catch(ClassNotFoundException e){
  e.printStackTrace();
}
String url="jdbc:mysql://localhost:3306/studb";
try{
  conn=DriverManager.getConnection(url,username,password);
}catch(SQLException e){
  e.printStackTrace();
}
try{
  stmt=conn.createStatement();
  int row=stmt.executeUpdate(sql);
  if(row==1){
   flag=true;
  }
}catch(SQLException e){
  e.printStackTrace();
}finally{
  if(null!=stmt){
   try{
    stmt.close();
   }catch(SQLException e){
    e.printStackTrace();
   }
  }
  if(null!=conn){
   try{
    conn.close();
   }catch(SQLException e){
    e.printStackTrace();
   }
  }
}
return flag;
}
public static void main(String[] args) {
  // TODO Auto-generated method stub
  DoDelete doinsert=new DoDelete();
  boolean flag=doinsert.deleteStudent();
  if(flag){
   System.out.println("shan chu cheng gong！");
  }else{
   System.out.println("shan chu shi bai！");
  }
}