updatecontroller.java

使用annotation封装的jdbc

package cn.cja.dao;

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

import cn.cja.sql.Update;

public class UpdateController extends BaseAnnotationController {

	public UpdateController() {
	}

	public int update(Update update, Connection connection, Object[] params) throws SQLException {
		PreparedStatement ps = null;
		ResultSet rs = null;

		try {
			ps = connection.prepareStatement(update.value());
			bindParams(ps, params);
			return ps.executeUpdate();
		} finally {
			if (rs != null) {
				try {
					rs.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
			if (ps != null) {
				try {
					ps.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		}
	}
}