JavaWeb上机实验2 数据库访问（二）

package 实验二; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.SQLException; import com.mchange.v2.c3p0.ComboPooledDataSource; public class StudentDelete { public static void main(String[] args) throws SQLException { ComboPooledDataSource cd=new ComboPooledDataSource("hlp"); Connection conn = cd.getConnection(); String sql="delete from student where sname=?"; PreparedStatement pstat=conn.prepareStatement(sql); //给？指定具体的值 pstat.setString(1, "wangwu2"); //执行删除操作 int flag = pstat.executeUpdate(); if(flag>0) { System.out.println("删除成功"); }else { System.out.println("删除失败"); } pstat.close(); conn.close(); } }