JDBC--使用statement接口实现删除数据

package model;
/**
 * 个人信息 
 * @author MC-DS
 *
 */

public class Person {

	private int id;
	private String personName;
	private int age;
	
	
	
	public Person(int id, String personName, int age) {
		super();
		this.id = id;
		this.personName = personName;
		this.age = age;
	}
	public Person(String personName, int age) {
		super();
		this.personName = personName;
		this.age = age;
	}
	public int getId() {	
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getPersonName() {
		return personName;
	}
	public void setPersonName(String personName) {
		this.personName = personName;
	}
	public Integer getAge() {
		return age;
	}
	public void setAge(int age) {
		this.age = age;
	}
	
}

package jdbc.util;

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

public class DbUtil {

	//数据库地址
	private static String dbUrl="jdbc:mysql://localhost:3306/mybatis_db";
	//用户名
	private static String dbUserName="root";
	//密码
	private static String dbPassword="DANDA2012";
	//驱动名称
	private static String jdbcName="com.mysql.jdbc.Driver";
	/**
	 * 获取数据库连接
	 * @return
	 * @throws Exception
	 */
	
	public Connection getCon()throws Exception{
		Class.forName(jdbcName);
		Connection con=DriverManager.getConnection(dbUrl, dbUserName,dbPassword);
		return con;
	}
	
	/**
	 * 关闭连接
	 * @param con
	 * @throws Exception
	 */
	public void close(Statement stmt,Connection con)throws Exception{
		if(stmt!=null){
			stmt.close();
			if(con!=null){
				con.close();
			}

		}
			}
}

package jdbc.chap03;

import java.sql.Connection;
import java.sql.Statement;

import jdbc.util.DbUtil;

public class Demo04 {
	
	private static DbUtil dbUtil=new DbUtil();
	/**
	 * 删除个人信息
	 * @param id
	 * @return
	 * @throws Exception
	 */
	
	private static int deleteperson(int id)throws Exception{
		Connection con=dbUtil.getCon();//获取连接
		String sql="delete from t_student where id="+id;
		Statement stmt=con.createStatement();//创建Statement
		int result=stmt.executeUpdate(sql);
		dbUtil.close(stmt, con);//关闭Statement和连接
		return result;
		
	}
	public static void main(String[] args) throws Exception {
		int result=deleteperson(657);
		if(result==1){
			System.out.println("删除成功了！");
		}else {
			System.out.println("删除失败！");
		}
	}
}

删除成功了！