src/com/inloam/common/BaseDAO.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.inloam.common;

import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;


public  class BaseDAO {

	private Connection  connection;

	private String tableName;
	
	
	private Sql sql;
	

	
	public void saveOrUpdate(Map bean,Connection  conn,String tableName) {
		Map obj = findbyId((String)bean.get("id"), tableName, conn);
		if(obj == null)
			save(bean, conn, tableName);
		else
			update(bean, conn, tableName);
	}

	public void update(Map bean,Connection  conn,String tableName) {
		String id = bean.get("id").toString();
		bean.remove("id");
		sql = new Sql(tableName);
		String colunm[] = sql.getColunm(bean);
		String updateSql = sql.getUpdateSql(colunm);
		System.out.println(updateSql);
		PreparedStatement pst = null;
		try {
			pst = conn.prepareStatement(updateSql);
			buldPrepareStatement(bean, colunm, pst);
			pst.setString(colunm.length+1,id);
			pst.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			try {
				if(pst != null)
					pst.close();
				if(conn != null)
					conn.close();