updatedaoimp.java

JAVA视频播放器 源码相当详细 功能强大

package com.video.update.dao.jdbc;

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

import javax.sql.DataSource;

import com.video.update.dao.UpdateDao;

public class UpdateDaoImp implements UpdateDao {
	Connection conn = null;
	private void closeConnection() {
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	@Override
	public int updateSp(DataSource ds, String name, String id, String url,
			String remark) {
		int rs=0;
		try {
			conn = ds.getConnection();
			PreparedStatement ps = conn
			.prepareStatement("update sp set url=?,name=?,remark=? where id=?");			
			ps.setString(1,url);	
			ps.setString(2,name);	
			ps.setString(3,remark);	
			ps.setString(4,id);	
			rs = ps.executeUpdate();
			System.out.println("更新成功"+rs);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally {
			closeConnection();
		}
		return rs;
	}

}