deletedaoimp.java

来自「JAVA视频播放器 源码相当详细 功能强大」· Java 代码 · 共 41 行

package com.video.delete.dao.jdbc;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import javax.sql.DataSource;

import com.video.delete.dao.DeleteDao;

public class DeleteDaoImp implements DeleteDao {
	Connection conn = null;
	private void closeConnection() {
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	@Override
	public int deleteSp(DataSource ds, String id) {
		int rs=0;
		try {
			conn = ds.getConnection();
			PreparedStatement ps = conn
			.prepareStatement("delete from sp where id=?");			
			ps.setString(1,id);	
			rs = ps.executeUpdate();
			System.out.println("删除成功"+rs);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally {
			closeConnection();
		}
		return rs;
	}

}