JDBC1连接MySQL数据库并获取数据（常用封装）

封装Insert,update,delete[Statement版]

/**
* 执行 Insert delete update方法
*/
public static int executeUpdate(String sql) {
	Connection conn = null;
	int flag = 0;
	Statement stmt = null;
	try {
		conn = JdbcUtil.getConnection();
		stmt = conn.createStatement();
		flag = stmt.executeUpdate(sql);
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}finally {
		JdbcUtil.closeAll(conn, stmt, null);
	}
	return flag;
}

封装Insert,update,delete[PreparedStatement版]

/**
* 用于操作insert ,update ,delete语句，
* @param sql 动态sql
* @param objects 为可变参数，对应动态sql中的值
* @return
*/
public static int executeUpdate2(String sql,Object...objects ) {
	int flag =0;
	Connection conn = null;
	PreparedStatement pstmt = null;
	try {
		conn = JdbcUtil.getConnection();
		pstmt = conn.prepareStatement(sql);
		if(objects!=null) {
			for(int i=1;i<=objects.length;i++) {
				pstmt.setObject(i, objects[i-1]);
			}
		}
		flag = pstmt.executeUpdate();
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}finally {
		JdbcUtil.closeAll(conn, pstmt, null);
	}
	return flag;
}

分装查询

/**
*
* @param sql
* @param objects
* @return 长度为0没有查询结果
*/
public static List<Map> executeQuery(String sql,Object...objects){
	List<Map> result = new ArrayList<Map>();
	Connection conn = null;
	PreparedStatement pstmt = null;
	ResultSet rs = null;
	try {
		conn = JdbcUtil.getConnection();
		pstmt = conn.prepareStatement(sql);
		if(objects!=null) {
			for (int i=1;i<=objects.length;i++) {
				pstmt.setObject(i, objects[i-1]);
			}
		}
		rs = pstmt.executeQuery();
		ResultSetMetaData metaData = rs.getMetaData();
		int countColumn = metaData.getColumnCount();
		while(rs.next()) {
			Map map = new HashMap();
			for(int i=1;i<=countColumn;i++) {
				map.put(metaData.getColumnLabel(i), rs.getObject(i));
			}
			result.add(map);
		}
	} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally {
			JdbcUtil.closeAll(conn, pstmt, rs);
		}
		return result;
	}